ODBCDataSource Table (Windows)

ODBCDataSource Table

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

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.

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.

Build date: 6/5/2008