Firebird Database

[Anonymous]

Good Day,

I managed to connect qlikview to firebird database using odbc and loaded some tables. However, on the transactions table, the script errors when the lines fetch is over 8 million and the below error appears.

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlStateL HY000, ErrorCode: 4294966394, ErrorMsg: [ODBC Firebird Driver][Firebird]database file appears corrupt ()

bad checksum

chechsum error on database page 542519

I have no idea what this means. Has anyone ever experienced this and managed to resolve the issue? Any guidance will be highly appreciated.

[Gysbert_Wassenaar]

database file appears corrupt ()

Check that you're connecting to the right database and if you're sure about that check the database files. The error you receive comes from the firebird odbc driver you installed, not from Qlikview itself.

[Anonymous]

Hi Gysbert

Thanks for the advice. Will check the drivers.

[Anonymous]

Further to my original post. Tried to run the script again earlier today. It was successful until the transaction table then Qlikview stopped responding.  I ended the process from the task manager and rebooted, but, I can no longer connect to the Firebird database.

I had the drivers re-installed, did a test connection which was successful, but I cannot see the database tables when trying to redo the script?

Please help as this is very frustrating.

Thanks

[ecolomer]

I have conexion to Firebird database

Wich ODBC are used?

And the S.O. is 32 or 64 bits, because the ODBC for Firebird normaly is 32 bits

[ecolomer]

See this (I'm soryy is in Spanish language)

[Emmanuelle__Bustos]

Hi Enrique,

What Driver you use for this conecction? Is it Free or pay fee?

[ecolomer]

It's free.

See file attached.

[ecolomer]

There are also one 32 bits version

[Emmanuelle__Bustos]

Thank you very much!!!