I have two machines -- one called "DB" and one called "WEB". I have a website on WEB that currently uses ODBC to query an Access 2000 database. I want to move the database off of WEB and onto DB, but PHP is not letting it happen.
I have set up the ODBC connection on WEB to point to the file on DB, but PHP complains:
The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view it's data.
WEB uses user "IUSR_WEB" for it's anonymous access; I have created a user IUSR_WEB on DB with the same password and given it full control over the database directory.
Any ideas about if this can be done?
Thanks!
randal @ hpi.net
I have set up the ODBC connection on WEB to point to the file on DB, but PHP complains:
The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view it's data.
WEB uses user "IUSR_WEB" for it's anonymous access; I have created a user IUSR_WEB on DB with the same password and given it full control over the database directory.
Any ideas about if this can be done?
Thanks!
randal @ hpi.net