Last post Aug 29, 2009 08:22 AM by mbanavige
Aug 29, 2009 06:12 AM|ncsubbu|LINK
I am using sql Helper for Data Access.I am implemented the connection pooling in web.config. I have 10000 records.I am using view to retrive the record from different tables from sqlserver. I got the Error is below while access from application.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Please give me the any solution for this problem.
Aug 29, 2009 08:22 AM|mbanavige|LINK
The old SQLHelper class does not give you access to the CommandTimeout setting so you only get the default 30 seconds.
If you want to change the timeout, you'd need to alter the SQLHelper code slightly (http://bytes.com/topic/c-sharp/answers/513212-increase-daab-time-out)
Or you could skip SQLHelper and create your own SQLCommand for your long running calls