provider: TCP Provider, error: 0 ...

  • 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!!!!

  • Machine:4 processors

    Memory: 8GB ram

    Windows Server 2003 SP2

    SQL Server 2005 EE (3077)

    Regards!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply