J
James Vitale
Exception: System.Data.SqlClient.SqlException: The transaction operation
cannot be performed because there are pending requests working on this
transaction.
ASP.NET 2.0 running on Windows Server 2003 with MS SQL Server 2005
I have a web page that very simply takes a query string and inserts data
into my database.
On the insert there is a transaction. It has been in operation for quite
some time and has never had a problem. It executes two or three SQL
statements and if there are no errors it commits, othewise it rollsback.
For some reason, after the page runs for a while and takes a couple hundred
submissions, it starts giving me the error above. I can't find anything
about this error. I can't see how there could be pending requests working
on this transaction since there is only one call to the database.
How can I diagnose this problem?
Thanks,
James Vitale
cannot be performed because there are pending requests working on this
transaction.
ASP.NET 2.0 running on Windows Server 2003 with MS SQL Server 2005
I have a web page that very simply takes a query string and inserts data
into my database.
On the insert there is a transaction. It has been in operation for quite
some time and has never had a problem. It executes two or three SQL
statements and if there are no errors it commits, othewise it rollsback.
For some reason, after the page runs for a while and takes a couple hundred
submissions, it starts giving me the error above. I can't find anything
about this error. I can't see how there could be pending requests working
on this transaction since there is only one call to the database.
How can I diagnose this problem?
Thanks,
James Vitale