System Resource Exceeded

Basically the problem relates to how ASP fundamentally works - even though you open a DB connection, it uses it only for the first SQL query. For subsequent queries on the same open connection then ASP spawns its own connection but doesn't properly release it, thus leading ultimately to server memory leaks which can only be resolved by rebooting the server.

It seems that the only way to prevent this happening is to use the following methodology in your ASP code.

For Each SQL Query
¤ Open DB connection
¤ Make recordset
¤ Use the data
¤ Close and kill the recordset
¤ Close and kill the connection
Next