The ODBCDataSource table lists the data sources belonging to the installation.
The ODBCDataSource table has the following columns.
| Column | Type | Key | Nullable |
|---|---|---|---|
| DataSource | Identifier | Y | N |
| Component_ | Identifier | N | N |
| Description | Text | N | N |
| DriverDescription | Text | N | N |
| Registration | Integer | N | N |
Columns
DataSource
Internal token name for data source. A primary key for the table.
Component_
External key into the Component table.
Description
The description registered for this data source. This value cannot be localized. ODBC data source descriptions cannot exceed SQL_MAX_DSN_LENGTH.
DriverDescription
Associated driver which may be pre-existing. This value cannot be localized.
Registration
This field specifies the type of registration for the data source.
| Constant | Hexadecimal | Decimal | Description |
|---|---|---|---|
| msidbODBCDataSourceRegistrationPerMachine | 0x000 | 0 | Data source is registered per machine. |
| msidbODBCDataSourceRegistrationPerUser | 0x001 | 1 | Data source is registered per user. |
Remarks
The InstallODBC and RemoveODBC actions in sequence tables process the information in this table. For information about using sequence tables, see Using a Sequence Table.
Validation
Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
