Subject Re: [firebird-support] Single connection ?
Author Martijn Tonies
Hi,

> I do not know if this has been asked before, but what interests me is
>
> How do I connect to a firebird database in a way to force to be the only
> connection to that database.
> I need this for making patches to my database and not see "Object is in
> use" when I issue an alter table or so.
>
> If there is such a possibility please tell me how or instruct me to some
> source of documentation.

Perform a database "shutdown" with your favourite tool, or "gfix", in
order to get a single connection.

This only works if your users are connecting with other user-names than
SYSDBA or the database owner.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com