错误:经典ASP中超出了响应缓冲区的大小 [英] Error: response buffer size exceeded in classic asp

问题描述

大家好，

我正在运行一个简单的查询以从数据库中获取数据&；显示它们.我收到一条错误消息，指出已超过响应缓冲区限制.

错误是:

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.

我还在循环中尝试了Response.flush，并在页面顶部使用了response.buffer = false，但是仍然没有任何数据.

我的数据库包含5600条记录.请给我一些步骤或代码以解决此问题.还有其他解决方案吗?

感谢

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

推荐答案

您可以尝试将AspBufferingLimit的值设置得更高.请参阅此处: IIS元数据库:AspBufferingLimit [ ^ ]

在您这样做之前，我强烈建议您在APS页面中使用测试SQL语句，该语句仅返回说10或20条记录. ASP缓冲区默认为4MB，这意味着每条记录的平均输出超过749字节的标记.如果您尝试使用仅给您几行的SQL语句，则可以验证您的ASP页通常可以正常工作.如果在限制SQL记录集之后仍然存在相同的问题，则页面中可能存在一个错误，使它陷入无限循环，就像忘记在结果集上进行下一步一样.

干杯！

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!

我在记录集中还使用了movenext进行循环.在循环中也使用了Response.flush和
在该代码中也为response.buffer = false，但仍然会给出错误
还有其他方法可以解决错误

看到我的代码是:

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:

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

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

<%
                                rsMaint.movenext
                                loop
                            %>

这篇关于错误:经典ASP中超出了响应缓冲区的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！