Getting a (Error: 0- An existing connection was forcibly closed by the remote host) In my application.

I have a application that is giving me fits. It will work some times but more often than not it will fail. The application sits on the outside of a firewall, in my DMZ running on a web server (2003 MS WEB). The application connects to a SQL 2000 server on the inside of the fire wall. All the necessary ports are enabled and the web server can communicate without issue to the SQL server. The application will pull back a sizable result set, but nothing enormous, about 1000+ records (something which the server fields in a matter of seconds). However, I cannot get away from getting this error message:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

   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.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)

   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()

   at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] buff, Int32 offset, Int32 len)

   at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)

   at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ReadColumnData()

   at System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i)

   at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)

   at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)

   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)

   at System.Data.SqlClient.SqlDataReader.get_Item(String name)

   at db_conversion_console.Module1.tams_customer()


I do not have pooling enabled. I have my query timeout set to unlimited as well as the number of users.
There was an MS fix for a similar issue where it requests that you update the NIC and or disable the TCP Chimney Offload Feature. I have done both to no avail.
There might be something simple that I am missing, but I have been looking at this so long that I am sure I am looking right past it. Thanks for any help you might be able to hook me up with. Start Free Trial