我已经在ubuntu16.04上安装了postgresql9.4,并安装了postgresqltodbc和unixodbc驱动程序。当我用isql测试ODBC连接时,它工作得很好。此外,我能够从本地和远程位置使用pgadmin III连接到数据库。
但是,当我试图安装一个使用ODBC创建连接的软件时,我得到了以下错误
连接失败!
错误代码=-1
但图书馆实际上就在这个地方。请告知。我已经附上了odbc.ini文件以及odbcinst.ini文件供你参考。
file: /etc/odbc.ini
[PostgreSQL_DCTM]
Description=PostgreSQL DCTM
Driver=PostgreSQL_ANSI
Trace=No
TraceFile=/tmp/psqlodbc.log
Database=dctmdev
Servername=localhost
UserName=dctmdbadmin
Password=*******
Port=5432
Protocol=7.4-2
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
UpdateableCursors=Yes
ConnSettings=
DEBUG=Yes
file: /etc/odbcinst.ini
[PostgreSQL_ANSI]
Description=PostgreSQL ODBC driver (ANSI version)
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=2
[PostgreSQL_Unicode]
Description=PostgreSQL ODBC driver (Unicode version)
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=2
Update - 08/01/2018
/documentum/product/7.3/install/Server_Configuration_Program.bin: POSIX shell script executable (binary data)
/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so: ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, BuildID[sha1]=e76dd2bbea2b741a14671866f35468af7c62acbb, stripped
The version of the psqlodbca.so is shown as 'stripped'. However, in the documentation of the software that I am trying to install it mentions to use 'not stripped' version. Could you please help me understand how could I procure the 'not stripped' version of the client library?