I have a firebird database with ODS version 10.1. While I can open this with server version WI-V184.108.40.20653 Firebird 2.1 on Windows without any errors, the same operation fails on Ubuntu.
These are the versions on Firebird I tried on Ubuntu:
- Firebird/linux AMD64 (access method), version "LI-V220.127.116.11351 Firebird 2.5"
- Firebird/linux AMD64 (access method), version "LI-V18.104.22.16853 Firebird 2.1"
- Firebird/linux AMD64 (access method), version "LI-V22.214.171.12493 Firebird 2.1"
- Firebird TCP/IP server version LI-V126.96.36.19910 Firebird 1.5
All versions of Firebird fails to open the database with isql-fb with the following message:
SQL> connect "/home/user/a.fdb" user '*******' password '**********';Statement failed, SQLSTATE = HY000
file /home/user/a.fdb is not a valid database
Note that the example file, employee.fdb is accessible.
Again, the same file is perfectly accessible on Windows with FlameRobin.
Any advice or guidance would be greatly appreciated.
Thanks in advance,