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.