[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ASP Buffer Limit Issue

Posted on 2011-10-25
6
Medium Priority
?
345 Views
Last Modified: 2012-06-27
I am trying to run a script that is throwing an error if it returns more than 290 records from a database.  I can run the query that appears to be returning the error in the sql server console with no problem.  Here is the error:

Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/some_page.asp, line 0

Execution of the ASP page caused the Response Buffer to exceed its configured limit.

Any help would be much appreciated.  I have stepped through the code and can not find a problem.  I am writing data to the page using a dynamic array.  If I request a 291st row I get the error.  If I request 290 or less all is fine.
0
Comment
Question by:Bob Schneider
  • 3
  • 2
6 Comments
 
LVL 3

Assisted Solution

by:karl-henrik
karl-henrik earned 600 total points
ID: 37023766
You can turn Buffer limit off with this line if the @Page directive I think.

<%@Page Language="C#" Buffer="False"%>

//Karl.
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 1400 total points
ID: 37023770
Turn off buffering:

<%Response.Buffer = False%>

Seeing your code may help if this doesn't work for you.

0
 

Author Comment

by:Bob Schneider
ID: 37023775
I will try that but that does not resolve the root of the problem.  I routinely request in excess of 290 records, although I don't know that I do that with that dsn.  Could that be a problem?  Is there an IIS setting or a dsn setting that I am missing?
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
LVL 3

Assisted Solution

by:karl-henrik
karl-henrik earned 600 total points
ID: 37023784
If you get the Response Buffer Limit Exceeded error when your code is valid you can call Response.Flush command and this will immediately sends all current buffered page content to the client
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 1400 total points
ID: 37023788
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 1400 total points
ID: 37023790
If you turn off buffering don't use Response.Flush as you'll get a runtime error.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question