Select the product you need help with

How To Make A Trusted SQL Server DSNLESS Connection

Article ID: 194641 - View products that this article applies to.

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.

Back to the top | Give Feedback

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

Back to the top | Give Feedback

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/en-us/data/aa937729.aspx

(http://msdn.microsoft.com/en-us/data/aa937729.aspx)

Back to the top | Give Feedback