A6-CMO Philippe Makowski wrote:

> In fact I want a procedure to be certain that I am the only one connected to
> the database
>

There is no reliable and consistent way to achieve this at the moment.
The 'hack' is to try and rename the database file. If you can do that
then no-one is connected and you can then connect to the newly named
database and carry out whatever maintenance work is required.

The problem is that renaming a database will require some kind of access
to the file system that the database is stored on. This may not always
be possible.

I guess the proper solution to this is to ensure that when a database is
shutdown that only a single connection from either the owner or sysdba
is allowed. However, at the moment, multiple connections are allowed.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase