Getting report problems

[Utada P.W. SIU]

Deall All Experts,

I am not sure I posted in right group or wrong group, but please help me

I have wrote a ASP application, which retrieve data from sql server, and do
some calculation, then generate report to user.

However, the runtime of the application is too long and as a result, the
page redirect to "DNS error" error page to me.

I have disabled a part of code, and run the application again, it sees work,
however, if I run the whole application, it error again.

How to solve the problems? I have set the connection time for IIS is one day
(86400 seconds), but it cannot solve my problem.

Please help me... thanks

m(_ _)m

P.S. window 2000 without .Net installed, and IIS 5.0

--

 

[Mark Schupp]

That is a timeout on the client side in the browser. There is nothing you
can do about it except try to send some data to the browser before the
timeout. Try something like this (there are other variations on this, search
one of the ASP like asp101.com sites for "status bar"):

Response.Buffer = True

Response.Write "processing...<br>"
Response.Flush

process for a while...

Response.Write "still processing...<br>"

process some more..

and so on.