Attempting to read an access file into a PDO.
$db = "D:/VacConJobTrackerbe.accdb";
if (!file_exists($db)) {die("Could Not find database file.");}
else {echo "Found Database file.<br/>";}
$jobTrackerConn = new PDO("odbc:Dbq=$db;Charset=UTF-8;Driver={Microsoft Access Driver (*.mdb, *.accdb)};Uid=Admin;");
I get a 500 error.
The php logs are clean. Other parts of my application successfully read from a sql server.
odbc Data Source Administrator 64-bit lists ‘Microsoft Access Driver (*.mdb, *.accdb)’
16.00.18025.20030
PDO::getAvailableDrivers() returns odbc & mysql
php.ini has both extension=odbc and extension=pdo_odbc un-commented
php 8.3.12, 64 bit
office 365 & access runtime version 16.0.18025.20160 64 bit
Windows Server 2016 Datacenter
IIS Version 10.0.14393.0
I’ve tried swapping the driver & dbq in the connection string, omitting charset, and many other permutations. Adding Uid=Admin had no effect. Misspelling the driver results in a different (non-500) error. So does misspelling the file.