Access/PHP/NT problem

Anon

Hi all,

I'm having a problem.

I need to get to a DB (Access format) that's on a different server to the web server. I've mapped a drive to the correct path, and created a system DSN to that path. However, when I tried to query that DB I got an error.

Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open the file 'SIDSC.MDB'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLExecDirect

I have given the IUSR_XXX account access to this directory and verified that there are no other connections to this database. Does anyone have any clue why this isn't working?

Both servers are running WinNT 4.0

Many thanks,

DanF

Anon

Make sure the table isn't opened by anyone with Access. If worst comes to worst, reboot.

Anon

Table is closed. Tried rebooting both servers, but no effect.

Anon

Hello,

I have the problem also. I am more inclined to believe its a php bug.
Accessing mapped drives to an Access Database works fine with Win based applications. No amount of rebooting or privilage setting will rectify this.

If anyone can prove me wrong I would be most greatful, as I could really do with this working.

Has anyone ever managed it?

If so, why are there so many requests regarding the problem, which no one has given a solution for?

All the best,
Allan M.

Anon

Ah, right. Sorry. My bad. I should have posted my solution.

I did fix this. In the end I created a new Access DB on the local server with linked tables to the remote database. Then I re-checked the permissions on the remote DB, making absolutely sure I had the right IUSR_machinename user specified, all the way through the directory tree. Now I can query the remote DB without any problem.

I don't think there is a PHP bug, I'd probably be tempted to blame MS. But then, I blame them for everything 🙂

Hope this helps,

Dan