Home / server / Questions / 538686
In Process
Sirber
Asked: 2013-09-14 05:20:29 +0800 CST

Pervasive and unixODBC on Ubuntu Server 12.x x64

  • 772

I'm trying to setup pervasive client to access a windows server.

  1. Extracted Pervasive.SQL-Client-Core-11.30-061.000.x86_64.tar.gz to /usr/local/
  2. I installed unixodbc (x64)
  3. I ran ./clientpostinstall.sh from /usr/local/psql/etc
  4. 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 SQLConnect

root@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

ubuntu

1 Answers

  1. one must copy psql's .basrsc to root's .bashrc

    • 0