IIS and memory issues

[MikeT]

I have an intranet page that grabs a list of dBase database names from an Access database. I put that list into an array, and then search each one for certain criteria. There are about 20 dBase databases to search through, and they range in size from 300K to 1.5MB.

Each time the databases are searched, the inetinfo.exe process increases by about a megabyte. After a few days, the inetinfo process is consuming large amounts of memory, and eventually stops searching the databases and returns an error about 'too much memory being allocated'.

I have closed and destroyed all adodb.connections and recordsets.

 

[GabeC]

I'm not sure what your code is doing but some process is not finishing.
This is a common problem when a do while not RS.EOF..loop type logic is executed but the RS.movenext method is never called. Look through your code to make sure all logic loops will always exit the looping.

Thanks,

Gabe

 

[MikeT]

All loops are properly closed; the page runs fine until the server running it won't give it anymore memory to eat up.