"Script timed out" error

I am trying to retrieve a data over web using SQL2005 and ASP page.

I am still not able to fix my issue.
"Script timed out"

I think if I query data at SQL2005 directly, it takes about 2 min 38 sec.
and I am able to get data.

So, I am trying to fix at ASP coding.

First, I set up
<% server.ScriptTimeout = 10000 %>, but still getting error.

Second,
I have this set up this during the retrieval of recordset using a stored
procedure.
..ConnectionTimeout = 4800
..CommandTimeout = 4800

Thirdly,I had placed "Response.Flush" at the end of looping of data.

But I am still getting error.

If it runs fine at the SQL server directly, what can I do at ASP page?

I would appreciate for any help.
Thanks.
.

Relevant Pages

  • Re: Weird Problem
    ... I have a form that post to an ASP page, ... try to retrieve those values from the form using this: ... Prior to receiving this error, I was receiving a Type Mismatch on this ... Have you inadvertently named a function Request? ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to retrieve current Windows User Handle from ASP
    ... I use Basic Authentication, so I retrieved the Base64 string from ... ASP code, using HTTP_AUTHORIZATION servervariable. ... >> is it possibile to retrieve the current Windows User Handle from ASP ...
    (microsoft.public.inetserver.asp.general)
  • Re: Retrieve local machine enironment variable from Html using javascr
    ... My goal is to retrieve my local machine's %USERNAME% environment variable ... %USERNAME% from HTML or ASP page? ...
    (microsoft.public.scripting.jscript)
  • SHXXX API in .NET Assembly called from ASP
    ... Fonts folder path. ... Windows 2000 professional ... from the ASP application. ...
    (microsoft.public.dotnet.framework.interop)
  • Re: accessing a value in all the pages
    ... am new in asp leave alone asp.net how would i do that ... Initial page sets value in database, subsequent pages retrieve value ... Initial page sets cookie value, ...
    (microsoft.public.dotnet.framework.aspnet)
Loading