Connections not closing

From: Paul H. (anonymous_at_discussions.microsoft.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 13:36:10 -0800

I'm using ADO 2.8 in a VB application and I connect to multiple databases in a single instance of MSSQL. In my particular application I occasionally want to close a connection so that I might re-attach an updated database or restore the database from a backup (.bu) file. It appears that the connection object has some form of persistence, because even though I close the database I cannot perform some of the operations. Typically, the operation will throw an error that indicates that the connection is still active. I have a done a workaround, which essentially 'marks' the database for this action. If my application is stopped and restarted, then before any databases are opened, it performs the appropriate action on a 'marked' database. This seems like a very circuitous workaround to get where I want to go.

Has anyone else experienced the persistent connection?

Thanks in advance for your help.