I have a dll in .net that is used by another dll. The second dll is used in
the web and the first one acts as a middle layer. The dll contains
non-transactional and transactional classes. I have registered the dll in
com+ services using regsvcs. Non-transactional works fine. But the calls to
transactional classes hang when called by the second dll.
I execute a SqlHelper.ExecuteReader.
No call to the database is made.
Looking at the eventlog i get different entries. The most common one was
Server stack trace:
at System.Data.Common.ITransactionExport.Export(ITran saction transaction,
UInt32& transactionCookie)
at System.Data.SqlClient.Transaction.GetTransactionCo okie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)
at
System.Data.SqlClient.SqlInternalConnection.Enlist NonNullDistributedTransact
ion(ITransaction transaction)
at
System.Data.SqlClient.SqlInternalConnection.Enlist DistributedTransaction(ITr
ansaction newTransaction, Guid newTransactionGuid)
at
System.Data.SqlClient.SqlInternalConnection.Enlist DistributedTransaction()
at System.Data.SqlClient.SqlInternalConnection.Activa te(Boolean
isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters)
at
WRIPPlatform.Persistence.Impl.SubscriptionSqlHandl erImpl.ListSubscriptions(P
rogram program, Participant participant)
at
WRIPPlatform.Platform.Impl.SubscriptionManagerImpl .ListSubscriptions(Program
program, Participant participant)
at System.Runtime.Remoting.Messaging.Message.Dispatch (Object target,
Boolean fExecuteInContext)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at WRIPPlatform.Platform.ISubscriptionManager.ListSub scriptions(Program
program, Participant participant)
at
WRIPWeb.ASPX.ParticipantConfigure.CreateSubscripti onDetailsSource(Participan
t participant)
at WRIPWeb.ASPX.ParticipantConfigure.OnBtnSelectClick (Object sender,
EventArgs e)
Help!!!
Regards,