Page Cannot be displayed

[leomou]

When we run a sql query which takes more than an hour thro. asp, client browser displays a message "Page cannot be displayed" immediately after one hour

Kindly let me know how can I disable this default one hour expiration time in browser. Or should I need to change anything on IIS other than connection and script timeout value.

thanks in advance

[goddess_spanky]

Have you added Response.Expires to your ASP scripts? Where the expires value equals the number of minutes you want to allow the script to run?

As long as you have verified that the SQL query is valid, you should not receive the "page cannot be displayed" after adding the response.expires to your script.

You will also need to check your SQL Server configuration (assuming you are using SQL server - if not, let me know). There is an option in SQL Server under server properties for query time-out (under connections tab). make sure that is set to zero.

Why does the query take more than 1 hour to run? That doesn't seem right, but anyway...