Last post Dec 05, 2010 05:53 PM by asajids
Sep 07, 2006 07:15 AM|Iftikhar|LINK
I am getting following error while trying to execute a Stored Procedure using Microsoft Application Blocks [Data Access Block]
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
If I run the Stored Procedure from SQL management Studio, it takes 00:01:20 [hh:mm:ss] but works. In my Windows application the same SP throws an exception with the above mentioned error message just after 31 seconds everytime.
Any help, ideas on this?
Sep 07, 2006 10:29 AM|Gordon-Freeman|LINK
Yes, the default timeout is 30s... You may try:
1. Plus "Timeout=XX" in your connection string, where XX is seconds
2. Set both
Sep 08, 2006 04:53 AM|Iftikhar|LINK
Thanks it worked!
I am surprised why we need to set both? It should be possible to use the Connection.ConnectionTimeout by Command Object. Anyway, I can run my query now.
Sep 08, 2006 05:10 AM|Gordon-Freeman|LINK
Dec 05, 2010 05:53 PM|asajids|LINK
I have been suffering from last two months for the session expiry.
We have developed one website for the client, all the handover is done but we are not able to close the same due to reports displaying issue. Reports page is getting expired after 60secs.
I have tried using the above method but still no way.
Can you help me for the same.