473,320 Members | 1,883 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 Troubles when I execute a sql quey.

Hi all (vb)
I worked with querys and they worked fine, but now I need to retrieve a lot
of data, when I launch the query it stoped with this error:
---
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
---
I use a DataSet object, here I put my query. This objects takes the
settings from the web.config file, in the web.config file I added this:
---
Connect Timeout=0
---
Even, I tried with several numbers but the response error still.

How can I repair this problem?

Thanks in advanced.

Jun 27 '08 #1
3 1506
Hi

Increase the connection timeout property...in connection string.

and do follow this thread

http://bytes.com/forum/thread246020.html

Best of luck

Munna

www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com
Jun 27 '08 #2
Sounds more like a command timeout then a connect timeout to me.

"Don Juan" <Ju*****@gmail.comwrote in message
news:62**********************************@microsof t.com...
Hi all (vb)
I worked with querys and they worked fine, but now I need to retrieve a
lot of data, when I launch the query it stoped with this error:
---
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
---
I use a DataSet object, here I put my query. This objects takes the
settings from the web.config file, in the web.config file I added this:
---
Connect Timeout=0
---
Even, I tried with several numbers but the response error still.

How can I repair this problem?

Thanks in advanced.

Jun 27 '08 #3
Hi,

http://msdn.microsoft.com/en-us/libr...ut(VS.80).aspx

The time in seconds to wait for the command to execute. The default is
30 seconds.

A value of 0 indications no limit, and should be avoided in a
CommandTimeout because an attempt to execute a command will wait
indefinitely.

CommandTimeout has no effect when the command is executed against a
context connection (a SqlConnection opened with "context
connection=true" in the connection string).

Best of luck

Munna

www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com
Jun 27 '08 #4

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

Similar topics

4
by: Cath B | last post by:
I am pretty sure I am getting a command timeout when execute a SQL procedure that has an output parameter. The code below is in an asp page that is called using RSGetASPObject. I want to be able...
11
by: David Berry | last post by:
Hi All. I have a SQL Statement on an ASP page that only returns 4 records. When I run it in SQL Server or Query Analyzer it runs in less than a second. When I run it from my ASP page I get: ...
3
by: MSR | last post by:
Hi, I have a query that takes 1 min 50 secs to execute in Query analyser (SQL Server 2000). When i execute this query from vb using ADO i get the 'Timeout Expired' error. I have tried setting...
13
by: Patrick | last post by:
I understand that with IIS5.1 on Windows XP Professional SP1, I can 1) Either set under IIS Manager-> Any specific Virtual Directory-> Configuration->Options->ASP Script timeout for all pages...
7
by: C# beginner | last post by:
I'm struggling with a timeout problem today. ConnectionString = "Integrated Security=true;Database=MyDatabase;Data Source=(local); Connection Timeout = 180;"; My connection string is set as...
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...
2
by: Chakravarti Mukesh | last post by:
Hi all, I have put some queries on the page that takes too much time to execute. Thus at the time of peak load it gives the following error. Server Error in '/ge' Application....
22
by: pb648174 | last post by:
After executing osql from the command line via the Windows scheduled task interface, the following error is returned: "Timeout expired" The code in the sql is as follows: BACKUP Database...
7
by: =?Utf-8?B?a19tYW4=?= | last post by:
Hi all, Have a strange problem with SqlClient timeouts. Here is some background: About a month ago I upgrade from SQL 2000 to 2008. Am using Stored Procedures for all the data access. Most of...
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
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
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: 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.