ODBC Resource Settings

InstallShield 2019

Project • The ODBC Resources view is available in the following project types:

Basic MSI
DIM
InstallScript MSI
Merge Module
MSI Database
MSM Database
Transform

There is no universal list of ODBC resource attributes and their possible values. Check with the file’s vendor or author if you are unsure about what to specify for its installation. Some attributes are common to each type of ODBC resource, as described below.

Note • You can add your own ODBC attribute by clicking in the last row of the grid in the ODBC Resources view and specifying the property and value.

Drivers

In addition to the required attributes below, the driver must have a name in the tree. This name is registered as the driver’s description. The driver’s name cannot be localized, which means that it does not appear as one of your project’s string entries. Because of this, the same value is used regardless of the system’s language.

ODBC Driver Attributes

Attribute

Expected Value

Driver Component

Enter the name of the component that you want to install the selected ODBC driver and its attributes.

Driver DLL

Enter the path to the DLL file that is on the development system and that serves as the ODBC driver, or click the ellipsis button (...) to browse to the file. This file is included in the component that is identified in the Driver Component setting. It is recommended that you have only one DLL per component; therefore, if you select a different DLL, delete the previous one from the Components view.

Setup Component

Enter the name of the component that you want to install the setup DLL for the ODBC driver. Usually, this component is the same one as the component for the driver if the setup code is in the same DLL.

Setup DLL

Enter the path to the setup DLL on the development system, or click the ellipsis button (...) to browse to the file. This file is included in the component that is identified in the Setup Component setting. If the driver file is also the setup DLL, you can leave this setting blank. It is recommended that you have only one DLL per component; therefore, if you select a different DLL, delete the previous one from the Components view.

Data Sources

In addition to the required attributes below, the DSN must have a name in the tree. This name is registered as the DSN’s description. The DSN’s name cannot be localized, which means that it does not appear in your project’s list of string entries. Because of this, the same value is used regardless of the system’s language.

Required Data Source Attributes

Attribute

Expected Value

Registration

Specify whether you want to use a system data source or a user data source.

System data source—The data source is available to all users on the system.
User data source—The data source is registered only for the current user.

Translators

In addition to the required attributes below, the translator must have a name in the tree. This name is registered as the translator’s description. The translator’s name cannot be localized, which means that it does not appear in your project’s list of string entries. Because of this, the same value is used regardless of the system’s language.

ODBC Translator Attributes

Attribute

Expected Value

Translator Component

Enter the name of the component that you want to install the translator and its attributes.

Translator DLL

Enter the path to the DLL file that is on the development system and that serves as the translator, or click the ellipsis button (...) to browse to the file. This file is included in the component that is identified in the Translator Component setting. It is recommended that you have only one DLL per component; therefore, if you select a different DLL, delete the previous one from the Components view.

Setup Component

Enter the name of the component that you want to install the setup DLL for the translator. Usually, this component is the same one as the component for the driver if the setup code is in the same DLL.

Setup DLL

Enter the path to the setup DLL on the development system, or click the ellipsis button (...) to browse to the file. This file is included in the component that is identified in the Setup Component setting. If the driver file is also the setup DLL, you can leave this setting blank. It is recommended that you have only one DLL per component; therefore, if you select a different DLL, delete the previous one from the Components view.

Note • You cannot add an attribute to a translator.

See Also