Problem in Dot Net 2005

[Beenish Sahar Khan]

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

[Frans Bouma [C# MVP]]

Beenish Sahar Khan wrote:

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();

You already have a transaction running on Connection ? Do you share
Connection among threads? (for example in the asp.net application
object?))

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------