Click here to Skip to main content
14,695,505 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
When I execute query, it is fine.But I run from program occur timeout expired.I already increase command timeout to 600 and increase sql server execution timeout to 1800 and increase connection timeout to 500.Timeout Expired occur in over 4 minutes.
Why did this error occur?Please help me and give me a way how to fix this.Please explain why this occur.Thanks in advance.
Posted

1 solution

The first thing to do is to debug the program and see on what operation the problem is occuring. If it is the execution of the SQL statement, check that you have provided all parameters correctly and the SQL statement looks as it should.

After that you can use profiler to investigate more, what happens during the execution of the statement. See Monitoring with SQL Profiler[^].
   

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