Microsoft KB Archive/194641

= How To Make A Trusted SQL Server DSNLESS Connection =

Article ID: 194641

Article Last Modified on 7/1/2004

-

APPLIES TO


 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition
 * Microsoft Visual Basic 4.0 Standard Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 32-Bit Enterprise Edition

-



This article was previously published under Q194641



SUMMARY
When connecting to a Microsoft SQL Server using a DSN, an option or checkbox (depending on the version of the ODBC Driver) is available to use a Trusted Connection (or Integrated Security).

This option is not available as a parameter for DSNLESS connections.



MORE INFORMATION
To make a DSNLESS connection using a trusted connection to SQL Server, set the UID and PWD parameters equal to NULL. This will force the ODBC driver to connect using a trusted connection instead of SQL Server Authentication.

Below is an example of the connection string needed to create a Trusted Connection:

Dim Connect As String Connect="Driver={SQL Server};Server=TestServer;Database=Pubs;UID=;PWD="

