GetOpenConnection state exceptions

microsoft.public.dotnet.framework.adonet

28 Mar 2006 3:38 PM

PIEBALD

Using Windows Server 2003, SQL Server 2005, and .net 2.0 (C#) I'm
intermittently getting exceptions like the following:

System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery
requires an open and available Connection. The connection's current state is
connecting.

System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery
requires an open and available Connection. The connection's current state is
open.

System.Data.SqlClient.TdsParserStateObject(ExecuteFlush)Operation cancelled
by user.

These are now occurring in service processes that have been behaving
properly for several months.