Knowledge Base

How To Make A Trusted SQL Server DSNLESS Connection

Article ID: 194641

Article Last Modified on 7/1/2004

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="

REFERENCES

For more information about connecting to Microsoft SQL Server or database technology please refer to your Microsoft Visual Basic documentation or visit the Universal Data Access Web site at:

http://msdn.microsoft.com/dataaccess

Additional query words: kbDSupport kbdse login account connecting kbODBC kbVBp400 kbVBp500 kbVBp600

Keywords: kbhowto KB194641