I had a strange problem after restoring a Firebird database. The production database (Firebird 2.1) runs on a 64-bit server, and we use the FreeAdHoc library with additional functions. I created a backup database with gbak, moved to a local computer (64-bit Ubuntu 13.10). Installed firebird 2.1.5 locally and downloaded the latest FreeAdHoc library.
Now when I try to execute some function from it via iSQL:
/opt/firebird/bin/isql db.fdb -user sysdba -password masterkey -i /opt/firebird/bin/command.sql
and the contents of the command.sql command
select f_addday(current_timestamp,10) from rdb$database;
It works correctly and performs this UDF function.
HOWEVER, when I try to execute the same command through a Flamerobin or PHP script, I get this error:
Engine Code : 335544343
Engine Message :
invalid request BLR at offset 59
function F_ADDDAY is not defined
module name or entrypoint could not be found
- ? , , isql , flamerobin/php , , , .
,