General discussion

Locked

Creation of System DSN ODBC drivers

By D.C. ·
I need to automatically create a System DSN ODBC driver.

Any ideas on how to do this?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creation of System DSN ODBC drivers

by Aramis In reply to Creation of System DSN OD ...

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

Collapse -

Creation of System DSN ODBC drivers

by D.C. In reply to Creation of System DSN OD ...

sorry, not really looking for code

Collapse -

Creation of System DSN ODBC drivers

by D.C. In reply to Creation of System DSN OD ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums