Please Help:

I have a MS Access DB on my PC, and would like to get some data using a php script from my website hosted on a external (internet) server.

Any ideas?

I've read about OBDC and Data Source Name, but cant find a useful reading resource.

thanks!

Dan.

In order to do this you would need to open a port to your computer. Not very Secure at all!

Why don't you just upload the Access DB to your server in a protected directory and connect to it on the server?

:peace:

your web host would need to be running a server that has access on it if you want to use an access database. i think most hosting providers use mysql (as we do) which is particularly different in that an access database can be held in a file but a mysql database has meta information separate to the database file so its much easier to just create it where you want to use it. all those friendly wizardy things access gives you for creation and querying arent really available for mysql .

either way you will need exacting code to talk to the database which is basically establishing the connection (generally giving a username,password & database name), querying the database, processing the result and closing the connection.

the odbc is a driver (go between) between your code and the database and you will need it or some other driver to talk with your database

basically you should definitely know which database you are going to use and which language (java,php etc) before you choose a driver or write code for it.