Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP VBScript Errors
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?
 
Thanks
Posted 11-Feb-11 0:55am
msheth332
Edited 11-Feb-11 1:05am
Slacker00774.8K
v2
Rate this: bad
good
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.
 
Cheers!
  Permalink  
Rate this: bad
good
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 )
 
<%
                                rsMaint.movenext
                                loop
                            %>
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 6,803
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,421
3 Manas Bhardwaj 4,841
4 Maciej Los 4,330


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 14 Feb 2011
Copyright © CodeProject, 1999-2014
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