Re: 8007000e Error - ASP/ODBC GetRecordSet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the reply. Unfortunately we are not seeing the same with RAM.
There's plenty of free ram when this happens.

We have (at least temporarily) Cirumvented the problem by running IIS6 in
IIS5 Isolation mode, but I not real happy with that. Perhaps our problem
stems from most of the code being legacy "classic" asp?

And thanks for the tip on the IIS Process rceyele tool. I'm going to have a
look at that.

"Roberto Franceschetti" wrote:

On a couple of our Win *2K* (not 2k3) servers we see the same issue when
the inetinfo process in Task manager reports about 1.2GB - 1.4GB or RAM
usage. Any time this RAM usage is exceeded ODBC calls result in this
message. Our only solution is to recycle IIS (we use the utility
IIS5Recycle to do this when a specified RAM threshold is exceeded).

If by any chance this is your same cause, you could try using the
Application Pool properties for your App Pool in IIS to have the worker
process recycled after exceeding a specified max virtual memory size.

--
Roberto Franceschetti
LogSat Software
Makers of Spam Filter ISP
http://www.logsat.com



tthompson164 wrote:
One of our websites is experiencing "8007000e Not Enough Storage to complet
the operation" when fetching a large record set using ODBC. The data source
is MSSQL. We have checked the code for the usual suspects - not closing
connections, not setting connection to nothing and cleaned that up but still
this erro happens. Once it does ASP is hosed and an IISRESET is the cure.

Has anyone had a similar problem and cured it? Are there setting on the
server or IIS that could be causing this. We are running out of leads to
follow. Any help or suggestions would be great. Thanks.


.

Relevant Pages

  • Re: High Amount of memory
    ... low of a number IIS crashes or freezes...nice fix. ... 12, 37, and 139 mb of RAM. ... If you're not already at Windows Server SP2, I'd either install that or get ... the fix below to see if that solves the w3wp part of the issue. ...
    (microsoft.public.windows.server.sbs)
  • Re: major iis5 asp performance problems
    ... If the solution is to add more ram, which is very likely, the fact you can't upgrade won't help your situation. ... LogFileManager - The only IIS Logfile Management Tool ... > - changing the IIS max memory settings in the registry ...
    (microsoft.public.inetserver.iis)
  • Re: memory used for inetinfo.exe
    ... put more RAM into the machine... ... > check the logs everyday. ... > things with IIS here since there have been so many different variety of ... > things that people have seen with IIS. ...
    (microsoft.public.inetserver.iis.security)
  • Re: W2003 IIS & SQL 2000 Server co-resident? Scaling Issues?
    ... SQL can be RAM and CPU intensive, IIS is rarely CPU ...
    (microsoft.public.inetserver.iis)
  • Re: Problem installing RAM, XP home, System32/drivers/pci.sys, HELP!!!
    ... your HP Pavilion 7915 PC can only ... > support up to 512MB of RAM, ... How is that exceeding the cpacity of the machine? ...
    (microsoft.public.windowsxp.help_and_support)