ACCESS ODBC problem!

[buttgereit]

I have written an administrator system using a MS Access database and PHP's ODBC functions (which means I for example use odbc_connect() when I establish the database connection).

When I was finally going to install my system on the web hosting server they claimed I couldn't make my connection the way I had done since I didn't get a DSN for my database. So as far as I know ODBC MUST have a DSN to connect, otherwise I have to go with this ADODB thing (?).

Does this mean I have to go through all my code and change every line where I interact with my db, or is there a way to connect to my Access db without a DSN, and still be able to use PHP's ODBC functions?

I'm really desperate for answers, thank you!

[LordShryku]

Nope. ODBC needs a DSN

[Drakla]

I don't know if this'll be any help to you, but you can connect staright to a .mdb like this:

$directory="C:\\Databases";
$filename="mydb.mdb";

$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$directory\\$filename";	

$dbh=odbc_connect($db_connstr,"","") or die ("Couldn't CONNECT to that MDB");

But I'm presuming this will only work on a windows platform.