About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 12/11/2006 Subject: reg Script Time Out Error
Question Hi,
I am Using a ASP Page which retrives 5000 records from the Database and prints it along with some text.One Record per page.The time taken to execute the query is just 5sec when I call it in the Asp page without any text then it works fine but when the text is included it ends up with Script Timeout error.
Can you help me with this error.
Regards,
Aarthy
Answer Without seeing the code itself thatgenerates the recordset and the timeout error I would have to say no. The only thing I have questions about is if the text that is being added is timing the script out. Is it thesame text for every record or is it thevalueofsome text filed within the recordset itself?
Have you tried setting the server level application variable for scripttimeout to some other time?
It works like this:
IIS by default sets script time out at 90 seconds so if you set script timeout for less than this the setting is ignored. You can set a different timeout by doing the following:
<%
Server.ScriptTimeout = 100 'or some other number greater than 90
%>
This then tells the server to not timeout the script until 100 seconds haspassed. So, the numeric value you apply to this setting is the number of seconds you want to wait before the script times out.