homepage Welcome to WebmasterWorld Guest from 107.22.70.215
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Connecting to SQL with ODBC issue
can i connect to a remote DB?
jmdb71




msg:1579199
 9:46 pm on Nov 9, 2005 (gmt 0)

I have an online store with an orders database. i want to pull the customer address info from the DB into UPS Worldship, which i know is possible.

Worldship uses ODBC to establish a connection with the DB. it was very confusing, as the map just asked for the server name, username and password. it did not ask for the database name, which confused me, as you could have multiple DBs under one IP, each with different login info.

I could not get the connect to work. Anyone had any experience with this, or any suggestions?

 

Easy_Coder




msg:1579200
 9:10 pm on Nov 10, 2005 (gmt 0)

yeah, I have.

I wrote a little utility that pulled my order crud down from a remote database to a local machine as a .net dataset. Then I bound that stuff to a spreadsheet. The users import the spreadsheet into Worldship so they don't have to manually enter the orders. Sounds like the exact same thing you're doing.

jmdb71




msg:1579201
 9:33 pm on Nov 10, 2005 (gmt 0)

appreciate the reply. ups had said they have setup a system where you can enter the ordernumber in worldship and pull all the info that way. our problem is being able to connect to the DB. How did you do this? all the ODBC asks for is server name, username and password. But a server can have several DBs, so im not sure what info to put here. ive tried the server name, and DB login info with no luck as well as the server login info..?

Easy_Coder




msg:1579202
 2:13 pm on Nov 11, 2005 (gmt 0)

I contacted the UPS rep and they we're more then happy to come in and handle the map from my spreadsheet to worldship which appeared to be backended by access.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved