Hello Paul,

> I have defined in fb aliases.conf database like:
> myDb=D:\Database\MyDb.FDB
>
> My connection is used like server:database!
>
> How can I get path for my alias?

With:

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

But you won't get the full path for an alias connection if you have set
the configuration parameter DatabaseAccess in firebird.conf to None.



--
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