InstallODBC Action
The InstallODBC action installs the drivers, translators, and data sources in the ODBCDriver Table, ODBCTranslator Table, and ODBCDataSource Table. If a driver or translator already exists, the InstallODBC action makes SQL calls necessary for the installation.
Sequence Restrictions
The InstallODBC action does not copy or remove files, and must be after actions that copy or remove files.
ActionData Messages
The following table identifies the ActionData messages for each installed driver.
| Field | Description |
|---|---|
| [1] | Driver description. The ODBC driver key. |
| [2] | ComponentId. |
| [3] | Folder. |
| [4, 5, …] | Attribute and value pairs from ODBCAttribute. |
The following table identifies the ActionData messages for each installed translator.
| Field | Description |
|---|---|
| [1] | Driver description. The ODBC driver key. |
| [2] | ComponentId. |
| [3] | Folder. |
| [4, 5, …] | Attribute and value pairs from ODBCAttribute. |
The following table identifies the ActionData messages for each installed data source.
| Field | Description |
|---|---|
| [1] | Driver description. The ODBC driver key. |
| [2] | ComponentId. |
| [3] | Registration: ODBC_ADD_DSN or ODBC_ADD_SYS_DSN. |
| [4, 5, …] | Attribute and value pairs from ODBCAttribute. |
Remarks
The ODBC Driver Manager must be authored in the Microsoft Installer package and a component named ODBCDriverManager must be included. The manager is installed if necessary.
To rename the component, set a property named ODBCDriverManager to the new name of the component. If a 64-bit ODBC Driver Manager is to be installed, the component that carries it should be named ODBCDriverManager64.
- The InstallODBC action queries the ODBCDataSource Table and the ODBCSourceAttribute Table for each data source to be installed, and the attributes of the data source.
- The InstallODBC action queries the ODBCDriver Table and the ODBCTranslator Table for each driver and translator that is selected for installation.
- The InstallODBC action queries the ODBCAttribute Table for the attributes of the drivers and translators.
Related topics