Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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
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.
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:
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:
Article ID: 194641 - Last Review: July 1, 2004 - Revision: 3.2