Make sure all your connections are closed
I have had the unfortunate privilege to walk into an ASP classic application cold only to discover the person who orginilly wrote the app either didn’t know how-to or didn’t like closing their DB connections. As you can imagine this caused a bit of a headache from the application and so I write this little function that will close your known connections safely.
if IsObject(RS) then if not (RS is nothing) then if RS.state = 1 then RS.close set RS = nothing end if end if if IsObject(conn) then if not (conn is nothing) then if conn.state = 1 then conn.close set conn = nothing end if end if