I'm connecting to my access database using PHP. My access file is located here in the server:
e:\home\sbpsp2\dados\fichas\jornada_xyz.mdb
then... here is the code
$dbName = $_SERVER["DOCUMENT_ROOT"] . "dados\fichas\jornada_xyz.mdb";
if (!file_exists($dbName)) {
die("Could not find database file.");
}
$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$dbName; Uid=; Pwd=;");
I always get "Could not find database file", already tried different things on the first line.