Subject | Connection by alias fails |
---|---|
Author | jarni_ua |
Post date | 2011-01-05T18:33:46Z |
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.
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.