ODBC Connection Problems

From: Date: Thu, 28 Mar 2002 21:00:41 +0000
Subject: ODBC Connection Problems
Groups: php.windows 
Request: Send a blank email to php-windows+get-12811@lists.php.net to get a copy of this message
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 rbolton@lonepinepublishing.com

« previous php.windows (#12811) next »