ODBC Data Source
The ODBC Data Source view shows ODBC data sources included in the MSI package. These entries ensure that required database connections (for example SQL Server, Oracle, or Access) are configured automatically during installation.
DSN registration type
| Type | Scope | Storage |
|---|---|---|
| System DSN | Available to all users on the computer | Machine-wide registry |
| User DSN | Available only to the user who installed the MSI | Current user registry |
Connection properties
| Field | Description |
|---|---|
| Data Source Name (DSN) | Name that applications use to identify the connection. |
| Description | Short description of the data source. |
| Driver | ODBC driver the data source uses. |
| Server | Database server address. |
| Database | Database name the DSN points to. |
| Attributes | Additional settings such as user ID (UID), password (PWD), or custom parameters. |
MSI tables
The ODBC configuration is stored across three MSI tables:
| Table | Purpose |
|---|---|
| ODBCDataSource | Stores the ODBC data source entry. |
| ODBCDriver | Stores the related ODBC driver information. |
| ODBCTranslator | Stores translator information used by ODBC when needed. |
note
Verify that the required ODBC drivers exist on the target machine. Otherwise, the installed DSN entries may not work.