Error: response buffer size exceeded in classic asp

Question

0.00/5 (No votes)

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?

Thanks

Posted 10-Feb-11 23:55pm

msheth

Updated 11-Feb-11 0:05am

Slacker007

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Manfred Rudolf Bihy · Answer 1 · 2011-02-11T02:40:00

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!

msheth · Answer 2 · 2011-02-14T02:12:00

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:

VB

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

SQL

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

VB

<%
                                rsMaint.movenext
                                loop
                            %>

Error: response buffer size exceeded in classic asp

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0