How to Avoid Database Timeout

's Computer Specifications

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

's Computer Specifications

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

"Li Pang" <(E-Mail Removed)> wrote in message
news:8609E5E9-9FDF-4063-A311-(E-Mail Removed)...
> 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
>

's Computer Specifications

increase the time out value in the connection string?

On Wed, 11 Aug 2004 06:25:01 -0700, "Li Pang"
<(E-Mail Removed)> wrote:

>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

's Computer Specifications

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

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

"ToddT" wrote:

> increase the time out value in the connection string?
>
>
> On Wed, 11 Aug 2004 06:25:01 -0700, "Li Pang"
> <(E-Mail Removed)> wrote:
>
> >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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Avoid Application Timeout	Atul Shukla	Microsoft ASP .NET	10	10th Jul 2007 01:01 AM
Appointment Database Avoid Duplicate Apointments	eddie.holder@mousetraining.com	Microsoft Access Getting Started	7	7th Mar 2007 06:30 PM
Simulated Activity - Avoid Timeout and Logon Redundancy	SAR I	Windows XP General	6	13th Jan 2005 02:54 PM
Simulate Activity To Avoid Timeout and Re-Logon?	SAR I	Windows XP General	8	12th Jan 2005 08:32 AM
How to avoid script database hacking?	RA	Microsoft ASP .NET	12	3rd Aug 2004 01:32 PM