Netezza ODBC driver for Linux - Forum - DataDirect Connect - Progress Community

Netezza ODBC driver for Linux

 Forum

Netezza ODBC driver for Linux

This question has suggested answer(s)

Hi all,

I'm trying to configure Netezza ODBC on Linux Redhat, I have downloaded the corresponding ODBC driver and installed ODBC driver manager as well.
I have followed all the instructions in the readme file of the Netezza ODBC.
The odbc.ini and odbcinst.ini files are located in /opt/odbc64v51 and The Netezza ODBC driver is located in /usr/local/nz/lib. When I ran the example program it give me the following error:

SQLSTATE = IM003
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Specified driver could not be loaded


Can you please help? Thanks 

All Replies
  • Check your odbc.ini for the Driver= value for the data source you are using and verify that it exists and can be loaded with ldd or ddtestlib.  That error is usually from a bad Driver= path or a dependent library not on the LD_LIBRARY_PATH.

  • I made sure that Driver= value is correct (= /usr/local/nz/lib/libnzodbc.so)

    But when I ran ldd, I got the following: Is there something wrong?

    # ldd /usr/local/nz/lib/libnzodbc.so

    linux-gate.so.1 =>  (0x006be000)

    libm.so.6 => /lib/libm.so.6 (0x006ca000)

    libpthread.so.0 => /lib/libpthread.so.0 (0x005dd000)

    libdl.so.2 => /lib/libdl.so.2 (0x00d07000)

    libssl.so.6 => not found

    libcrypto.so.6 => not found

    libc.so.6 => /lib/libc.so.6 (0x001db000)

    /lib/ld-linux.so.2 (0x004e0000)

  • It looks like the driver depends on ssl and crypto. If you can download them or copy them from a simiar platform, and put them under /lib or some path that is included in your LD_LIBRARY_PATH, I think you will pass that error, go further or get connected.

  • I have configured it using the 64 bit driver and it worked fine now. as the ssl and crypto libraries are used for 64 bit