I'm trying to setup pervasive client to access a windows server.
- Extracted Pervasive.SQL-Client-Core-11.30-061.000.x86_64.tar.gz to /usr/local/
- I installed unixodbc (x64)
- I ran ./clientpostinstall.sh from /usr/local/psql/etc
- I linked /usr/local/psql/etc/odbc*.ini to /etc
/etc/odbcinst.ini
[Pervasive]
Driver=/usr/local/psql/lib/libodbcci.so
Driver64=/usr/local/psql/lib64/libodbcci.so
/etc/odbc.ini
[ODBC Data Sources]
DALCON = Pervasive ODBC[DALCON]
Description=Maestro's DALCON database
DBQ=DALCON
Driver=Pervasive
Servername=DALCON3
Username=username
Password=password
Error:
isql -v dalcon
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib64/libodbcci.so' : file not found
[ISQL]ERROR: Could not SQLConnectroot@dalcon-www:/usr/local/psql/etc# ls -l /usr/local/psql/lib64/libodbcci.so
lrwxrwxrwx 1 psql pvsw 15 sep 13 08:47 /usr/local/psql/lib64/libodbcci.so -> libodbcci.so.11
root@dalcon-www:/usr/local/psql/etc# ls -l /usr/local/psql/lib64/libodbcci.so.11
lrwxrwxrwx 1 psql pvsw 26 sep 13 08:10 /usr/local/psql/lib64/libodbcci.so.11 -> libodbcci.so.11.30.051.000
root@dalcon-www:/usr/local/psql/etc# ls -l /usr/local/psql/lib64/libodbcci.so.11.30.051.000
-rwxrwxrwx 1 psql pvsw 662429 jan 18 2013 /usr/local/psql/lib64/libodbcci.so.11.30.051.000
Any idea why? I'm running on the root user.
P.S. The formating is bad, dunno why :S
Best Answer
one must copy psql's .basrsc to root's .bashrc