From: "fabiano_bonin" <fabiano@...>

> 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 ?
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@...
http://www.volny.cz/iprenosil/interbase