Click here to Skip to main content
11,478,174 members (70,166 online)
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)501.1K
v2

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

  Print Answers RSS
0 Frankie-C 160
1 Sergey Alexandrovich Kryukov 149
2 Sascha Lefèvre 145
3 F-ES Sitecore 130
4 siddartha kopparapu 103
0 Sergey Alexandrovich Kryukov 7,675
1 OriginalGriff 7,321
2 Sascha Lefèvre 3,034
3 Maciej Los 2,491
4 Richard Deeming 2,325


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 7 Oct 2012
Copyright © CodeProject, 1999-2015
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