Click here to Skip to main content
13,195,379 members (60,029 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hello All,

I am running a simple query to get data out of my database & display them. I'm getting an error that says Response Buffer Limit Exceeded.

Error is:
Response object error 'ASP 0251 : 80004005' 
Response Buffer Limit Exceeded 
/abc/test_maintenanceDetail.asp, line 0 
Execution of the ASP page caused the Response Buffer to exceed its configured limit.

I have also tried Response.flush in my loop and also used response.buffer = false in my top of the page, but I am still not getting any data.

My database contains 5,600 records for that. Please give me some steps or code to solve this. Is there any other solution for that?

Posted 10-Feb-11 23:55pm
Updated 11-Feb-11 0:05am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can try to set the value of AspBufferingLimit higher. See here: IIS Metabase: AspBufferingLimit[^]

Before you do that I strongly advise you to use a test SQL statement in you APS page that only returns lets say 10 or 20 records. The ASP buffer defaults to 4MB which means your average output per record is above 749 bytes of markup. If you try a SQL statement that gives you only a couple of rows you can verify that your ASP page generally works. If you still have the same problem after restricting the SQL recordset there is probably a bug in your page that puts it into an infinite loop, like forgetting to do a move next on the resultset.

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Hi ,

I have also used movenext in my recordset for the loop.I have also used Response.flush in my loop and
also response.buffer = false in that code but still it gives error
Is there any other way to solve the error

see my code is:

<% do while not rsMaint.eof %>
                                vBoardSKU = rsMaint("RecordID")

vSql = "SELECT mediavendors.CompanyName from boards inner join mediavendors on boards.vendorid = mediavendors.vendorid where boards.recordid = '" & vBoardSKU & "'"
                                Set rsMaint2= PerformSQL3( vSql , 1 )


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.171019.1 | Last Updated 14 Feb 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100