Connecting to a remote access database

[mucalo]

Hello everybody.

I am trying to use PHP with a MS Access 2002 database. I have a database on one server and the PHP script on another. What must I have set up on the server in order to access the database?

I tried it locally (having both of them on my PC) and the only thing I had to do was to add my Access database via services.msc as a service. However, I got lost when I had to upoad the script to one computer and the database to another.

Furthermore, this is not really for this forum, but as I am here, I might as well ask... I also have to make a C# program that connects to this database, again from a distant computer. What is the connection string then?

And what do I have to setup in my server where the database is to get the Access database accessible for other computers?

Thanks in advance

[WingedPanther]

Have you tried using an ODBC connection?

[mucalo]

Yes, I have. It's not a problem of my connecting code (I believe so), as the thing works when both the script and database are on my local comp.

So I guess I have to change my connection string or set up the server in a certain way?

Please tell me all things a server running an MS Access 2002 database has to have set up for the database to be visible for remote computers.

Thanks.

[WingedPanther]

The ODBC has to be on the local computer. If you can get ODBC to connect to the remote computer, you should be in good shape.