471,086 Members | 848 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

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


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:

Expand|Select|Wrap|Line Numbers
  1. Response object error 'ASP 0100 : 8007000e'
  2. Out of memory
  3. /CIMS/ExportToExcel_TrkgCust.asp, line 0
  4. 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:

Expand|Select|Wrap|Line Numbers
  1. <% Response.ContentType = "application/vnd.ms-excel" %>
  2. <% Response.Buffer=false%>
I welcome whatever help anyone can offer.


Nov 15 '10 #1
5 4214
3,406 Expert 2GB
Instead of turning off the buffer, have you tried setting it very high?

Nov 16 '10 #2
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?
Nov 16 '10 #3
3,406 Expert 2GB
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.

Nov 16 '10 #4
9,735 Expert Mod 8TB
What version of IIS are you using?
Have you considered allocating more memory to your application through IIS?

Nov 16 '10 #5
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?
Nov 16 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Harrie Verveer | last post: by

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.