Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
StoredProc Transaction Error
Message
From
04/04/2003 08:34:52
 
 
To
03/04/2003 21:04:37
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00773441
Message ID:
00773949
Views:
12
You can search Microsoft's support site for the error message and get a couple of hits.

This is from one of the articles (http://support.microsoft.com/default.aspx?scid=kb;en-us;256649):

"SQL Server allows multiple system process ID (SPID) connections to enlist in the same Microsoft Distributed Transaction Coordinator (MS DTC) transaction. The SQL Server limits "active" operations to a single SPID. Simultaneous operation attempts result in the following 3910 error message:

Error 3910: Transaction context in use by another session. "

Are you controlling transactions from within the ASP page?

-Mike


>Dear Michael Levy,
>
>Thank you for your help and reply. I think that error message return from SQL Server. SQL Server is Version 7 w/ SP4 and DTC is coming with NT 4.0 Option Pack. Both application are running on the same server with Windows NT 4.0. Do you have any idea? Looking forward to hear your reply soon and Thanks a lot!!
>
>Error Message on ASP:
>Microsoft OLE DB Provider for SQL Server
>error '80040e14'
>Transaction context in use by another session.
>/eas/ps/ps100bupd.asp, line 589
>Transaction Abort
>
>Best Regards,
>
>Justy Chow
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform