Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tomovangel
Contributor III

Problem setting up ODBC for Firebird 2.5

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

I have downloaded the driver from

Firebird: ODBC Driver

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.

Screenshot_2.png

any help will be highly appreciated.

Any workarounds you may know feel free to share them

Sincerely Yours,


Angel Tomov

1 Solution

Accepted Solutions
tomovangel
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

agigliotti

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 !

18 Replies
agigliotti
Honored Contributor II

Re: Problem setting up ODBC for Firebird 2.5

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

tomovangel
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

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

Screenshot_3.png

Screenshot_4.png

agigliotti
Honored Contributor II

Re: Problem setting up ODBC for Firebird 2.5

let's try using the ODBC 32 bit version.

Employee
Employee

Re: Problem setting up ODBC for Firebird 2.5

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
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

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

tomovangel
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

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
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

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

Employee
Employee

Re: Problem setting up ODBC for Firebird 2.5

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
Contributor III

Re: Problem setting up ODBC for Firebird 2.5

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

attaching screen.

Screenshot_5.png

Community Browser