[unixODBC-support] Problems usinf unixOdbc with php5 and Pervasive SQL Driver

Nick Gorham nick.gorham at easysoft.com
Fri Nov 9 16:28:01 GMT 2007

Glyn Astill wrote:

>Hi People,
>I'm new to this list so hello.
>I'm trying to get unixODbc working with a driver for Pervasive SQL
>from php5 however I'm receiving the following error from php when I
>try to connect:
>Warning: odbc_connect() [function.odbc-connect]: SQL error:
>[unixODBC][Driver Manager]Can't open lib
>'/usr/local/psql/lib/odbcci.so' : libpscore2.so.2: cannot open shared
>object file: No such file or directory, SQL state 01000 in SQLConnect
>in /var/php/pvsql_test.inc.php on line 7
>I assume this is something to do with a library not being there, or
>not being set up properly.
>After installing the Pervasive SQL driver I added the env vars
>reconmended in Pervasives docs to my default profile and they seem to
>be ther if I do a "set" in the terminal.

I would first check if it works using isql

isql -v DSN

see what that returns

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list