Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
StoredProc Transaction Error
Message
De
04/04/2003 08:34:52
 
 
À
03/04/2003 21:04:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00773441
Message ID:
00773949
Vues:
13
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform