Error running ASP page after 1 hour time span

[Guest]

I have an ASP page that I an using to read from one data base and load into another. This ASP takes more than an hour to execute. After abount an hour to an hour and a half I get the error "Cannot find server or DNS Error".
I think that the ASP is still running since I can query the data base and records are still being added. I set the scipt timeout and the session timeout to 3 hours but this happens long before then.

Any ideas?

 

[Eric Veltman]

I have an ASP page that I an using to read from one data base and load
into another. This ASP takes more than an hour to execute. After abount an
hour to an hour and a half I get the error "Cannot find server or DNS
Error". I think that the ASP is still running since I can query the data
base and records are still being added. I set the scipt timeout and the
session timeout to 3 hours but this happens long before then.

Hello Roy,

I guess the browser will not wait infinitely for a response.
What I normally do with long-running ASP pages is that I periodically
send some HTML or JavaScript to the client that updates the user interface.
This way the user stays informed and you don't get an inactivity timeout on
the connection.

Best regards,

Eric