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

> >>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.
> >
> Thank you for your answer.
> However, I ment programatically connect to Firebird in such a way. If
> someone can direct me to some code, source of documentation or write an
> example it would be very appreciated.

You can use the SuperServer Services API to shutdown the database
as well. That's the only way to get a single connection, unless you have
a mechanism in your app to boot all other connections and disallow them
before you "open up" the database again.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions