Hi,
my application based on WCFService (NET 3.5) installed on machine connected (Windows Server 2003) to a Microsoft SQL Server 2005. Randomly generates this error:
System.ObjectDisposedException: Safe handle has been closed at System.Runtime.InteropServices.SafeHandle.DangerousAddRef (Boolean & success) at SNINativeMethodWrapper.SNIPacketReset (SafeHandle pConn, IOType ioType, SafeHandle packet) at System.Data.SqlClient.TdsParserStateObject.WriteSni () at
System.Data.SqlClient.TdsParserStateObject.WritePacket (Byte FlushMode) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest (Byte [] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon (TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction (TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction (IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlInternalConnection.BeginTransaction (IsolationLevel iso) at System.Data.SqlClient.SqlConnection.BeginDbTransaction (IsolationLevel isolationLevel) at System. Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction () at
seems to be generated by improper management of connections between c # / sql server, how do I catch it and fix it. It occurs only on production environment.