Subject Re: Firebird Server -> Forcing noone else connected
Author Svein Erling Tysvær
gfix has a -sh[ut] switch that can be used for shutting down one
particular database. It's described on page 840 of The Firebird Book.
A shutdown database can only be accessed by SYSDBA or the owner.

IB_SQL (freeware, www.ibobjects.com) is capable of showing who is
connected to the database. I guess other tools can do the same thing.

HTH,
Set

--- In firebird-support@yahoogroups.com, "Adam" wrote:
> Hello Group,
>
> * I have a Firebird SuperServer on Win2003 Server with multiple fdb
> databases.
> * I would like to run some sql scripts against one of them.
> * Obviously I don't want anyone (else) connected to the database
when
> I run these scripts or I might get object in use style errors.
> * I do not want to shutdown the Firebird Service because there are
> about 30 other databases active on the same server and I don't want
to
> cause them troubles.
> * I connect to [computername]:[alias]
>
> * Is there a way I can detect whether I have the only connection to
> THIS database before running my upgrade scripts?
>
> Any help is appreciated
>
> Adam