On 2010/11/29 22:50, Helen Borrie wrote:

>
> At 04:33 AM 30/11/2010, Pierre Polome wrote:
> >Hello,I'm new to firebird, and for one of my customer I need to migrate
> >a firebird database to a MySQL one.
> >My customer sent me some .fdb file, but I can't read them. I can read
> >the sample one added by the installation package (2.5).I'm using
> >razorsql to do this on a Mas OS X.6.5
> >I'm not sure, but maybe the file is for a 1.5 or something like that.
>
> It is a v.1.5 database. Firebird servers > v.1.5 should be able to
> open it.
>
> >Could somebody put me on the wayYou can find the file at:
> >http://warehouse.twenty8prod.com/rtff.fdb
>
> I had no problem opening your database under Firebird 2.0.6 on
> Windows, using isql and a couple of other tools.
>
> In aliases.conf:
>
> wh28 = h:\databases\wh28\rtff.fdb
>
> From isql:
>
> c:\Programs\Firebird\Firebird_2_0\bin>isql dev1:wh28 -user sysdba
> -password zzzzzzzz
> Database: dev1:wh28, User: sysdba
> SQL> show database;
> Database: dev1:wh20
> Owner: SYSDBA
> PAGE_SIZE 1024
> Number of DB pages allocated = 3772
> Sweep interval = 20000
> Forced Writes are ON
> Transaction - oldest = 289152
> Transaction - oldest active = 289501
> Transaction - oldest snapshot = 289501
> Transaction - Next = 289504
> ODS = 10.1
> Default Character set: UNICODE_FSS
> SQL> show tables;
> ASKPHABET SEQUENCEUR
> TCOLLABORATEUR TCOLLABORATEURPOSITION
> TCOMPETENCE TDEFINITIONFONCTION
> TDETAILEVALUATION TDETAILMESURE
> TDETAILPLANFORMATION TDIPLOME
> TDIPLOMEAQUIS TDIPLOMEREQUIS
> TETAPE TEVALUATION
> TEXPERIENCE TEXPERIENCEAQUISE
> TEXPERIENCEREQUISE TFAMILLE
> TFONCTION TFONCTIONPARETAPE
> TFORMATION TFORMATIONAQUISE
> TGROUPETACHES TLANGUE
> TLIENPARVUE TLIENSTRUCTURE
> TMESURABLE TMESURABLEPARREPONSE
> TMISSION TMISSIONPARPOSTE
> TMISSIONPARSTRUCTURE TMODELEEVALUATION
> TNIVEAUDIPLOME TOCCUPATION
> TPLANFORMATION TPONDERATIONPARSAVOIR
> TPONDERATIONPARTACHE TPOSITION
> TPOSTE TPOSTEPARETAPE
> TPROCESSUS TREPONSEEVALUATION
> TRESPONSABILITE TRESPONSABILITEPARPOSTE
> TRESPONSABILITEPARSTRUCTURE TSAVOIR
> TSAVOIRPARFORMATION TSAVOIRPARPOSTE
> TSESSIONEVALUATION TSEUIL
> TSPECIALITEDIPLOME TSTRUCTURE
> TSTRUCTUREPARETAPE TSTRUCTUREPARVUE
> TTACHE TTACHEPARPROCESSUS
> TTACHESPARFONCTION TTHEMECOMPETENCE
> TTRADUCTIONDYNAMIQUE TTYPEDIPLOME
> TTYPEEVALUATION TTYPEFORMATION
> TTYPELIEN TTYPESTRUCTURE
> TVALEURPERMISE TVALEURSTRADUITES
> TVERSION TVUE
>
> SQL>
>
> I don't have time to do the 28Mb download of Razorsql to test that,
> sorry.
>
> Is it possible you are trying to open the database without having a
> Firebird server actually running?
>
> ./heLen
>
>

Try using Firebird 32 bit if you have 64 bit and visa versa if you have
32 bit. My experience is that the fdb's is not compatible between the 2
versions. (I presume the same applies for Linux, Windows etc.) Rather
get a backup in the transportable format and restore it on your system.

Cornie
www.infostar.co.za


[Non-text portions of this message have been removed]