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 Sergey Alexandrovich Kryukov 305
1 OriginalGriff 225
2 Kornfeld Eliyahu Peter 130
3 DamithSL 110
4 Peter Leow 95
0 OriginalGriff 7,355
1 DamithSL 5,199
2 Sergey Alexandrovich Kryukov 4,942
3 Maciej Los 4,906
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web04 | 2.8.141223.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