Enlist Distributed transaction / Open generates ORA-02048

[jesuissur]

Hi there,

We got a problem using distributed transaction through dotConnect for Oracle. When we set the Enlist to true in the connection string and open the connection under a TransactionScope, we got the following exception

Code: Select all

ORA-02048: attempt to begin distributed transaction without logging on

Code: Select all

   at Devart.Data.Oracle.bm.b(Int32 A_0)
   at Devart.Data.Oracle.aq.d(Int32 A_0)
   at Devart.Data.Oracle.aq.a(Guid A_0, IsolationLevel A_1)
   at Devart.Data.Oracle.OracleInternalConnection.BeginTransaction(Guid distributedIdentifier, IsolationLevel isolationLevel)
   at Devart.Common.s.a(Guid A_0)
   at Devart.Common.DbConnectionInternal.EnlistToDistributedTransactionInternal(Transaction transaction)
   at Devart.Common.DbConnectionInternal.EnlistToDistributedTransaction(Transaction transaction)
   at Devart.Common.DbConnectionInternal.c()
   at Devart.Common.DbConnectionInternal.i()
   at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
   at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
   at Devart.Common.DbConnectionBase.Open()
   at Devart.Data.Oracle.OracleConnection.Open()
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)

Do we have to install something specific on our clients and/or (Oracle) server to work with distributed transaction in Oracle?

Does someone has already use distributed transaction with dotConnect?

Thank you very much
Phil

[AndreyR]

Try to set the "Transaction Scope Local" connection string parameter to true. In some scenarios there is no need to open a distributed transaction, and local transaction is enough for the TransactionScope usage.
Please let us know if the error persists.