How to Avoid Database Timeout

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have used ADO.Net to select/update/insert data from/to a MS SQL database.
Some time when the database is busy, I received the below error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Any solution for this issue?

Thanks in advance
 
If the server is overloaded, there is nothing you can do here but upgrade
the server to a more powerful machine. Either that, or try to optimize the
queries being run by whatever other application is tying up the server (if
that is something you have access to).
 
Please seach "ADO.NET timeout" posted by 4City.

You set the command timeout ( which is diefferent from connection timeout)
instead of the connection timeout.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timeout expired. The timeout period elapsed prior to completion ofthe operation or the server is no 12
SQL exception timeout 6
Exception: Timeout expired 2
Timeout expired problem 4
The timeout period elapsed ... 2
Creating Offline Database 6
Query Timeout Expired Using SELECT/WHERE 5
System.InvalidOperationException Timeout expired. 4

Back
Top