Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

provider: TCP Provider, error: 0 ... Expand / Collapse
Author
Message
Posted Tuesday, June 09, 2009 3:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 22, 2010 9:54 AM
Points: 2, Visits: 11
Hi Guys!!!!

I have a problem that I do not think the answer anywhere. I have a server and application is on the same machine. During a load of data, which previously took 1 hour, now takes about 3 hours and displays the following error:

DATE/HOUR: 06/09/2009 16:19:11
Message: A transport-level error has occurred when sending the request to the server.

(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Source: .Net SqlClient Data ProviderTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at srAcesso.Conexao.srCommand.ExecuteReader()
at ServicoRecupera.ServicoRecupera.LogarMensagem(stcMensagem objMsg)
Additional Message: Unexpected error message when trying to log to a file.
Task: ConLivre



Somebody already had this kind of problem?

What do I do?

Tank's
Regards!!!!
Post #731913
Posted Tuesday, June 09, 2009 3:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 22, 2010 9:54 AM
Points: 2, Visits: 11
Machine:4 processors
Memory: 8GB ram

Windows Server 2003 SP2
SQL Server 2005 EE (3077)


Regards!
Post #731916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse