MS Access via FTP

Jenski · 02-04-2009, 09:24 AM

Hi guys,

I have always used MySQL with PHP, but I now need to link to an MS Access database.
The MS Access database is on a network drive and the server running PHP needs to access it. How can I connect to it?

Salathe · 02-04-2009, 09:47 AM

You can use the ODBC extension (http://php.net/odbc) which is similar to your familiar mysql_* collection of functions.

Jenski · 02-04-2009, 10:00 AM

Thanks,
Is it possible to do <servername>/<path to file> in the connection string with a username / password?

Wildhoney · 02-04-2009, 02:27 PM

As far as I can see, from the manual on odbc_connect, it would be something like the following. Though I have to admit that I've never used it before in my entire life.

php Code:

odbc_connect('DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=dbname.mdb', $szUsername, $szPassword);