473,320 Members | 2,104 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Response Buffer Limit Exceeded Problems - Ideas Please!

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 reported. Here's the code I have to do
this check:

'Check to see if there are any assemblies not in the database!
strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where
substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND
plantcode = " & Request.Querystring("pcode")
rsAFON.Open strSQL, adoCon
if rsAFON.eof = false then
do while rsAFON.eof = false
response.write("<tr><td colspan=15 bgcolor=000000 class=hilite
align=center>***WARNING *** MODEL TYPE: " & rsAFON("deadmodel") & "IS NOT IN
THE DATABASE! PLEASE NOTIFY ISD IMMEDIATELY!</td></tr>")
loop
end if
When I run the SQL String in SQL's Query Analyzer, I get the expected
results. However, when I run it in an ASP page, I get this error:
---------------
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/ptest.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its
configured limit.
-------------------
Does anyone have any ideas? I've also made this into a Stored Procedure as
well, but I received the same results. I'm running this page on an IIS 6.0
/ Win2k3 Web Edition box. All of my other SQL queries run except this one.
Does it have anything to do with it doing another select from within the
statement? If so, is there a better way to write this piece of code?
Thanks!

Brian.

Jul 19 '05 #1
3 17288
Turn the Response.Buffer off on the page, or on the entire site.

Response.Buffer = False

at the TOP of the page before any ASP code.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Brian Piotrowski" <bp*********@NOSPAM.simcoeparts.com> wrote in message
news:uQ*************@tk2msftngp13.phx.gbl...
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 reported. Here's the code I have to do
this check:

'Check to see if there are any assemblies not in the database!
strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where
substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND
plantcode = " & Request.Querystring("pcode")
rsAFON.Open strSQL, adoCon
if rsAFON.eof = false then
do while rsAFON.eof = false
response.write("<tr><td colspan=15 bgcolor=000000 class=hilite
align=center>***WARNING *** MODEL TYPE: " & rsAFON("deadmodel") & "IS NOT IN THE DATABASE! PLEASE NOTIFY ISD IMMEDIATELY!</td></tr>")
loop
end if
When I run the SQL String in SQL's Query Analyzer, I get the expected
results. However, when I run it in an ASP page, I get this error:
---------------
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/ptest.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its
configured limit.
-------------------
Does anyone have any ideas? I've also made this into a Stored Procedure as well, but I received the same results. I'm running this page on an IIS 6.0 / Win2k3 Web Edition box. All of my other SQL queries run except this one. Does it have anything to do with it doing another select from within the
statement? If so, is there a better way to write this piece of code?
Thanks!

Brian.

Jul 19 '05 #2
"Brian Piotrowski" wrote in message
news:uQ*************@tk2msftngp13.phx.gbl...
: 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 reported. Here's the code I have to do
: this check:
:
: 'Check to see if there are any assemblies not in the database!
: strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where
: substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND
: plantcode = " & Request.Querystring("pcode")
: rsAFON.Open strSQL, adoCon
: if rsAFON.eof = false then
: do while rsAFON.eof = false
: response.write("<tr><td colspan=15 bgcolor=000000 class=hilite
: align=center>***WARNING *** MODEL TYPE: " & rsAFON("deadmodel") & "IS NOT
IN
: THE DATABASE! PLEASE NOTIFY ISD IMMEDIATELY!</td></tr>")
: loop
: end if
:
:
: When I run the SQL String in SQL's Query Analyzer, I get the expected
: results. However, when I run it in an ASP page, I get this error:
: ---------------
: Response object error 'ASP 0251 : 80004005'
: Response Buffer Limit Exceeded
: /ptest.asp, line 0
: Execution of the ASP page caused the Response Buffer to exceed its
: configured limit.
: -------------------
: Does anyone have any ideas? I've also made this into a Stored Procedure
as
: well, but I received the same results. I'm running this page on an IIS
6.0
: / Win2k3 Web Edition box. All of my other SQL queries run except this
one.
: Does it have anything to do with it doing another select from within the
: statement? If so, is there a better way to write this piece of code?
: Thanks!

See if this will help.
http://www.experts-exchange.com/Web/..._20726698.html

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 19 '05 #3
Thanks to everyone who responded. I was able to fix the problem by putting
a MOVENEXT command before the LOOP. Thanks to Mark for that tidbit of info.

Brian.

"Roland Hall" <nobody@nowhere> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
"Brian Piotrowski" wrote in message
news:uQ*************@tk2msftngp13.phx.gbl...
: 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 reported. Here's the code I have to do : this check:
:
: 'Check to see if there are any assemblies not in the database!
: strSQL = "select substring(mtoc,2,6) as deadmodel from bos_data where
: substring(bos_data.mtoc,2,6) not in (select code from tire_matrix) AND
: plantcode = " & Request.Querystring("pcode")
: rsAFON.Open strSQL, adoCon
: if rsAFON.eof = false then
: do while rsAFON.eof = false
: response.write("<tr><td colspan=15 bgcolor=000000 class=hilite
: align=center>***WARNING *** MODEL TYPE: " & rsAFON("deadmodel") & "IS NOT IN
: THE DATABASE! PLEASE NOTIFY ISD IMMEDIATELY!</td></tr>")
: loop
: end if
:
:
: When I run the SQL String in SQL's Query Analyzer, I get the expected
: results. However, when I run it in an ASP page, I get this error:
: ---------------
: Response object error 'ASP 0251 : 80004005'
: Response Buffer Limit Exceeded
: /ptest.asp, line 0
: Execution of the ASP page caused the Response Buffer to exceed its
: configured limit.
: -------------------
: Does anyone have any ideas? I've also made this into a Stored Procedure
as
: well, but I received the same results. I'm running this page on an IIS
6.0
: / Win2k3 Web Edition box. All of my other SQL queries run except this
one.
: Does it have anything to do with it doing another select from within the
: statement? If so, is there a better way to write this piece of code?
: Thanks!

See if this will help.
http://www.experts-exchange.com/Web/..._20726698.html

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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...
6
by: tigr | last post by:
I am trying to read BLOBs from a large table (i.e., greater than 34K rows) using Java and the IBM JDBC driver (actually through an Application server). I get the following: SQL0429N The...
0
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...
1
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...
3
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 =...
5
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...
4
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...
1
by: Gurpal | last post by:
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...
14
by: S N | last post by:
I am using the following code to hide the download url of files on my website. The code uses Response.Binarywrite to send file to the client. Kindly indicate the maximum size of the file that can be...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.