MTS Support

On Windows, the driver can take advantage of Microsoft Transaction Server (MTS) capabilities, specifically, the Distributed Transaction Coordinator (DTC) using the XA Protocol. For a general discussion of MTS and DTC, refer to the help file of the Microsoft Transaction Server SDK.

NOTE: The DataDirect Connect for ODBC 32-bit drivers can operate in a 64-bit Windows environment; however, they do not support DTC in this environment. Only the DataDirect Connect64 for ODBC 64-bit drivers support DTC in a 64-bit Windows environment.

To enable DTC support, you must be using Informix Connect version 2.20 or higher clients.

To enable support for the DTC:

1	Use the Setnet32 utility supplied by Informix to define:

■	The INFORMIXDIR environment variable, which identifies the location of the client programs, library files, message files, header files, and other Informix software components

■	The INFORMIXSERVER environment variable, which identifies the default database server

■	An Informix server, which identifies either an existing Informix database server or a new one

■	A host name, which identifies the host computer with the database server you want to use

■	A user name, which identifies a user name for an account on the currently selected host computer

■	A password for the specified user name, if required

When enlisting in a distributed transaction, the Informix clients only use the defaults specified in Setnet32.

2

Run the regcopy utility provided with INFORMIX-Connect to copy the registry entries created by Setnet32 to an area in the registry that is accessible by the DTC. The DTC is a service, and services do not search for configuration information in the Windows registry where Setnet32 stores client products environment variables. Therefore, if you do not run regcopy after setting the defaults in Setnet32, enlistment in a distributed transaction will fail.

For information on using the Setnet32 and regcopy utilities, see the Informix documentation.