-
I've got an ASP page that creates an ADO connection to an ODBC database, but every time I load, and then close a the page it doesn't release the connection, so I've got a bunch of open connections (temp files), and I can't delete the database. I've put (the connection's name is "conn")
conn.close
at the end of the page, but that doesn't seem to work. I need help, I have to delete that database in order to continue working.
Thanks in advance for the help.
-
I was a moron and forgot to close the Recordset. Will that close down the connection completely?
-
be sure you set your recordset and connection object to nothing
once the object goes out of scope, the connection should be released and the objects destroyed
-
Oh yeah, ASP uses Connection Pooling, so your connection won't expire until 60 seconds later (or maybe it's 30)....
-
