Libraries missing from ODBC Driver for InterBase

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
murtonen
Posts: 3
Joined: Wed 28 Aug 2019 10:38

Libraries missing from ODBC Driver for InterBase

Post by murtonen » Wed 28 Aug 2019 10:59

Hi,

We have ran into few issues with the ODBC Driver package.

The installation was supposed to be pretty straightforward:
sudo rpm -ivh devart-odbc-interbase.x86_64.rpm
But when we ran the command
isql -v DEVART_INTERBASE
as given in the documentation (with odbc.ini) filled.

We got the following error:
[08001][unixODBC][Devart][ODBC][InterBase]Cannot load library: libcrypt.so
We created a symlink and fixed the library path and got that one "fixed" but then we got another error.
[08001][unixODBC][Devart][ODBC][InterBase]Cannot load client library: libfbclient.so
As I understand, this is a firebird library? Why is it needed? Have we done something wrong, or why are we missing so many libraries?

Any help would be truly appreciated.

murtonen
Posts: 3
Joined: Wed 28 Aug 2019 10:38

Re: Libraries missing from ODBC Driver for InterBase

Post by murtonen » Wed 28 Aug 2019 11:59

Installed firebird libraries just in case, but now we run into issues with
[08001][unixODBC][Devart][ODBC][InterBase]Client library is not supported
And we cannot figure out what kind of odbc.ini settings we should have.

Currently they are:
[test]
User ID=user
Password=password
Server=1.1.1.1
Port=3050
Database=Dlp00001.gbb
Client Library=/usr/local/devart/odbcinterbase/

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

Re: Libraries missing from ODBC Driver for InterBase

Post by ViktorV » Fri 30 Aug 2019 09:34

Devart ODBC Driver for InterBase communicates with a server via a client library using a specialized API. This error occured because our driver couldn’t find and load the client library. Currently the driver is trying to load the libfblient.so client library instead of libgds.so. We will fix this behavior in the next build of Devart ODBC Driver for InterBase.
To solve your issue, you should to specify the full path to the correct InterBase client library in the Client Library setting in the odbc.ini file.
For example:
[DEVART_INTERBASE]
ClientLibrary=/Library/ODBC/devart/interbase/libgds.so
Note: First you need to download the InterBase client library for Linux and place it in /Library/ODBC/devart/interbase/.
To learn how to get the InterBase client library for Linux, please contact the InterBase support or relevant forums.

murtonen
Posts: 3
Joined: Wed 28 Aug 2019 10:38

Re: Libraries missing from ODBC Driver for InterBase

Post by murtonen » Tue 10 Sep 2019 13:31

Did an interbase client install from " InterBase_2017_EN.zip".

Linked the library created by the install to the odbc.ini, but we are back to getting the libfbclient.so error.
[~]$ cat odbc.ini
[test]
User ID=test_user
Password=
Server=192.168.100.23
Port=3050
Database=D:\DL\DLDB\Dlp0000\Dlp00001.gbb
ClientLibrary=/opt/interbase/lib/libgds.so
[~]$ ls /opt/interbase/lib/
interclient.jar libgds_pyxis.a libgds.so libgds.so.0 libib_util.so libibxml.so
[~]$ isql -v test
[08001][unixODBC][Devart][ODBC][InterBase]Cannot load client library: libfbclient.so
[ISQL]ERROR: Could not SQLConnect

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

Re: Libraries missing from ODBC Driver for InterBase

Post by ViktorV » Fri 13 Sep 2019 14:12

We have answered you via e-mail.

Post Reply