ODBCDataSource Table (Windows)

MSDN Home

MSDN
MSDN Library
Win32 and COM Development
Administration and Management
Application Installation and S ...
Windows Installer
Windows Installer Reference
Installer Database
Installer Database Reference
Database Tables

Database Tables

Column Data Types
_RowState Column
ActionText Table
AdminExecuteSequence Table
AdminUISequence Table
AdvtExecuteSequence Table
AdvtUISequence Table
AppId Table
AppSearch Table
BBControl Table
Billboard Table
Binary Table
BindImage Table
CCPSearch Table
CheckBox Table
Class Table
ComboBox Table
CompLocator Table
Complus Table
Component Table
Condition Table
Control Table
ControlCondition Table
ControlEvent Table
CreateFolder Table
CustomAction Table
Dialog Table
Directory Table
DrLocator Table
DuplicateFile Table
Environment Table
Error Table
EventMapping Table
Extension Table
Feature Table
FeatureComponents Table
File Table
FileSFPCatalog Table
Font Table
Icon Table
IniFile Table
IniLocator Table
InstallExecuteSequence Table
InstallUISequence Table
IsolatedComponent Table
LaunchCondition Table
ListBox Table
ListView Table
LockPermissions Table
Media Table
MIME Table
MoveFile Table
MsiAssembly Table
MsiAssemblyName Table
MsiDigitalCertificate Table
MsiDigitalSignature Table
MsiEmbeddedChainer Table
MsiEmbeddedUI Table
MsiFileHash Table
MsiLockPermissionsEx Table
MsiPackageCertificate Table
MsiPatchCertificate Table
MsiPatchHeaders Table
MsiPatchMetadata Table
MsiPatchOldAssemblyFile Table
MsiPatchOldAssemblyName Table
MsiPatchSequence Table
MsiServiceConfig Table
MsiServiceConfigFailureActions ...
MsiSFCBypass Table
MsiShortcutProperty Table
ODBCAttribute Table
ODBCDataSource Table
ODBCDriver Table
ODBCSourceAttribute Table
ODBCTranslator Table
Patch Table
PatchPackage Table
ProgId Table
Property Table
PublishComponent Table
RadioButton Table
Registry Table
RegLocator Table
RemoveFile Table
RemoveIniFile Table
RemoveRegistry Table
ReserveCost Table
SelfReg Table
ServiceControl Table
ServiceInstall Table
SFPCatalog Table
Shortcut Table
Signature Table
TextStyle Table
TypeLib Table
UIText Table
Upgrade Table
Verb Table
_Columns Table
_Storages Table
_Streams Table
_Tables Table
_TransformView Table
_Validation Table

Switch View :

Lightweight Beta

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

Send comments about this topic to Microsoft

Build date: 11/12/2009

Tags :