TransactionScope returns "Error HRESULT E_FAIL has been returned from a call to a COM component"

microsoft.public.dotnet.framework.adonet

20 Nov 2007 10:45 PM

tbannon

I am using ENTLIB2.0; VS2005; and SQLServer Express on a standalone
machine. Additionally we are using TransactionScope and are receiving
an exception.

We have enabled DTC and have also added MSTDC to the Firewall
exceptions. The database is resident on the local machine.

This is the error received:

"Error HRESULT E_FAIL has been returned from a call to a COM
component"

The stack trace is as follows:
System.Transactions.Oletx.OletxTransaction
GetOletxTransactionFromTransmitterPropigationToken(Byte[])</Property>
<StackTrace>at
System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[]
propagationToken) at
System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction
tx) at
System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction
tx) at
System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
at System.Transactions.Transaction.Promote() at
System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction
transaction) at
System.Transactions.TransactionInterop.GetExportCookie(Transaction
transaction, Byte[] whereabouts) at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction
tx) at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction
tx) at
System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction
transaction) at
System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction
transaction) at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand
command)

We are in a crunch and could definitely use assistance in identifying
this issue.
Regards,
Tracy