Linux上普遍存在的ODBC错误[01000] [unixODBC] [驱动程序管理器]无法打开lib'/usr/local/psql/lib/odbcci.so':找不到文件 [英] Pervasive ODBC on Linux Error [01000][unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found

问题描述

我正在尝试在Centos 6上使用Pervasive v10客户端ODBC.据我所知，没有64位ODBC客户端，因此我必须使用32位.我终于把它安装好了，没有错误，但是尝试使用它可以得到以下结果:

I'm attempting to get Pervasive v10 client ODBC working on Centos 6. As I've learned, there is no 64 bit ODBC client so I have to use the 32 bit one. I've finally gotten it to install without error but attempting usage gives the following:

# isql -v mydsn
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found
[ISQL]ERROR: Could not SQLConnect

ldd显示以下内容:

ldd shows this:

# ldd /usr/local/psql/lib/odbcci.so
linux-gate.so.1 =>  (0x007d3000)
libpscore.so.3 => /usr/local/psql/lib/libpscore.so.3 (0x00c32000)
libpscl.so.3 => /usr/local/psql/lib/libpscl.so.3 (0x005f9000)
libuuid.so.1 => /lib/libuuid.so.1 (0x0076d000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
libdl.so.2 => /lib/libdl.so.2 (0x003e0000)
libstdc++.so.6 => /usr/local/psql/lib/libstdc++.so.6 (0x0012b000)
libm.so.6 => /lib/libm.so.6 (0x00876000)
libgcc_s.so.1 => /usr/local/psql/lib/libgcc_s.so.1 (0x00434000)
libc.so.6 => /lib/libc.so.6 (0x00954000)
/lib/ld-linux.so.2 (0x00f70000)

推荐答案

我在为Ubuntu客户端设置ODBC和Pervasive时遇到了类似的问题.

I just had a similar problem setting up ODBC and Pervasive for an Ubuntu client.

su psql后它起作用的原因是因为他们在psql用户帐户中安装了.bashrc.该问题的关键要素是export LD_LIBRARY_PATH=...，它告诉动态链接器在哪里可以找到该库.

The reason it works after you su psql is because they install a .bashrc in the psql user account. The critical ingredient there for this question is export LD_LIBRARY_PATH=... which tells the dynamic linker where to find the library.

关于SQL连接管理器的注释中的错误也是我遇到的一个错误: [08S01][unixODBC][Pervasive][ODBC Client Interface][Client LNA]The ODBC Client Interface cannot access the data source because SQL Connection Manager is not running at the specified port number. Contact your system administrator for assistance.

The error in the comments regarding the SQL Connection Manager is one I ran into as well: [08S01][unixODBC][Pervasive][ODBC Client Interface][Client LNA]The ODBC Client Interface cannot access the data source because SQL Connection Manager is not running at the specified port number. Contact your system administrator for assistance.

我认为Pervasive希望在自己的etc目录中拥有自己的odbc.ini副本.该dsnadd脚本可能会执行此操作.我没有在64位安装中使用dsnadd，但是我添加了一个从/etc/odbc.ini到/usr/local/psql/etc/odbc.ini的符号链接，并且可以正常工作.

I think Pervasive wants its own copy of the odbc.ini in its own etc directory. That dsnadd script probably does that. I didn't have dsnadd in the 64bit install, but I added a symlink from /etc/odbc.ini to /usr/local/psql/etc/odbc.ini and it worked.

这篇关于Linux上普遍存在的ODBC错误[01000] [unixODBC] [驱动程序管理器]无法打开lib'/usr/local/psql/lib/odbcci.so':找不到文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！