Archive for February, 2003

Make sure all your connections are closed

Posted in ASP Classic on February 5th, 2003 by kai – Be the first to comment

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