ODBCDataSource Table

From Windows Installer

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

Send comments about this topic to Microsoft

Build date: 8/13/2009

© 2009 Microsoft Corporation. All rights reserved.