--- In ib-support@yahoogroups.com, "Ivan Prenosil" <prenosil@m...>
wrote:

> From: "fabiano_bonin" <fabiano@l...>
> > Is there some way to know if a database is off-line, via SQL
> > statement? (no problem if i have to connect to security.fdb)
>
> Via SQL - no. (To be able to execute SQL statement you have to be

connected

> to the database, so obviously it can't be off-line :-)
>
> You can try to rename the database file - if is succeeds, it means

that

> the file is not locked/used by the server.
>
>
> Or perhaps you want to know whether you are the only user

connected ?

> Then you can call isc_database_info() API function to get list of

connected users.

>
>
> Or may be you are interested in the information whether the

database is shut-down ?

Yes, it's what i wanted. Thanks.

> The shut-down flag is stored on db header page, and it's state can

be find out

> via gstat -h tool, or via Services API functions.
> (However, even if the database is shut down, its owner and sysdba

can still be connected.)

>
>
> Ivan Prenosil
> [ I am looking for a job: InterBase - Firebird - Delphi - C -

fulltext db - and more ... ]

> Ivan.Prenosil@s...
> http://www.volny.cz/iprenosil/interbase