Response Buffer Limit Exceeded - ASP / Active Server Pages

I'm getting this error when I test this page. Here is the error:

Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/test/test4.asp, line 0

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

Here is the entire asp page code:

Expand|Select|Wrap|Line Numbers

 
<%

 set con = Server.CreateObject("ADODB.Connection")

 con.Open "File Name=E:\webservice\Company\Company.UDL"

 set rs = Server.CreateObject("ADODB.Recordset")
 
ID=request.querystring("ID")

IF ID <> "" then ID=ID else ID="9726" end if 'show default record 9726 but also allow me to

'type in a different record number and display that one
 
strSQL = "SELECT *, T_Programs.ID AS Expr1, T_ProgramGuests.ProgramID AS Expr2, T_ProgramGuests.GuestName AS Expr3, T_ProgramGuests.GuestDescription AS Expr4, T_ProgramLinks.URL AS Expr5, T_ProgramLinks.Description AS Expr6 FROM T_ProgramGuests CROSS JOIN T_Programs CROSS JOIN T_ProgramLinks"
 
rs.Open strSQL,con 'open a connection to the database

'response.write strSql 'output sql string data to the browser

%>
 
<%

'Response.Buffer=true

'Response.Flush

%>
 
    <body>

<TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">

<%
 
' THESE THREE LINES ARE COMMENTS ONLY...

' Check to see if the recordset is populated then loop through the records

' Do this until you reach the end of file
 
    do until rs.EOF
 
    %>
 
<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">

<tr><td><% Response.Write RS("GuestName") %></td></tr>

<tr><td><% Response.Write RS("GuestDescription") %></td></tr>

<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>

</table>
 
<%

loop

rs.movenext

%>
 
<%

RS.Close

Set RS = Nothing

Conn.Close

Set Conn = Nothing

%>
 
        </table>

  </body>

</html>

This is the output when it is almost working correctly. I'm so close on this. I just need to get the text URL to display correctly.

John H. Doe
author of The Lexicon. His new book is Fooled Again: How the Right Stole the 2004 Election.

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/test/test3.asp, line 29

So I added rs.movenext to the page. But now it shows a different message. Here is the message:

Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/test/test4.asp, line 0

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

Here is where I put the code:

Expand|Select|Wrap|Line Numbers

 
<TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">

<%
 
' THESE THREE LINES ARE COMMENTS ONLY...

' Check to see if the recordset is populated then loop through the records

' Do this until you reach the end of file
 
    do until rs.EOF
 
    %>
 
<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">

<tr><td><% Response.Write RS("GuestName") %></td></tr>

<tr><td><% Response.Write RS("GuestDescription") %></td></tr>

<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>

</table>
 
<%

loop

rs.movenext

%>
 
<%

RS.Close

Set RS = Nothing

Conn.Close

Set Conn = Nothing

%>

Did I put the rs.movenext in the wrong spot or is there other code I need to add to the page to make it display GuestName, Description and URL as text link "without errors"?

Apr 6 '07 #1

Subscribe Post Reply

6292

shweta123

692

Expert 512MB

Hi,

Try to write the code like this:
<%
while not rs.eof%>

<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
</table>

<%
rs.movenext
wend
%>

Apr 22 '07 #2

Similar topics

Response Buffer Limit Exceeded

by: Steve Bywaters | last post by:

I have the following error on a page ... I can fix it by making a large-ish block of text (almostr 4k) a little smaller. But what is ASP actually complaining about? Steve Response object...

ASP / Active Server Pages

Response Buffer Limit Exceeded Problems - Ideas Please!

by: Brian Piotrowski | last post by:

Hi All, I'm trying to run a simple query from an ASP page. I want the query to select each individual field in a table and compare it to another table. If the value doesn't exist, I want it...

ASP / Active Server Pages

Response Buffer Limit?

by: Patrick Bates | last post by:

I have an ASP page which is returning so much data that I'm receiving a message that the Response Buffer Limit has exceeded its configured values. Any idea where to find this configured value so...

ASP / Active Server Pages

Response Buffer Limit Exceeded Help Needed

by: Brian Piotrowski | last post by:

Hi All, I have an SQL Server 2000 table that contains less than 2000 records. I would like to select some of these records and group them. The query I wrote runs fine in SQL Server's Query...

ASP.NET

Response Buffer Error - Ideas Please!

by: Brian Piotrowski | last post by:

Hi All, I'm trying to run a simple query from an ASP page. I want the query to select each individual field in a table and compare it to another table. If the value doesn't exist, I want it...

ASP.NET

Using multiple _alloca()'s to build up a buffer

by: nickdu | last post by:

I usually try to stay away from _alloca(). However, I'm considering using it for a logging function. Our current logging function maintains its own buffer which it grows to fit the string being...

.NET Framework

HELP: Response Buffer Limit Exceeded

by: Jim Rojas | last post by:

I am running IIS v6.1 on a virtual hosting server. Changing the default metabase value is out of the question. Can someone tell me how I can fix this script? Thank you. <% set conn =...

Microsoft Access / VBA

Redirecting a big file with Response.BinaryWrite

by: twiggy182 | last post by:

Hi, I really need you help because I'm not very familliar with ASP and I could not find any solution to my problem. To put you in situation, I have a CGI to which I send a file name, and that...

ASP / Active Server Pages

recordset data getting truncted during response.write

by: cbtechlists | last post by:

I have an ASP app that we've moved from a Windows 2000 to a Windows 2003 server (sql server 2000 to sql server 2005). The job runs fine on the old servers. Part of the app takes a recordset and...

ASP / Active Server Pages

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server