What is the proper way to close a connection? I am using the IBOAdmin
components to do a restore, but I can't seem to close the database. No
matter what I do I get an error. I have tried all of the following.

ForceDisconnect;
CloseTransactions;
Disconnect;
Close;

I get Error : lock time-out on wait transaction. object <database
path> is in use could not drop database <database path> (database
might be in use)

I have no pending statements at the time of this close down attempt -
can anyone give me a snippet of delphi code for properly shutting down
the current apps connection to the DB? and if there is a way to close
down all connections to the db perhaps with a warning first, I could
really use that info.

Thanks,

Jason S. Gagnon