无法打开库'/usr/local/nz/lib/libnzsqlodbc3.so'：找不到文件 (0) (SQLDriverConnect)")

Question

我正在尝试使用pyodbc访问IBM Netezza数据库。我正在使用unixODBC2.3.7

odbcinst.ini

[NetezzaSQL]
Driver           = /usr/local/nz/lib/libnzsqlodbc3.so
Setup            = /usr/local/nz/lib/libnzsqlodbc3.so
APILevel         = 1
ConnectFunctions = YYN
Description      = IBM Netezza ODBC driver
DriverODBCVer    = 03.51
DebugLogging     = false
LogPath          = /tmp
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch         = 256
Socket           = 16384

我收到以下错误：pyodbc错误：('01000'，"[01000][unixODBC][Driver Manager]无法打开lib'/usr/local/nz/lib/libnzsqlodbc3.so'：找不到文件(0((SQLDriverConnect("(

我试着调试它，发现了一个丢失的共享库链接：libcom_err.so.2=>未找到

ldd/usr/local/nz/lib/libnzsqlodbc3.so

linux-gate.so.1 (0xf7f9d000)
libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xf7e1b000)
libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xf7df8000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf7df2000)
libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xf7dd4000)
libssl.so.10 => /usr/local/nz/lib/libssl.so.10 (0xf7d71000)
libcrypto.so.10 => /usr/local/nz/lib/libcrypto.so.10 (0xf7bbe000)
libkrb5.so.3 => /usr/local/nz/lib/libkrb5.so.3 (0xf7b18000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf792b000)
/lib/ld-linux.so.2 (0xf7f9e000)
libgssapi_krb5.so.2 => /usr/local/nz/lib/libgssapi_krb5.so.2 (0xf78f0000)
libcom_err.so.2 => not found
libk5crypto.so.3 => /usr/local/nz/lib/libk5crypto.so.3 (0xf78bf000)
libresolv.so.2 => /lib/i386-linux-gnu/libresolv.so.2 (0xf78a6000)
libcom_err.so.3 => /usr/local/nz/lib/../lib/libcom_err.so.3 (0xf78a3000)
libkrb5support.so.0 => /usr/local/nz/lib/../lib/libkrb5support.so.0 (0xf789a000)

Answer 1

尝试按照下面链接中的说明解决问题
在RHEL 6.5虚拟机客户端上安装Puredata Linux客户端

问题

用于Linux的Puredate INSTALL Linux客户端(运行RHEL 6.x 的虚拟机

症状

在64位Linux RHEL VM上安装32位客户端导致

/nzds:加载共享库时出错：找不到libcom_err.so.2"。
libcom_err.so.3=>/usr/local/nz/bin/./../lib/../lib/libcom_err.so.3(0x00d7e000(

环境

RHEL 6.x

诊断问题

百胜提供libcom_err.so.2

解决问题

百胜安装e2fsprogs-libs-