I am trying to connect from PHP to Pervasive SQL using ODBC, and I am
experiencing difficulty.
My PHP looks like this:
$dsn = "GruffTrading"; // Datasource
$dsu = ""; // User
$dsp = ""; // Password
if(!$odbc = odbc_connect($dsn,$dsu,$dsp)) die("Unable to connect to Data
Source $dsn<br>".odbc_error().": ".odbc_errormsg());
I can connect to the database using the same DSN from MS Access, and I can
connect to an Access database using the same PHP code, but obviously a
different DSN.
The error is S1000: [Pervasive Software][ODBC Interface][Pervasive Software
SQL Engine]General error.
I am using the Pervasive Software ODBC-32 driver, version 2.04.02.10, and am
running on Windows 2000 Professional, latest patches and stuff all loaded,
and PHP 4.3.0
I would appreciate any pointers in the right direction.
Cheers,
William.
