Connecting to SQL with ODBC issue

can i connect to a remote DB?

[jmdb71]

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]

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]

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]

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.