By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

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

P: 87
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:

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.

Regards,

j
Nov 15 '10 #1
Share this Question
Share on Google+
5 Replies


jhardman
Expert 2.5K+
P: 3,405
Instead of turning off the buffer, have you tried setting it very high?

Jared
Nov 16 '10 #2

P: 87
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

jhardman
Expert 2.5K+
P: 3,405
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
Nov 16 '10 #4

Frinavale
Expert Mod 5K+
P: 9,731
What version of IIS are you using?
Have you considered allocating more memory to your application through IIS?

-Frinny
Nov 16 '10 #5

P: 87
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.