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