Unable to enlist in a distributed transaction
576410May 8 2007 — edited Jun 18 2008Hi,
I'm writing a software that uses distributed transactions. Generally, the code works fine, but sometimes, the following exception occures:
Oracle.DataAccess.Client.OracleException Unable to enlist in a distributed transaction at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
Can anyone tell me please, how to debug this? Does this error depend on the "Micrososft Distributed Transaction Coordinator"? Is there any tool to view the detailed error message? May I change the init settings for the database?
This error occures on the following platforms:
Windows 2003 Server Standard and Oracle 9i
Windows 2003 Server Enterprise and 10g
using ODP.Net
Thanks for your help
johannes