ODBC driver for Firebird cannot load client library

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Jasperdg
Posts: 1
Joined: Mon 23 Sep 2019 08:05

ODBC driver for Firebird cannot load client library

Post by Jasperdg » Mon 23 Sep 2019 08:22

We have installed your great ODBC driver for Firebird on our Windows 10 Pro 64bit desktop, and the trial works.
Today we have tried the same on a Windows 10 Pro 64bits laptop. But when we test the connection (64bit System-DSN), we get this error: [Devart][ODBC][Firebird]Cannot load client library.
We have used DevartODBCFirebird.exe version 3.0.1.0 downloaded from devart.com/odbc/firebird/download.html, and started the installer with Administrator rights.
We even tried re-installing the driver, but the error message remains the same.
Pointed the client library to c:\Program Files (x86)\Devart\ODBC\Firebird\Win64\DevartODBCFirebird.dll, then the error message changes to [Devart][ODBC][Firebird]GDS function is not linked.

Any suggestions?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: ODBC driver for Firebird cannot load client library

Post by ViktorV » Mon 23 Sep 2019 12:03

Yes, the "Сannot load client library..." error occurs when you configure the 32-bit driver version and specify a 64-bit client library in the Client Library option of the Devart ODBC Driver for Firebird settings dialog or vise versa.
If the client library is specified in the Client Library setting of the Devart ODBC Driver for Firebird without the full path to it or it is empty, the driver will search for it in the current folder, the folders specified in the PATH environmental variable, WINDOWS\system32. To solve the problem, try to specify the full path to the library in the Client Library setting of the connection editor of Devart ODBC Driver for Firebird.
Both 32 bit and 64 bit Firebird client libraries are named the same - fbclient.dll and each of them is distributed with Firebird distributive of the corresponding bitness.
Please make sure that for ODBC Driver for Firebird configuration when using a 32-bit version of Firebird you are using a 32-bit version of "Data Source (ODBC)" (which is located %windir%\syswow64\odbcad32.exe). Correspondingly, for ODBC Driver for Firebird configuration when using a 64-bit version of Firebird - a 64-bit version of "Data Source (ODBC)" is used and located %windir%\system32\odbcad32.exe.

Post Reply