ODBCDataSource Table
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