Click here to Skip to main content
14,738,170 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



In the asp.net I've encountred with the above error. when in my web application I clicked on my link a stored procedure of my DB will run. But the next page don't show. I did these jobs but it didn't solve:
1. Change session time out
2. change connect time out in connection string
3. change application pool setting from integrated to classic
but unfortunately my problem still remain.

Visual studio 2008. asp.net
thank you.
Posted

1 solution

Instead of tryign various timeouts, your first step should be to get the bottleneck!

Use Debugger and get the place/reason where the response is taking to long a time. It might be getting the data from DB, some BLL processing or UI level rendering.

Based on your question, chances are with DB. So, run the SP in your DB with the same parameters and check how much time does it take in general. If that fits in and looks like proper timeout place then start working on it.

If you are using simple SQL server to get data, check for all the places where timeouts can be configured. SQL Connection timeout, timeout in DB, then based on the timeouts in SQL layer, you would need to set the same or higher for your UI such that response passes on smoothly.
   
Comments
Mos_newview 23-Jul-10 9:29am
   
hi. thanks for your answer. I check my SP. It took 1 minute and 15 seconds.
I'm trying find a solution.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900