473,320 Members | 2,177 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,320 software developers and data experts.

timeout expired error

prabunewindia
199 100+
hi friends,
when i am doing some function by connecting database, i am getting this errer

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

but some time it is working properly, and quickly also.
i am the only user using this database, noother is accessing this

plz help me to find sol
prabu
May 15 '07 #1
5 981
kenobewan
4,871 Expert 4TB
What is your connection string? What other server are you connecting to?
May 15 '07 #2
Plater
7,872 Expert 4TB
Does the timeout occur on a connection attempt or does it occur when you try to run a query?

Certain querys are brutal and can take a long time causing a timeout. You could try extending the timeout period (change the value in your connection string)
May 15 '07 #3
prabunewindia
199 100+
hi,
thanks for reply
timeout occurring when i am trying to do some transaction between two tables.
i tried by changing timeout time.
some times it is not throwing error.
if process is happening means within a second it is happening.
else it is taking full time(timeout) and showing error

i am using same connection string for entire project
this particular stage only it is throwing error
plz guide
Prabu
May 16 '07 #4
Plater
7,872 Expert 4TB
Does it seem to take a long time even when it does NOT throw an error?
If so, you might need to re-think your transactions.
I would also recomend checking the state of your database connection if you re-use it. (Sometimes it's "Closed", "Open", "Busy", "Closing" or the like) that might help discover what your db driver is doing, because it might be busy doing something else when you try a transaction
May 17 '07 #5
TRScheel
638 Expert 512MB
hi friends,
when i am doing some function by connecting database, i am getting this errer

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

but some time it is working properly, and quickly also.
i am the only user using this database, noother is accessing this

plz help me to find sol
prabu

Please post the query string you are using, the number of items in the database, the type of database, and the number of columns.
May 17 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Silvia | last post by:
I have a application web and when execute this for a long time generated this error: Server Error in '/RAIMServer' Application. -----------------------------------------------------------...
4
by: Paul | last post by:
I sometimes get a timeout error when populating my datagrid, the code is WizardConnection.Open() UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & PhysOffice.SelectedValue & "', '" &...
5
by: Jason | last post by:
Hi all I get the following error when executing a rather intense stored procedure from an ASPX page. I have tried: - Increasing timeouts on IIS 5.0 (all areas that even mention timeout) - use...
2
by: Chris Langston | last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET ...
4
by: Nevyn Twyll | last post by:
I've been working on an asp.net application and everything's been great. But suddenly, whether I'm tyring to use a database on my own machine, or on my server, I'm getting a timeout when trying to...
4
by: VB Programmer | last post by:
When I run my ASP.NET 2.0 web app on my dev machine it works perfect. When I precomile it to my web deployment project and then copy the debug files to my web server I get this problem when trying...
0
by: bonita | last post by:
If I add the code for user to download the file (e.g. if(File.Exists(FILE_NAME)){......}), the ASP.NET will give the following timeout error: Timeout expired. The timeout period elapsed prior to...
1
by: Ron | last post by:
Hi, I had a stored procedure on SQL 2000 server to run calculation with large amount of data. When I called this stored procedure via System.Data.SqlClient.SqlCommand on production, i got error...
3
by: rn5a | last post by:
I am working on Win2K Pro (SP4) with P4 2.80GHz, 256MB RAM & 20GB hard disk (IIS5.0). I use Visual Web Developer 2005 Express Edition to create & edit ASP.NET apps. Whenever I log in to my m/c....
1
by: Scorpion657 | last post by:
Hey I really need help. I have a Website coded using ASP.NET and VB and for some reason, i'm getting the following error when I try to upload or access a large file which is stored in the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.