View Single Post
  #2 (permalink)  
Old February 10th, 2005, 08:33 AM
madhukp madhukp is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Cochin, Kerala, India.
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp
Default

You may use the following connection string.

Provider=SQLOLEDB;DATA SOURCE=<IP Address of server>;UID=<username>;PWD=<password>; DATABASE=<db name>

Where

IP Address - IP address of db server
Username - username to connect to db server
Password - password to connect to db server
DB Name - name of the database