Distributed Transaction Issues

The DataDirect Connect for ADO.NET data providers support distributed transactions only when the application is written to serviced components. For a general discussion of using serviced components, refer to the Microsoft ADO.NET Framework SDK documentation.

The DataDirect Connect for ADO.NET data providers support distributed transactions using the Microsoft Distributed Transaction Coordinator (MS DTC), which is provided through System.Transactions. You must include specific code, such as System.Transaction, in the namespace of your application.

Enabling the MS DTC Service

The MS DTC service must be in a running state. On the MSDTC tab of the Component Services Administrative ToolSet, specify the Security Configuration setting:

• For the DB2, Oracle, and Sybase data providers, select the Enable XA Transactions check box and click OK.
• For the SQL Server data provider, select the Network DTC Access check box and click OK.

Note: The location of the MS DTC configuration varies by Windows version. Refer to the Microsoft Windows help for detailed information for your environment.

Configuration Issues

Check for the following issues when problems occur while using distributed transactions.

MS DTC is configured improperly

Error occurred when enlisting connection in distributed transaction.

The MS DTC service must be in a running state, with the appropriate values selected on the Security Settings tab of the Component Services Administrative Tool:

• For the SQL Server data provider, select the Network DTC Access check box.
• For the Oracle, DB2, and Sybase data providers, select the Enable XA Transactions check box.

MS DTC registry entry is missing

Error occurred when enlisting connection in distributed transaction.

The product installation may have been damaged. Uninstall the data provider and reinstall it.

The DDTek.providerHelper assembly is missing from the GAC

The optional DTC support components cannot be located. Please make sure you have installed them and that they are on your path. See the product documentation for more details.

The product installation may have been damaged. Uninstall the data provider and reinstall it.