Libraries missing from ODBC Driver for InterBase

[murtonen]

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]

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 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]

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]

We have answered you via e-mail.