"There are not enough free System Resources to perform this operation."
Posted on 2006-11-10
I get this error "There are not enough free System Resources to perform this operation." while running a report engine that I'm upgrading to use ADO.NET (worked fine with ADO). It is essentially checking a Queue table every 3 seconds to see if a request has been made. I'm using a SQL Data Reader, SQL Connection and SQL Command.
Here's the odd thing though, when the program throws the system resources error there are still plenty of system resources left. The hard disk has 8 of 20 gig left. The engines at crash time are taking up 54MB and 37MB of memory respectively and the commit charge via the task manager is only 287MB/1246MB.
I'm disposing of my SQLCommands and setting the commands and data reader = nothing. The connection is left open throughout the lifetime of the .EXE. Thoughts on why this is happening?