VB6 and SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emma - 27 Oct 2006 20:18 GMT

How do I connect to SQL Server 2005 from within VB? I am currently using the
collowing connection string:

"Driver={SQL
Server};Server=ServerName;Database=MyDBName;Uid=UserName;Pwd=MyPWD;"

thanks
Emma

Reply to this Message

Ralph - 27 Oct 2006 20:36 GMT

> How do I connect to SQL Server 2005 from within VB? I am currently using the
> collowing connection string:
[quoted text clipped - 4 lines]
> thanks
> Emma

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

VB6 and SQL 2005