View Full Version : Loop ADODB objects

09-30-2005, 05:34 PM
Anyone know if this is possible?

Is there a method when page execution has finished in ASP to test whether any ADODB objects are still open and, if so, to loop through the open ADODB objects?

That way I can close them making sure I'm not leaving any open.



09-30-2005, 05:50 PM
something like (dont hold me to this)

for each strItem in ServerVariables.ADODB

ofc you could just make sure you manually close each record set after you've finished using it

and then just at the bottom of the page close the connection and object.
since in reality you only ever need one connection object and just multiple record set's

if i can find the correct variable i'll post it in abit

09-30-2005, 07:56 PM
Thanks hinch

I'm normally pretty religious about closing recordsets, connections, etc... but wanted to see if there was a fallback that would do a final check and close anything that was open.

Will give that a go and refer to my ServerVariables notes.