Hello,
I am developing an application in C#, which was previously in .Net 2005
Beta, then it was working perfectly fine, but from the time I have upgraded
it to .Net 2005 Professional, its continously giving me error on the
following line,
transaction = Connection.BeginTransaction();
System.Data.SqlClient.SqlException: New transaction is not allowed because
there are other threads running in the session.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.TdsParser.TdsExecuteTransact ionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName,
TransactionManagerIsolationLevel isoLevel, Int32 timeout,
SqlInternalTransaction transaction, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.Exe cuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso,
SqlInternalTransaction internalTransaction)
at
System.Data.SqlClient.SqlInternalConnectionTds.Exe cuteTransaction(TransactionRequest
transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction
internalTransaction)
at
System.Data.SqlClient.SqlInternalConnection.BeginS qlTransaction(IsolationLevel
iso, String transactionName)
at
System.Data.SqlClient.SqlInternalConnection.BeginT ransaction(IsolationLevel
iso)
at System.Data.SqlClient.SqlConnection.BeginDbTransac tion(IsolationLevel
isolationLevel)
at
System.Data.Common.DbConnection.System.Data.IDbCon nection.BeginTransaction()
Any kind of help would be welcome.
regards,
Beenish Sahar Khan