HOWTO: Make A Trusted SQL Server DSNLESS Connection

• Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 5.0, 6.0
• Microsoft Visual Basic Standard, Professional, and Enterprise Editions, 32-bit only, for Windows, version 4.0

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://www.microsoft.com/data/

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

Keywords : kbGrpVBDB
Version : WINDOWS:4.0,5.0,6.0
Platform : WINDOWS
Issue type : kbhowto