I have an Access database which I made a DSN connection to. As long as the .mdb file is on the same machine as my Apache Server I can connect to it just fine. However, if I try to set the DSN to point to an .mdb file on our network (mapped to a drive letter), I get the following error in PHP:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\www\test\odbc\odbctest3.php on line 2 I know for a fact it's not open on any other machines, so it's not a sharing issue. Which knocks it down to either permissions or just more PHP network sillyness. I've tried pointing the DSN connection to the .mdb using both the mapped drive letter and UNC paths, same error either way. The username that I log onto my workstation with has administrative priveledges for both our domain, and the machine itself. Server: NT 4.0 Server Workstation: Win 2000, Apache, PHP 4.1.2 Thanks, Robin Bolton IT / Web Developer Lone Pine Publishing [EMAIL PROTECTED] -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
