I am running PHP on a 64bit windows 2008 server. I have both ODBC 32bit and 64bit installed and I attempt to do this:
$dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=$mdbFilename", $username, $password);
The 32bit ODBC install has the driver Microsoft Access Driver (*.mdb)
and the 64bit version has the Microsoft Access Driver (*.mdb, *.accdb)
which is what I need but PHP says it cant find it and I am assuming PHP is only referencing the 32bit ODBC driver.
Why is this the case? Is it as simple as PHP/Apache being a 32 bit install?
Thanks all for any help