Welcome to WebmasterWorld Guest from 54.196.104.66

Forum Moderators: open

Message Too Old, No Replies

Connecting to SQL with ODBC issue

can i connect to a remote DB?

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

Junior Member

10+ Year Member

joined:Apr 15, 2004
posts:42
votes: 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?

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2003
posts:1184
votes: 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.

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

Junior Member

10+ Year Member

joined:Apr 15, 2004
posts:42
votes: 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..?
2:13 pm on Nov 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2003
posts:1184
votes: 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.