[RESOLVED] MDB

[NZ_Kiwis]

I've used PHP many times before with a MySQL database but this time I need to connect to a .mdb database, can this be done with PHP if so how?

[dagon]

do you mean access? if so look at the ODBC Functions

[NZ_Kiwis]

I get this error

Warning: odbc_connect() [function.odbc-connect]: SQL error: Failed to fetch error message, SQL state HY000 in SQLConnect in E:\xampp\htdocs\dbtest.php on line 18

$user = "";
$password = "";
$DBLocation = "E:\xampp\htdocs\database\Staffdb.mdb";

// Microsoft Access
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=" . $BDLocation . "", $user, $password);

[bradgrafelman]

One problem I see is this:

$DBLocation = "E:\xampp\htdocs\database\Staffdb.mdb";

echo out $DBLocation and it will probably look like this:

E:
mpp\htdocs\database\Staffdb.mdb

since "\xa" is being translated to a line feed (ASCII character 0x0A in hex). Few options to fix that... namely: 1) escape backslashes; 2) use a single-quote delimited string instead, or 3) use forward slashes (not sure if the ODBC driver is smart enough to handle that, however).

[NZ_Kiwis]

I have $DBLocation and $BDLocation - my spelling error.