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

ICE03
ICE06
ICE32
ICE45
ICE98