For DirectConnect for Informix (wire protocol driver)

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:

**Table 5-4: Description of General parameters**
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.

Descriptions of data source parameters

The following table provides descriptions of parameters that you can provide in the ODBC Administrator windows. The required parameters are identified by an (*).

**Table 5-5: Descriptions of data source parameters**
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.

Table 5-5: Descriptions of data source parameters

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.

Add the WorkArounds String Key to support bulk transfers (optional)

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.

Repeat this process for each Informix DSN that you are going to use with DirectConnect.