How to Avoid Database Timeout

[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

 

[Marina]

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).

 

[ToddT]

increase the time out value in the connection string?

 

[Guest]

Please seach "ADO.NET timeout" posted by 4City.

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