homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

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

 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?



 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.


 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..?


 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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved