Accessing SQL Server 2005 With VB6.0 ADO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert E. Flaherty - 24 Oct 2006 23:04 GMT

The connection string that I have been using to connect to SQL Server 2000
is like the following:

provider=sqloledb.1;Persist Security Info=False;Data Source=MyServer;Initial
Catalog=MyDatabase;User ID=MyUsername;Password=MyPassword;

What changes would I need to make to the above connection string in order to
be able to access SQL Server 2005?

Reply to this Message

Ralph - 25 Oct 2006 12:53 GMT

> The connection string that I have been using to connect to SQL Server 2000
> is like the following:
[quoted text clipped - 4 lines]
> What changes would I need to make to the above connection string in order to
> be able to access SQL Server 2005?

http://www.connectionstrings.com/

Also check out the "Using Data Link" topic in the Windows Help file
(Start->Help). Udl provides a simple mechanism for building and testing
connection strings for your domain. When you are done, open the file in
notepad and copy the connection string into your program.

hth
-ralph

Reply to this Message

VB Forum / Database Access / October 2006

Accessing SQL Server 2005 With VB6.0 ADO