To configure a data source to the ODBC Informix
driver
Select the General tab and enter the required information (*) for the parameters for this window, as described in the following table:
Parameter |
Description |
|---|---|
*Data Source Name |
String that identifies this Informix data source configuration in the system information. Examples include “dcinfx.” |
Description |
An optional description of a data source name. |
*Host Name |
Name of the machine on which the Informix server resides. |
*Port Number |
Port number of the server listener. |
*Server Name |
Name of the Informix server as it appears on the sqlhost file. |
*Database Name |
Name of the database to which you want to connect by default. |
User Name |
User name as specified on the Informix server. |
WorkArounds (optional) |
Name of the WorkArounds string key to support DirectConnect bulk transfers. The value is 536870912. To add the WorkArounds string key, refer to “To add the WorkArounds String Key”. |
Click Apply. At this point, you can click Test Connect. If the connection fails, check your connectivity parameters for accuracy.
Click the Advanced tab to display the Advanced Driver Settings dialog box, where you can configure additional, optional settings for the data source.
Specify values for the Application Using Threads to On.
See “Descriptions of data source parameters” for detailed descriptions of the parameters.
Click OK to make the values you entered become the defaults when you connect to the data source. To change these defaults, use this procedure to reconfigure the data source.
The following table provides descriptions of parameters that you can provide in the ODBC Administrator windows. The required parameters are identified by an (*).
Parameter |
Description |
|---|---|
Cancel Detect Interval |
Allows you to cancel long-running queries in threaded applications. Select a value to determine how often the driver checks to sees whether a request has been canceled using SQLCancel. For example, if DCI=5, for every pending request, the driver checks every five seconds to see whether the user has canceled execution of the query using SQL Cancel. Default is 0, which means that requests are not canceled until the request has completed execution. |
*Application Using Threads |
Select this check box to ensure that the driver works with multi-threaded applications. You can clear this check box when using the driver with single-threaded applications. Clearing this check box avoids the additional processing required for ODBC thread-safety standards. Always activate this check box with DirectConnect. |
Trim Blank from Index Name |
Specifies whether the leading space should be trimmed from a system-generated index name. When checked (the default), the driver trims the leading space. |
Translate |
When clicked, displays the Select Translator dialog box, which lists the translators specified in the ODBC Translators section of the system information. OEM to ANSI translates your data from the IBM PC character set to the ANSI character set. |
For DirectConnect for Informix only, you need to verify that a special string key is defined in the Windows Registry, to allow the driver to support DirectConnect bulk transfers.
WARNING! Be cautious when using regedit.exe or regedt32.exe, you can disable your machine. Make a backup of your Registry before making any changes.
To add the WorkArounds
String Key
Using the Windows Registry editor (regedit.exe or regedt32.exe), open one of the following sections in the Registry:
For User DSN: HKEY_CURRENT_USER \SOFTWARE\ODBC\ODBC.INI
For System DSN: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
In this section, locate an entry for the DSN you created.
If the WorkArounds string key is not there, select Edit | New | String Value from the Edit menu, to add a String Value named WorkArounds (case sensitive). After it has been created, modify the new entity and give it a value of 536870912.
Click OK.
Repeat this process for each Informix DSN that you are going to use with DirectConnect.
