Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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