SQL Anywhere 12 (12.0.1.4155) using EF : Unable to enlist transaction; DTC may be down

[Former Member]

What may be causing this error??

Sometimes the transactions runs fine, and other times I get this error message.

Database.SqlQuery<int>("select dba.getnextid()");

NativeError: -803

Message: Unable to enlist transaction; DTC may be down

Source: SQL Anywhere .NET Data Provider

StackTrace:

at iAnywhere.Data.SQLAnywhere.SAException.CheckException(Int32 idEx)

   at iAnywhere.Data.SQLAnywhere.DurableResourceManager.Enlist(SAInternalConnection conn, Transaction tran)

   at iAnywhere.Data.SQLAnywhere.SAInternalConnection.Enlist(Transaction tran)

   at iAnywhere.Data.SQLAnywhere.SAConnection._EnlistTransaction(Transaction tran)

   at iAnywhere.Data.SQLAnywhere.SAConnection.EnlistTransaction(Transaction transaction)

   at System.Data.EntityClient.EntityConnection.EnlistTransaction(Transaction transaction)

Can't seem to figure out how to resolve this issue, nor what's causing it.

[Former Member · Accepted solution]

Enabling the MSDTC service solved it.  (Distributed Transaction Coordinator)