Need help fast!!!

[capone]

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.

[capone]

I was a moron and forgot to close the Recordset. Will that close down the connection completely?

[Clunietp]

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

[Clunietp]

Oh yeah, ASP uses Connection Pooling, so your connection won't expire until 60 seconds later (or maybe it's 30)....

[capone]

Thanks, that fixed it.