PHP, ODBC and Pervasive SQL
| From: | William Nettmann | Date: | Wed, 10 Mar 2004 08:21:47 +0000 |
| Subject: | PHP, ODBC and Pervasive SQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-179987@lists.php.net to get a copy of this message | ||
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.