I can't figure it out how to connect to a Pervasive DB on a Windows Server machine from an Ubuntu Linux 64bit via ODBC.
I installed unixodbc
, then 32bit Pervasive Client 11sp2
from here and after moving the tar content to /usr/local/psql and executing the clientpreinstall.sh
and the clientpostinstall.sh
I did the dsnadd
command, adding the dba source.
Now, if I try to test the ODBC connection with isql -v dba
i get the following:
[ISQL]ERROR: Could not SQLConnect [01000][unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found
odbcci.so exists in that dir.
What should I do to make it work?