Re: ADO/ASP timeout issue

Subrata wrote on Fri, 27 Jan 2006 11:56:00 +0530:

> In our .NET application, we are querying a Sybase database to retrieve
> records that needs to be displayed on the screen. We have a sql which
> takes more than 2 mins to run. When executing the same from aspx page, the
> application does not wait till 2 mins. It waits exactly 60 secs and then
> gives a "Timeout Exceeded" Error.
>
> Checked out the site, http://www.dotnetjunkies.com/Forums/ShowPost.aspx?PostID=8996
> to solve this issue. Tried changing the connection string but still it
> didn't help.
>
> On dev environment it waits for 60 secs but the same application on
> staging machine takes only 30secs to throw the error message above. Are
> there any settings where we can increase the time out period from the .NET
> application to the database?

Is it definitely an error from ADO, or is it an ASP error? "Time Exceeded"
sounds more like an ASP error - try adding

Script.Timeout = 600

at the top of the page (this sets the script engine timeout to 10 mins - 600
seconds - you could try lower settings once you've determined that this is
the cause of the error rather than ADO).

Dan


.

Relevant Pages