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 = IM003NATIVE ERROR = 0MSG = [DataDirect][ODBC lib] Specified driver could not be loadedCan 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)
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