Discussion Locked

Creation of System DSN ODBC drivers

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to automatically create a System DSN ODBC driver.

Any ideas on how to do this?

3 replies

by aramis

Use a DSNLESS connection.

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

This discussion is closed to new replies.