Solved: Problem setting up ODBC for Firebird 2.5 - Qlik Community

tomovangel · ‎2018-01-16

Hello guys, I am trying all day to connect to firebird 2.5

I have downloaded the driver from

After I have installed the driver go into ODBC and try to connect to it, but whenever I click "Test connection" the ODBC crashes and restarts.

any help will be highly appreciated.

Any workarounds you may know feel free to share them

Sincerely Yours,

Angel Tomov

tomovangel · ‎2018-01-17

So After i contacted the Firebird bird support i got the following response:

"To access a firebird database, you need to have a firebird server running....

If there isn't one, then you should download and install a copy of the firebird server"

So the problem was that in my server i didn't have firebird server running, thats why it always gave out errors.

I reinstalled the drivers,

I installed the Firebird server, after that the Firebird ODBC(only the installation procedure,without the file with .dll's) .

After that i connected to the datasource without problem.

Thanks for your time !

agigliotti · ‎2018-01-16

did you already try to connect in Qlik Sense via that ODBC ?

tomovangel · ‎2018-01-16

yes, I have tried, and its giving me the same error: I attach 2 .jpg from ODBC setup and from qlik sense

agigliotti · ‎2018-01-16

let's try using the ODBC 32 bit version.

Ricardo_Gerhard · ‎2018-01-16

Dear Angel,

Have you tried to run whith local admin permissions?

Do you have another user and folder to store this file then trying to access?

I guess that something about permissions could be a problem.

Ricardo Gerhard
OEM Solution Architect
LATAM

tomovangel · ‎2018-01-16

I have tried, I installed the driver and the same error.
I will do it again now and apply screenshot..

tomovangel · ‎2018-01-16

Yes I am using the Administrator account.

I will now try to install it with the user I created for qlik sense who has full rights over everything, and will get back to you..

tomovangel · ‎2018-01-16

hmm, my client's working time ended and my session as well , but tomorrow i will try.
I will check permissions and try with another account..

Have a nice day/night

,Angel

Ricardo_Gerhard · ‎2018-01-16

Don´t worry.

You can also try to create a ODBC32 bits connection like mentionned from Andre.

Regards.

Ricardo Gerhard
OEM Solution Architect
LATAM

tomovangel · ‎2018-01-17

Whenever I try to make 32 bits connection, and click Test Connection, the odbc administrator crashes

attaching screen.