Hello all,
Here is current snapshot of our environment:
ASP.NET (C#)
.Net Framework 1.0 SP2
MDAC 2.71 (SP1)
Windows 2000 (Build 2195 SP3)
SQL Server 2000 - 8.00.760 (SP3)
We are using Microsoft SqlHelper from the Application Blocks and we
currently have connection pooling = no
Every now and then we get two types of errors:
First Error:
"System.Data.SqlClient.SqlException: General network error. Check your
network documentation." This error tends to go away if we refresh the
browser.
Second Error:
"System.Data.SqlClient.SqlException: Timeout Expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding." What is interesting about this error is that the procedure
being called takes 1 parameter (a state UID) and returns within 3 seconds. I
was getting an exception immediately (no 3 second delay) if I passed a state
returning couple of hundred records consisting of VARCHAR and INT values,
but works fine if there are fewer or no return values. Once I executed that
same procedure using Query Analyzer for the problem state, the application
started to work fine. It is happening on various procedure calls every few
hours.
I have looked on Microsoft's newsgroups, google, and on MSDN but I cannot
find anything that applied to us.
Any input would be appreciated.
Fadi