Resolving 'Response object error: Unable to allocate required memory"

[jmartmem]

Greetings,

I have a webpage that, on the click of a button, generates a dynamic, Classic ASP-based result set that exports into Microsoft Excel. Some of my result sets exceed the virtual memory maximum, and I get the following error:

Response object error 'ASP 0100 : 8007000e'
Out of memory
/CIMS/ExportToExcel_TrkgCust.asp, line 0
Unable to allocate required memory.

I've turned off the buffer, but it hasn't resolved the problem, and I'm seeking ways to resolve the issue without changing the metafile, if possible.

Here's the first few lines of code to show the Excel export and turning off the buffer:

<% Response.ContentType = "application/vnd.ms-excel" %>
<% Response.Buffer=false%>

I welcome whatever help anyone can offer.

Regards,

j

[jhardman]

Instead of turning off the buffer, have you tried setting it very high?

Jared

[jmartmem]

I haven't because it's my understanding that you can't change the buffer size. How would I go about setting the buffer very high?

[jhardman]

After writing that I started thinking that I was way off. You can turn the timeout way up...

But that isn't the issue here, you need to look in iis settings. I'll ask an iis expert to look in to the issue.

Jared

[Frinavale]

What version of IIS are you using?
Have you considered allocating more memory to your application through IIS?

-Frinny

[jmartmem]

I'm running Windows Server 2003 R2, which means I have IIS 6.0. How do I use IIS to allocate more memory to my application?