Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
related: stackoverflow.com/questions/11092840/… –  Sirber Sep 13 '13 at 13:23
    
root@dalcon-www:/usr/local/psql/etc# su psql psql@dalcon-www:/usr/local/psql/etc$ cd psql@dalcon-www:~$ isql -v DALCON [][unixODBC][Pervasive][ODBC Client Interface][Client LNA]A non-recoverable error was returned from the name resolution service. Contact your system administrator for assistance. [ISQL]ERROR: Could not SQLConnect –  Sirber Sep 13 '13 at 13:23
add comment

1 Answer

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.