Re: [firebird-support] Re: Not a valid database

 

Hi again,

Thanks for your responses. As Dmitry has guessed, I've been running 32 bit Firebird on Windows. And using the 32 bit version of the application on linux box, I was able to access the database.

Again thanks for your replies.

On Tue, Jun 21, 2016 at 5:08 PM, Dmitry Yemanov dimitr@users.sourceforge.net [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

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

--

/Da Capo/

__._,_.___

---

Posted by: Seyeong Jeong <wmbdmw@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___