Subject Re: [firebird-support] getting the ip and filename from a database
Author Thomas Steinmaurer
Hello Hans,

> I´m new to this list and i'm glad to be here :)
>
> I hope my first question fits into this mailinglist.
>
> How can i get the IP, the filename and the path of a Firebird DB?
> Are those values stored in an intern table of Firebird?

With RDB$GET_CONTEXT. E.g.:

select
rdb$get_context('SYSTEM', 'CLIENT_ADDRESS')
, rdb$get_context('SYSTEM', 'DB_NAME')
from
rdb$database



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/