Mysql and Access

[schwarzen]

Hi, I need to access an MS Access DB in a Win NT server from PHP on a Linux server.

I was trying to access an MS Access DB on a remote server, but when i try to acces it via odbc_pconnect i canot specified the path or ip from the other server.

How can i specified the location where the DB is.

I hope someone can help me.

[Anon]

You'll have to use the ODBC control panel on the WinNT box to define your .mdb file as a "data source." This will let you give it a file handle and you'll use that handle in your odbc_pconnect statement (instead of a path). That's how you do it on the same server, anyway. There might be something else to do since the db is on a remote server.