Response Buffer Size

[Guest]

I am doing a SQL search through a FP 2002 asp page. Occasionally I get this
error when running the query:

Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/reporting/SQL_QUERIES/pending_work_all.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its
configured limit

When I run the query in SQL Analyzer, the number of returned rows is about
4500.

Is there a way to increase the response buffer?

 

[Guest]

By the way I did increase the metafile ASP buffer size to 999999999

 

[Kevin Spencer]

I'm not sure whether you can change the size of the Response buffer.
However, I wouldn't advise it. Your RecordSet is way too large. You might
want to use paging and get a manageable amount of data into your page that
way.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.