21.06.2016 03:52, Seyeong Jeong wrote:
>
> I have a firebird database with ODS version 10.1. While I can open this
> with server version WI-V2.1.7.18553 Firebird 2.1 on Windows without any
> errors, the same operation fails on Ubuntu.
I suspect your Windows version (or Firebird version running there) is
32-bit, correct?
> These are the versions on Firebird I tried on Ubuntu:
>
> - Firebird/linux AMD64 (access method), version "LI-V2.5.1.26351
> Firebird 2.5"
> - Firebird/linux AMD64 (access method), version "LI-V2.1.7.18553
> Firebird 2.1"
> - Firebird/linux AMD64 (access method), version "LI-V2.1.4.18393
> Firebird 2.1"
> - Firebird TCP/IP server version LI-V1.5.4.4910 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
This error is raised when the database is not understandable to the engine.
Prior to ODS 11, databases were not binary compatible between 32-bit and
64-bit architectures. You cannot just copy a ODS 10.1 database to a host
with different bitness and use it there. Backup/restore is required instead.
Dmitry
Posted by: Dmitry Yemanov <dimitr@users.sourceforge.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment