ODBC Connections

This article details the way to manage ODBC connections manually using the registry.

These registry entries can be added in an installation package (in a MSI, MST, or imported using a script).

No reboot or log-off / logon is required.

.

Create a New Data Source to SQL Server

.

Registry

Create a .reg file with the following content:

.

User Interface

odbc01

 

odbc02

 

odbc03

.

Using a Trusted Connection

To use Trusted Connection, add the following registry:

odbc04