Actian X ODBC and Distributed Transactions (Windows)
The ODBC 3.5 Driver fully supports enlistment of the ODBC connection in a distributed transaction on Windows. The ODBC driver works with the Microsoft Distributed Transaction Coordinator (MSDTC), DBMS Server, and the Ingres XA Distributed Transaction Processing (DTP) subsystem to allow the Actian X connection to participate in the distributed transaction on Windows with other Actian X or non-Actian X participants.
To enlist in a transaction represented by a ITransaction interface, the ODBC Driver supports the SQLSetConnectionAttr(hDBC, SQL_ATTR_ENLIST_IN_DTC, pITransaction) statement. Applications such as ODBC .NET Data Provider, Microsoft Transaction Server (MTS), or ordinary applications acquire a ITransaction pointer to a MSDTC transaction, and call the ODBC Driver with the request to enlist the ODBC connection in the transaction. When the commit or rollback is required for the MSDTC transaction, the ODBC driver works as a Resource Manager (RM) with MSDTC to execute the commit or rollback for the XA transaction on the DBMS Server.
Last modified date: 04/03/2024