Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
StoredProc Transaction Error
Dear all,
I wrote an ASP program to do a batch update for SQL Database. As before, I'm using COM object to do but it always cause an error "Transaction context is in use by another session". I searched MSKB to locate the document which notify that is a bug of SQL Server but it didn't have any fix for it. Coming later, somebody tech me to change the COM object to Stored Procedure. At the beginning, everything is ok and the problem is solved. But after I implement the program to Live Environment, the problem comes again. Anyone can help me to solve the problem?
Basically, I just use the stored procedure to retrieve, insert and update the records. ASP contains all business rules. It's get me crazy and Thank you for your help .....
Best Regards,
Ty Ty
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement