Response Buffer Limit Exceeded

[mdr2271]

I am trying to write to an Excel file from an ASP page, but get the Response Buffer Limit Exceeded error message. The file has 5200 records in it. Is there a setting I can change to allow this to open without error?

 

[Sheco]

Maybe you can use Response.Flush after every 500 rows or so?

 

[Turkbear]

Hi,
Which version of IIS are you using?

There is an entry in MetaBase.xml that controls the max size of that buffer ( in IIS6, at least)..

The Response.Flush is a better idea, usually since is saves memory usage and , if set carefully, does not significantly affect performance.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
I meant to add this to my last port:

If you do wish to edit the MetaBase.xml file:
Go into IIS Properties and enable direct Metabase Edit

Navigate to:
c:\Windows\system32\inetsrv\Metabase.xml
Increase buffer from ~4 to
AspBufferingLimit="8194304"
( Doubles the max size)

Note: The # of records is not the issue but the total size of the returned set is what needs to be below the max.






To Paraphrase:"The Help you get is proportional to the Help you give.."