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

Netezza ODBC driver for Linux


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:

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/

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

    # ldd /usr/local/nz/lib/ =>  (0x006be000) => /lib/ (0x006ca000) => /lib/ (0x005dd000) => /lib/ (0x00d07000) => not found => not found => /lib/ (0x001db000)

    /lib/ (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