ASP page generates "Response Buffer Limit Exceeded " : ASP, SQL, Forms, SQL Server 2000

Experts Exchange

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

ASP page generates "Response Buffer Limit Exceeded "

Asked by SamuelClemmons in Active Server Pages (ASP), Windows 2000 Server

Tags: ASP, SQL, Forms, SQL Server 2000

This page should work and in fact does work on another server. I made some minor name changes in the name of the page but nothing else. There are three other pages two of which get the same error. One of them loads just fine so I know the connection strings are working.

The whole error reads:

Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/pacinet/BilletScanner/BilletScanDefects4_F.asp, line 0

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

I did a Google serarch and came up with this which seems promising but this page is hosted on a company server and not IIS on my computer. This is what I found:

If you get the above error when you click on an attachment, the attachment is larger than IIS is configured to allow. Change the AspBufferingLimit setting in Metabase.xml to a larger size. The default value is 4194304, which is about 4 MB. Change this to whatever limit is reasonable for the types of files your users will be attaching.

This change does not require stopping IIS, but to make the Metabase.xml file write-able, you need to go to the IIS control panel, right click the server, select properties, and check off the box that says allow changes to MetaBase configuration while IIS is running.

Is there something like this I need to change on our server? We are using SQL Server 2000. I don't have access to this and will have to ask someone to make the changes for me.

Most of the others talked about selecting too large of a record set or changing the buffer on the IIS which is not really my problem... I think.

Here's the page

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:

           
           
             <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="Connections/LISADATACONNECT.asp" -->
<!--#include file="dim_F.asp" -->
<%' This is the only thing that we need in this page for getting the records from the BillerScanX table
Set BilletScanX_cmd = Server.CreateObject ("ADODB.Command")
BilletScanX_cmd.ActiveConnection = MM_LISADATACONNECT_STRING
BilletScanX_cmd.CommandText = "SELECT TOP 50 BilletID, TagNumber, ScanTo, DateScanned, TagGroup FROM BilletScanX" 
BilletScanX_cmd.Prepared = true
Set rs_BilletScanX = BilletScanX_cmd.Execute
 
Set BilletScanX_DS_cmd = Server.CreateObject("ADODB.Command")
BilletScanX_DS_cmd.ActiveConnection=MM_LISADATACONNECT_STRING
BilletScanX_DS_cmd.Prepared = true
BilletScanX_DS_cmd.commandtext = "SELECT BilletID, TagNumber, ScanTo, DateScanned, TagGroup, TagShift FROM BilletScanX"
Set rs_BilletScanX_DS = BilletScanX_DS_cmd.Execute
 
 
' This gets the values from the form
strTN = trim(Request.Form("TagNumber"))
strON = trim(Request.Form("OperatrName"))
strDS = trim(request.Form("RipDefectTimeDate"))
strRW = trim(Request.Form("RipWidth"))
strD = trim(Request.Form("Delam"))
strMB = trim(Request.Form("M_Blow"))
strUB = trim(Request.Form("U_Blow"))
strRE = trim(Request.Form("RoughEdge"))
strS = trim(Request.Form("Slip"))
strO = trim(Request.Form("Other"))
mmrec = int(Request.Form("MM_recordId"))
' This checks to see if the Form has been passed, if so, then process the form and retrieve it's data
if request.Form("MM_insert")="form1" then 
    Set MM_editCmd = CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_LISADATACONNECT_STRING
    MM_InsertCmd = "insert into RipsawBilletUsage (TagNumber, OperatorName, DateScanned, RipWidth, Delam, M_Blow, U_Blow, RoughEdge, Slip, Other)values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        'response.Write"strTN - "&strTN&" <br />strON - "&strON&" <br />strRW - "&strRW&" <br />strD - "&strD&" <br />strMB - "&strMB&" <br />strUB - "&strUB&" <br />strRE - "&strRE&" <br />strS - "&strS&" <br />strO - "&strO&" <br />mmrec - "&mmrec&" <br />" 
        'response.End()
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@TagNumber", 201, 1, 50, strTN) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@OperatorName", 201, 1, 50, strON) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@DateScanned", 201, 1, 50, strDS) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@RipWidth", 201, 1, 50, strRW) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@Delam", 201, 1, 50, strD) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@M_Blow", 201, 1, 50, strMB) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@U_Blow", 201, 1, 50, strUB) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@RoughEdge", 201, 1, 50, strRE) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@Slip", 201, 1, 50, strS) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@Other", 201, 1, 50, strO) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("@RipDefectID", 5, 1, ,mmrec) ' adDouble
    MM_editCmd.CommandText=MM_InsertCmd
    MM_editCmd.Execute
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Billet Scan Defects</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #FFFFFF;
	background-image: url(images/lightlogo60.gif);
}
.style5 {
	color: #FFFFFF;
	font-weight: bold;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
}
<%'This is the CSS information for Page: cr3.asp%>
#MainTable{
width:1100px;
border:1px;
background-color:#CCCCCC;
padding:1px; /*cellpadding*/
border-spacing:1px; /*cellspacing*/
}
.tdResults{
text-align:center;
border:1px #999999 dotted;
}
.tdResult{
text-align:left;
border:1px #333333 double;
}
-->
</style>
<script type="text/javascript"> 
if(window.addEventListener){ 
window.addEventListener('load',switchme,false); 
} 
else { 
if(window.attachEvent){ 
window.attachEvent('onload',switchme); 
} 
} 
 
function switchme(){ 
 
df=document.forms[0]; 
 
df[0].onchange=function(){ 
 
switch(this.value) { 
<%
While NOT rs_BilletScanX_DS.EOF
'the df[2] line:35 & 42   this is the form Element Number, For the Fieldname: RipDefectTimeDate   DO NOT CHANGE%>
case '<%=rs_BilletScanX_DS("TagNumber")%>': 
df[2].value='<%=rs_BilletScanX_DS("DateScanned")%>'; 
break; 
 
<%rs_BilletScanX_DS.movenext
wend%>
 
default: 
df[2].value=''; 
break; 
} 
} 
} 
</script> 
</head>
<body>
<form name="form1" method="POST" action="">
 
<table  border="2" cellpadding="2" cellspacing="0" bordercolor="#000000" background="images/lightlogo60.gif" id="BilletDefects">
  <tr bgcolor="#000000">
    <td><span class="style5">Tag Number </span></td>
    <td><span class="style5">Oper. Name</span></td>
	<td><span class="style5">Date Scanned</span></td>
    <td><span class="style5">Rip Width Inch</span></td>
	<td><span class="style5">Rip Width MM</span></td>
    <td><span class="style5">No. of Delams</span></td>
    <td><span class="style5">No.  of M-Blows</span></td>
    <td><span class="style5">No. of U-Blows</span></td>
    <td><span class="style5">  Rough Edges</span></td>
	<td><span class="style5">No. o f Slips</span></td>
    <td><span class="style5">Comments</span></td>
    <td>&nbsp;</td>
  </tr>
  <% 
While ((Repeat1__numRows <> 0) AND (NOT rs_BilletScanX.EOF))
rs_BilletScanX.MoveNext
   Wend
 
%>
  <tr bgcolor="#FFFFFF">
    <td><select name="TagNumber">
<option value="Choose One" selected="selected">Choose One</option>  
<%While NOT rs_BilletScanX.EOF%>
<option value="<%=rs_BilletScanX("TagNumber")%>"><%=rs_BilletScanX("TagNumber")%></option> 
<%rs_BilletScanX.movenext
wend%>
</select> </td>
 
<%
OpName = trim(request.Form("OperatrName"))
%>
<div id="ExtraInfos">Select search option</div> 
 
<td><input type="text" size="10" name="OperatrName" value="<%=Session("OpName")%>"></td>
	<td><input name="RipDefectTimeDate" type="text" size="10"></td>
	<td><input type="text" size="10" name="RipWidth"></td>
	<td><input type="text" size="10" name="RipWidth2"></td>
    <td><input type="text" size="10" name="Delam"></td>
    <td><input type="text" size="10" name="M_Blow"></td>
    <td><input type="text" size="10" name="U_Blow"></td>
    <td><input type="text" size="10" name="RoughEdge"></td>
	<td><input type="text" size="10" name="Slip"></td>
    <td><input type="text" size="10" name="Other"></td>
    <%'I had to move these hidden form elements over here, as they were messing up my Form Count    DO NOT MOVE!!!!!%>
    <td colspan="5" rowspan="2"><span class="style5"></span><span class="style5"></span><span class="style5"></span><span class="style5"></span>
	  <input type="hidden" name="Grade">
	  <input type="hidden" name="Thickness">
	  <input type="hidden" name="Length">
	  <input type="hidden" name="Pieces">	  
	  <input type="hidden" name="shift"></td>
      <%'End of moved 'hidden' form elements  DO NOT MOVE!!!!!!!!!!%>
  </tr>
</table>
  <input type="submit" name="Submit" value="Submit">
  <input type="hidden" name="MM_insert" value="form1">
</form>
<%'Now we need to get all the records that have been inserted%>
<!--#include file="cr3_F.asp"-->
</body>
</html>

           
         

20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. carrzkiss724,829
2. sybe274,601
3. hielo204,696
4. angelIII170,538
5. x_com106,709
6. R_Harrison101,107
7. ryancys98,848
8. b0lsc0tt95,363
9. jkdt007792,607
10. neeraj52388,506
11. apresto74,890
12. DanielWilson72,330
13. samic40067,360
14. gawai63,650
15. rg2063,580
16. acperkins61,340
17. golfDoctor58,470
18. sunithnair53,765
19. govindaraj...52,288
20. kevp7550,675
21. Badotz49,125
22. DarthSonic47,300
23. daveamour46,990
24. abel46,728
25. _Stilgar_44,034

1. fritz_the...3,975,430
2. alorentz1,929,293
3. amit_g1,339,338
4. hielo1,238,653
5. b0lsc0tt939,845
6. hongjun922,466
7. ap_sajith921,034
8. kevp75918,733
9. WMIF899,748
10. angelIII896,563
11. sybe839,816
12. jitganguly786,812
13. carrzkiss728,769
14. acperkins721,448
15. peh803684,060
16. ryancys679,899
17. neeraj523631,204
18. Silvers5625,555
19. carl_tawn600,110
20. GaryC123576,347
21. apresto525,417
22. golfDoctor520,113
23. SquareHead517,787
24. deighc466,721
25. gladxml429,512

ASP page generates "Response Buffer Limit Exceeded "

Asked by SamuelClemmons in Active Server Pages (ASP), Windows 2000 Server

Tags: ASP, SQL, Forms, SQL Server 2000

About this solution