Timeout expired and General Network error -- dotnet faqs

Joerg Schrocke
10/25/2005 10:09:00 AM

Hello!

On our web application we receive following errors:

Timeout
expired. The timeout period elapsed prior to completion
of the operation or the server is not responding

and

General network error. Check your network documentation.

In this moment, the web app connected to a sql server and run a stored
procedure to get data from the SQL Server database.
When we run the stored procedure from the query analyzer, the stored
procedure completed successful in 3 sec for 2000 datasets.

What can be the problem?

Please help!

Many thanks,

Joerg

CT
10/25/2005 10:22:34 AM

Joerg,

Does this happen all the time, or just sometimes? When you execute the
stored procedure in Query Analyzer, is there any difference between where on
the network the machine with Query Analyzer is located as opposed to the Web
server? Does your stored procdeure in any way lock any data, and
subsequently blocks requests from other sessions in your Web app, or are
there potentially other stored procedures or apps that access the same data?

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk

[quoted text, click to view]

dotnet faqs : Timeout expired and General Network error