We are currently using Safescan TA + Software on a Windows computer, but we are trying to move the database (TADATA.FDB) to a small Linux server, so we bought Raspberry Pi2 and installed Raspbian and Firebird 2.5 Super on This. Then we copied the TADATA.FDB file from the Windows 7 machine to the Pi and set the SYSDBA password to "masterkey".
If I try to connect to the specified database on a Windows machine using
CONNECT "C:\Program Files (x86)\SafeScan\TA4\TADATA.FDB" user 'SYSDBA' password 'masterkey'
everything works fine and i can access the database. However, if I use the equivalent command
CONNECT "/var/lib/firebird/2.5/data/tadata.fdb" user 'SYSDBA' password 'masterkey'
on Raspberry, I get the following answer:
Statement failed, SQLSTATE = HY000
file /var/lib/firebird/2.5/data/tadata.fdb is not a valid database
If I try to connect using the Safescan software using the syntax provided by it (SERVERIP: /var/lib/firebird/2.5/data/tadata.fdb), the program gives me this messeage error:
The settings of the provided database couldn't be opened
(Error: file /var/lib/firebird/2.5/data/tadata.fdb is not a valid database
Connection authorization failure.
GDS Code: 335544323 Error Code: 3 )
The credentials I provided seem correct, as I can use them to create and connect any other database, such as a sample. To make sure the password is set correctly, I also used
GSEC> modify SYSDBA -pw masterkey
with root privileges.
What should I do to connect to this raspberry database?
EDIT: The "show version" command gives the following information: On Raspbian (with test.fdb connected):
ISQL Version: LI-V2.5.2.26540 Firebird 2.5
Server version:
Firebird/linux ARM (access method), version "LI-V2.5.2.26540 Firebird 2.5"
Firebird/linux ARM (remote server), version "LI-V2.5.2.26540 Firebird 2.5/tcp (raspberrypi)/P12"
Firebird/linux ARM (remote interface), version "LI-V2.5.2.26540 Firebird 2.5/tcp (raspberrypi)/P12"
on disk structure version 11.2
And in the Windows version (with TADATA.FDB connected):
ISQL Version: WI-V2.5.4.26856 Firebird 2.5
Server Version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.4.26856 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.4.26856 Firebird 2.5/XNet (WIN7PC)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.4.26856 Firebird 2.5/XNet (WIN7PC)/P12"
on disk sturcture version 10.1