Subject Connection by alias fails
Author jarni_ua
Hi.

I'm trying to connect to database file testdb.fdb stored on my remote linux machine at /var/lib/firebird/2.0/data/testdb.fdb. I've defined alias for this file in aliases.conf as

online_test = /var/lib/firebird/2.0/data/testdb.fdb

Now I'm trying to connect to this database from my program using this alias (IBPP library is used) but I receive the following error:
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements

Engine Code : 335544344
Engine Message :
I/O error during "open" operation for file "online_test"
Error while trying to open file
No such file or directory

Note that if I use full path to the database instead of alias (connection string is remote_host:/var/lib/firebird/2.0/data/testdb.fdb instead of remote_host:online_test) the connection is successfull and all works fine.

First I thought that the access right may be involved because I've installed FB SS as root. So I've changed /etc/firebird/ rights recursively to firebird:firebird. Still the same.

Any ideas?
Thanks in advance.