mdb database viewing. One problem is that error which shows on xampp ( on iis I've got external error 500).
<?php
$plik = realpath("baza/test_wojtek.mdb");
$user = '';
$password = '';
$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$plik", $user, $password);
if (!file_exists($plik)) {
die("Could not find database file.");
}
$zapytanie = "SELECT * FROM test_wojtek_tab";
$wykonanie = odbc_exec($conn, $zapytanie);
echo '<table border="1"><tr><th>id</th><th>p</th><th>d</th><th>t</th></tr>';
while($row = odbc_fetch_array($wykonanie)) {
echo "<tr><td>{$row['id']}</td><td>{$row['p']}</td><td>{$row['d']}</td><td>{$row['t']}</td></tr>";
}
echo '</table>';
ini_set('display_errors', 1); error_reporting('E_ALL');
?>
and there is error:
Warning: odbc_connect(): SQL error: [Microsoft][Sterownik ODBC Microsoft Access ] Nie mo�na otworzy� bazy danych '(nieznane)'. Aplikacja nie rozpoznaje tej bazy danych lub plik jest uszkodzony., SQL state S1000 in SQLConnect in C:\xampp\htdocs\strona\echo9.php on line 7
Warning: odbc_exec() expects parameter 1 to be resource, bool given in C:\xampp\htdocs\strona\echo9.php on line 12
Warning: odbc_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\strona\echo9.php on line 15
Do you have any sugestions? I did almost everything (all odbc settings changing cide etc.)