Getting report problems

25 Feb 2005 10:43 AM

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

--

25 Feb 2005 4:15 PM

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.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

Show quote

"Utada P.W. SIU" <wing0***@hotmail.com> wrote in message
news:e9vVIayGFHA.3472@TK2MSFTNGP09.phx.gbl...
> 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
>
> --
>
>