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
Send comments about this topic to Microsoft
Build date: 8/13/2009
© 2009 Microsoft Corporation. All rights reserved.