How can I modify script timeout?

tlbacon527 · February 2nd, 2004, 01:45 PM

Hi,

I am running a query through my web page that accesses an SQL database and I seem to be running into a time out issue occassionally. I receive the following error

Active Server Pages error 'ASP 0113'
Script timed out

/Garth/displayreport.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

How may I set the script timeout from the program as I have no access to the server administration tools?

Thanks for your help,
Tamara

bmains · February 2nd, 2004, 03:54 PM

On the connection and command objects, there is a timeout property. I believe it is the ConnectionTimeout and CommandTimeout properties, which you set to 0, and there isn't a timeout.

tlbacon527 · February 2nd, 2004, 03:56 PM

Thank you I will look those up and try that

Thank you
Tamara

mega · February 5th, 2004, 09:24 AM

Hi Tamara.
You can check out how long the timeout period is and set it by adding this to your page:

Code:

<%
  Dim intTimeOut
  intTimeOut = Server.ScriptTimeOut
  Response.Write(intTimeOut)
  Server.ScriptTimeOut = 100 ' set it to 100 sec.
  Response.Write("" & intTimeOut)
%>

- mega