Problem setting up ODBC for Firebird 2.5

[tomovangel]

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.

any help will be highly appreciated.

Any workarounds you may know feel free to share them

Sincerely Yours,

Angel Tomov

[agigliotti]

are you using ODBC Data Sources (32-bit) above ?

[tomovangel]

yes

[Ricardo_Gerhard]

Dear Angel,

Have you tried to extract these dll´s inside the windows folder mentioned on error message?

https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/OdbcFb_DLL_2.0.5....

https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/OdbcFb_DLL_2.0.5....

Just tried to download and extract this dll on windows folders.

[tomovangel]

Yes, after I have installed the driver, I extracted the said DLL's into Windows/System32 and replaced all 4 files.

PS: Currently I have installed only Firebird x64, because my windows is 64 bits. // Should I install both, x32 and x64( although I think that's not possible)

[Ricardo_Gerhard]

Ok, correct.

So, I guess that you want to create a ticket/support case on Firebird Community (https://www.firebirdsql.org/en/support/) because it´s not a Qlik problem.

Sorry.

[tomovangel]

Thanks for your time Ricardo Gerhard,

I have contacted the support in Firebird ODBC driver's mailing list.

Thank you again for your time and help

Have a fruitful year !

[Ricardo_Gerhard]

Don´t worry. You´re welcome.

Please, reply to us with the solution when fixed this issue because I´m curious

[tomovangel · Accepted solution]

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 !

[Ricardo_Gerhard]

Living and Learning!

Now, we know that the firebird SQL doesn´t allow direct access to database file.

Thank your for share.