topic Re: Firebird Database in QlikView

Firebird Database

Anonymous — Fri, 31 Oct 2014 06:28:53 GMT

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.

Re: Firebird Database

Gysbert_Wassenaar — Fri, 31 Oct 2014 10:15:25 GMT

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.

Re: Firebird Database

Anonymous — Fri, 31 Oct 2014 10:38:17 GMT

Hi Gysbert

Thanks for the advice. Will check the drivers.

Re: Firebird Database

Anonymous — Sat, 01 Nov 2014 00:43:21 GMT

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

Re: Firebird Database

ecolomer — Sat, 01 Nov 2014 19:47:37 GMT

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

Re: Firebird Database

ecolomer — Sat, 01 Nov 2014 19:51:07 GMT

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

Re: Firebird Database

Emmanuelle__Bustos — Tue, 23 May 2017 18:33:39 GMT

Hi Enrique,

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

Re: Firebird Database

ecolomer — Tue, 23 May 2017 20:11:37 GMT

It's free.

See file attached.

Re: Firebird Database

ecolomer — Tue, 23 May 2017 20:12:25 GMT

There are also one 32 bits version

Re: Firebird Database

Emmanuelle__Bustos — Tue, 23 May 2017 21:09:11 GMT

Thank you very much!!!

Re: Firebird Database

Emmanuelle__Bustos — Tue, 23 May 2017 22:10:54 GMT

Have you ever tried this with Qlik Sense? For Qlikview is working but not with Sense

Re: Firebird Database

Emmanuelle__Bustos — Wed, 31 May 2017 16:40:23 GMT

Hi, once upgrade my Sense to 3.2 the extraction was succesfully.

Regards!

Re: Firebird Database

tomovangel — Tue, 16 Jan 2018 13:59:59 GMT

Hello, I have downloaded the firebird driver successfully, but I don't know what to insert in the
Client field

Thanks for your time,

Sincerely, Yours,

Angel Tomov

Re: Firebird Database

tomovangel — Tue, 16 Jan 2018 14:00:40 GMT

Hello, Enrique,

What must be written in the Client field of the ODBC firebird Driver?

Thanks for your time !

Sincerely, Yours

Angel Tomov

Re: Firebird Database

ecolomer — Tue, 16 Jan 2018 18:01:44 GMT

Hi,

You need define the ODBC

Re: Firebird Database

tomovangel — Wed, 17 Jan 2018 07:50:03 GMT

Yes, I have defined ODBC before, but never on a Firebird database.

I got error, I am attaching screenshot .
PS: My client's using Firebird 2.5, and I have downloaded the drivers from official Firebird website

Any thoughts to workarounds?

Re: Firebird Database

ecolomer — Wed, 17 Jan 2018 10:07:46 GMT

I think the problem is in 32 vs 64 bits

Re: Firebird Database

tomovangel — Wed, 17 Jan 2018 10:11:32 GMT

Well, My Windows Server 2016 is x64 bits.

I have tried with the ODBC Firebird drivers for x64 as well as for x32.

I have made a discussion as well

Problem setting up ODBC for Firebird 2.5

I have written email to the suport of ODBC firebird drivers..