473,554 Members | 2,452 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP.NET SQL Timeout! help!

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 the "Connection Timeout=2400" string in the SqlConnection connections
string
- disabled connection pooling.

the error seems to consistently come back after 30 seconds! I am using
Microsofts Data Application blocks for accessing SQL.
is there a timeout setting that i am missing???? or is this a bug?

Thanks!
Jason

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior)
+44

System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n
dBehavior behavior) +5
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteDataset(Sq lConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParamete rs) +148
ppm.Post_to_GL. run_a_sp_Proces sedDeals() +246
ppm.Post_to_GL. btnPostToGL_Cli ck(Object sender, EventArgs e) +75
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277

Nov 18 '05 #1
5 13258
The SQL Connection timeout is just how long the attempt to make a connection
lasts if it's having trouble. It has nothing to do with execution of SQL
statements.

You need to change the timeout on the command object.

"Jason" <c_*******@migh ty.co.za> wrote in message
news:%2******** ************@tk 2msftngp13.phx. gbl...
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 the "Connection Timeout=2400" string in the SqlConnection connections string
- disabled connection pooling.

the error seems to consistently come back after 30 seconds! I am using
Microsofts Data Application blocks for accessing SQL.
is there a timeout setting that i am missing???? or is this a bug?

Thanks!
Jason

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior) +44

System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n dBehavior behavior) +5
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteDataset(Sq lConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParamete rs) +148
ppm.Post_to_GL. run_a_sp_Proces sedDeals() +246
ppm.Post_to_GL. btnPostToGL_Cli ck(Object sender, EventArgs e) +75
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277

Nov 18 '05 #2
did you try setting up SqlCommand.Comm andTimeout property?

If not, do so...

--
Hope this helps,
Zeeshan Mustafa, MCSD
"Jason" <c_*******@migh ty.co.za> wrote in message
news:%2******** ************@tk 2msftngp13.phx. gbl...
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 the "Connection Timeout=2400" string in the SqlConnection connections string
- disabled connection pooling.

the error seems to consistently come back after 30 seconds! I am using
Microsofts Data Application blocks for accessing SQL.
is there a timeout setting that i am missing???? or is this a bug?

Thanks!
Jason

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior) +44

System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n dBehavior behavior) +5
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteDataset(Sq lConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParamete rs) +148
ppm.Post_to_GL. run_a_sp_Proces sedDeals() +246
ppm.Post_to_GL. btnPostToGL_Cli ck(Object sender, EventArgs e) +75
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277

Nov 18 '05 #3
The Connect Timeout property of the Connection String will specify how
long the underlying provider will wait before a Connection Timout
occurs. After you connect this is not going to be used unless you
perform a reconnection again.

You can try to use a SQLCommand object but specify the Timeout Property.
I am not sure about the Application Block as I am not at my desk. Should
you require please drop me an email or post to this forum.

The Default is 20 seconds for a sql command to timeout. If it a heavily
used table then try to add the WITH (NOLOCK) clause for your select
statements.

Regards,

Trevor Benedict R
MCSD

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #4
did you try setting up SqlCommand.Comm andTimeout property?

If not, do so...

--
Hope this helps,
Zeeshan Mustafa, MCSD
"Jason" <c_*******@migh ty.co.za> wrote in message
news:%2******** ************@tk 2msftngp13.phx. gbl...
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 the "Connection Timeout=2400" string in the SqlConnection connections string
- disabled connection pooling.

the error seems to consistently come back after 30 seconds! I am using
Microsofts Data Application blocks for accessing SQL.
is there a timeout setting that i am missing???? or is this a bug?

Thanks!
Jason

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior) +44

System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma n dBehavior behavior) +5
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteDataset(Sq lConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParamete rs) +148
ppm.Post_to_GL. run_a_sp_Proces sedDeals() +246
ppm.Post_to_GL. btnPostToGL_Cli ck(Object sender, EventArgs e) +75
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o stBackEvent(Str ing eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1277

Nov 18 '05 #5
The Connect Timeout property of the Connection String will specify how
long the underlying provider will wait before a Connection Timout
occurs. After you connect this is not going to be used unless you
perform a reconnection again.

You can try to use a SQLCommand object but specify the Timeout Property.
I am not sure about the Application Block as I am not at my desk. Should
you require please drop me an email or post to this forum.

The Default is 20 seconds for a sql command to timeout. If it a heavily
used table then try to add the WITH (NOLOCK) clause for your select
statements.

Regards,

Trevor Benedict R
MCSD

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #6

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

Similar topics

8
5475
by: bdeviled | last post by:
I am deploying to a web environment that uses load balancing and to insure that sessions persist across servers, the environment uses SQL to manage sessions. The machine.config file determines how all applications will use sessions and to insure that all application use this method, the session properties cannot be overriden. Within the...
2
5312
by: David M. Nolf | last post by:
I have a web service that has a method that takes a fair amount of time to complete. One of my clients is stating that they are getting a timeout back. I am having difficulties getting my Windows XP workstation which is running the web service and a simple VB.NET test client to timeout on the method. I have looked and adjusted the...
2
4712
by: Dan | last post by:
All, I have a Web Service that validates a piece of data. However, the database that the data comes from is mamouth. So, it may take a long time for the validation query to complete. Unforuntatley, I tend to get a timeout message on my client which is not good. I want the client to wait until it gets a response. Can I adjust the amount...
4
9532
by: A.M-SG | last post by:
Hi, How can I increase the HTTP Timeout value at the client side? Thank you, Alan
1
2488
by: george | last post by:
Hi all, here's my index.asp file. I don't know where has gone wrong. can't run properly, just showing error ASP 0113 Script timeout <!--#include file="head.asp"--> <!-- begin masthead -->
12
2377
by: stormsender | last post by:
Hi there, I'm a noob to javascript, so was hopping to find some help here... I believe that what I need is simple, still haven't found any solution. I have a website serving ads, and links from several systems, and they always come in a format like: <script language=javascript src="http://something.com/script.php?id=26758765"></script ...
0
986
by: johnlim20088 | last post by:
Hi, Currenty I have a window based NET application running and have a following function to http post some data. string url = xxxx.aspx? parameter1=&parameter2=&..etc WebRequest request = WebRequest.Create(url); request.Timeout =150000; WebResponse response = request.GetResponse(); StreamReader stream = new...
1
1921
by: cmgmyr | last post by:
Hey All, I'm having a little problem with exporting data from my database. The problem is that the query seems to be too much for PHP and MySQL to handle since it is timing out. I have the timeout set right now at 3 minutes. I can run this in phpMyAdmin and it usually takes 4-5 minuted to complete. I do not want to have to make the client...
4
144343
Atli
by: Atli | last post by:
Introduction In this article I aim to explain the reasons why PHP sessions expire after a set period of inactivity, and how this mechanism works. I'll describe two commonly used methods to control the lifetime of a session, and show how to do so in your code. The problem PHP's session mechanism allows us to store data for clients on the...
0
7615
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7539
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7819
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7581
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6170
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5446
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5165
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3566
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1149
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.