search

tmolomby / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Pyodbc and Pervasive DB #237

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I am attempting to connect to a Pervasive DB via ODBC DSN. 

I am getting this error:

{{{
Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found
}}}

This error happens when paths are not correct for a user on the system. This is 
what I need to add to my .bashrc file to get the connection to work for a user:

{{{
export PVSW_ROOT=/usr/local/psql
export PATH=$PVSW_ROOT/bin:/bin:/usr/bin:$PATH
export 
LD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/lib64:$PVSW_ROOT/bin:/usr/lib:$LD_LIBR
ARY_PATH
}}}

How could I update the path's for pyodbc and/or python? I would also like to 
know if I should use pyodbc to connect to a pervasive database?

My system is a 64bit linux. I am using pyodbc 2.1.11. I am connecting to a Win 
Server 2008 R2 running Pervasive 10 sp3.

An help is appreciated.

Original issue reported on code.google.com by natew...@gmail.com on 12 Feb 2012 at 3:20