I have dot net application which update several table in my database for a single functionality Example (pass file).
One button "pass file" is there when I click it do many DML and sql query.
For first few click it will work successfully, but after some times it show below message.
Error Occured: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
I have tried by increase timeout and make it zero also. Still not able to solve the issue.
Please suggest me how i can resolve this issue.
Thanks and Regards
Make sure that you are releasing the connection objects in your data access layer.
If you are running multiple statements in the stored procedure, then seperate them with 'GO'
Also try specifying the timeout in the conenction string. Keep the timeout to 10 or 20 minutes.
Try this in your web.config,
<addkey value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200" />
Alternatively, try to Select Top 50 or less records in your SQL Statement
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)