With PHP3 working fine with other odbc databases on a NT 4 machine running Apache as the web server, I'm trying to connect to a Pervasive SQL ODBC dsn connection and I'm getting the following error:
PHP 3 Warning: SQL error: Specified driver could not be loaded due to system error 5 (Pervasive ODBC Engine Interface)., SQL state IM003 in SQLConnect in d:\www\htdocs\testaccpac\listinvoices.php on line 22
from the odbc.ini file I see that I'm using
Driver32=d:\PROGRA~1\PVSW\Bin\w3odbcei.dll
as the dll for this particular dsn.
I'm using the following to produce the error:
$dsnname = "demodata";
if ($conn = odbc_connect($dsnname, "", "")) //line 22
//i've also tried the above with proper username and password with no success
{
echo "<br> success to DSN: " . $dsnname;
}
else
{
echo "<br> no success to DSN: " . $dsnname;
}
Testing the connection in 32 bit ODBC dialog works fine, and if I create an Access database on the server, and link to the ODBC connection, everything seems to work properly (ie I can see the data in the tables).
Has anyone seen this problem before? There is a similar post at
http://lists.omnipotent.net/php3/199903/msg02751.html
but that seems to be the only other reference I can find on the net.
Many thanks,
Aaron M.