VB/SQL Server 2005 connection string, Windows authentication
- 0
I have an old Word 2000 macro (VB6 script). It connected to Server 2000 database using server authentication.
Now I want to connect to a Server 2005 db, using Windows authentication if possible. The old string that worked is:
Provider=SQLOLEDB;Data Source='(local)';Initial Catalog='<catalog name>';User ID='sa';Password='<sa's password>'
Can I use Windows authentication? If so, what do I use for [User ID] and [Password]? I tried '' for both and it didn't work.
Moreover, where in the world can I find a comprehensive discussion on how to use and setup these blasted connection strings? I've been to www.connectionstrings.com and it's just a bit sparse on details...
Answers
- 0
You should be able to replace it with:
Provider=SQLOLEDB;Data Source='(local)';Initial Catalog='<catalog name>';Integrated Security = SSPI;
