Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
leeadams82
New Contributor

Firebird Database

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.

17 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Firebird Database

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.


talk is cheap, supply exceeds demand
Highlighted
leeadams82
New Contributor

Re: Firebird Database

Hi Gysbert

Thanks for the advice. Will check the drivers.

Highlighted
leeadams82
New Contributor

Re: Firebird Database

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

Highlighted
ecolomer
Honored Contributor II

Re: Firebird Database

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

Highlighted
ecolomer
Honored Contributor II

Re: Firebird Database

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

p07.png

Highlighted

Re: Firebird Database

Hi Enrique,

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

Highlighted
ecolomer
Honored Contributor II

Re: Firebird Database

It's free.

See file attached.

Highlighted
ecolomer
Honored Contributor II

Re: Firebird Database

There are also one 32 bits version

Highlighted

Re: Firebird Database

Thank you very much!!!