I have been having fits with my application that uses SQL Server and I finally found a description of the problem as a bug fix for SQL Server 2005.
http://support.microsoft.com/kb/912732
The only problem is, my database server is SQL Server 2000. Is there any way to find out if SQL Server 2000 has an equivalent patch?
From the MS KB article
- You open a connection and start a Transact-SQL transaction by using the "System.Data.SqlClient" namespace.
- You close the connection without completing the Transact-SQL transaction.
- You request another connection and receive the previous connection from the connection pool.
- You start a new transaction by using the SqlConnection.BeginTransaction method.
I have strong reasons to believe "2" is happening in another application using another database on the same server. Then "3" happens when my app grabs a connection from the pool that was screwed up by another application.
I am not able to upgrade to 2005 due to non-technical constraints, but if I can find a patch to fix this issue in SQL Server 2000, I can have it applied.
Has anyone found a fix in 2000?