Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 C#
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.
Posted 6-Oct-12 23:27pm
Edited 6-Oct-12 23:36pm
(no name)499K
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 390
1 Jochen Arndt 165
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,032
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,220


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 7 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100