473,322 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to Avoid Database Timeout

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

Nov 21 '05 #1
3 1793
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" <Li****@discussions.microsoft.com> wrote in message
news:86**********************************@microsof t.com...
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

Nov 21 '05 #2
increase the time out value in the connection string?
On Wed, 11 Aug 2004 06:25:01 -0700, "Li Pang"
<Li****@discussions.microsoft.com> 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


Nov 21 '05 #3
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"
<Li****@discussions.microsoft.com> 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


Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: deko | last post by:
I have 3 files I need to write to - and need to make sure I have a lock on each, and take action if I can't get a lock. The code below works, but I know it could be more efficient if I used a...
6
by: harry | last post by:
Hi, I have a program that runs on multiple client pc's. Occasionally one or more of those pc's use VPN to connect to another corporate network. When using VPN they need to set proxy server in...
1
by: Azel | last post by:
Hi, I am trying to learn ADO.net and I keep running into problems trying to insert data into my Access Database: data.mdb. here is my code: <code> // Database Variables
3
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...
0
by: Jonathan Wood | last post by:
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had...
0
by: cbkprasad | last post by:
Hi, I have a critical problem regarding, avoiding the user to login to wibsite using the same credentials at the same time.The concept is once the user is logged in to application the that...
14
by: DavidNorep | last post by:
I do not know PHP, consider to write a CGI with this technology and have the following question. Is it possible to invoke a PHP script and let it endlessly wait for requests from a website (a...
10
by: Atul Shukla | last post by:
Hi, How can I avoid application timeout? Generally a web application time out is 20 minutes, however, we can define this timeout in web.config to any number of minutes. After giving 500 minutes of...
7
by: =?Utf-8?B?SmFzb24=?= | last post by:
Hello, can someone please suggest to me how I can keep my ftp connection from timing out after a large file download? I am using SSIS and I have tried multiple ways of ftp'ing the files in my...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.