Subject | Re: [firebird-support] getting the ip and filename from a database |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-10-05T11:33:29Z |
Hello Hans,
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/
> I´m new to this list and i'm glad to be here :)With RDB$GET_CONTEXT. E.g.:
>
> 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?
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/