this is my code:
$conn=odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . str_replace("/", "\\", $_SERVER["DOCUMENT_ROOT"]) . "\a.mdb",'','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
while (odbc_fetch_row($rs))
{
print_r(odbc_result($rs,"CompanyName"));
}
odbc_close($conn);
this is what I get from that:
! ?)| ?)| ?)|
WHYYYYYYYY??? in the base is only write in “Test inc” in text type