Re: ODBC Connection Problems

I have experimented with ODBC connections and had success so my guess is you may need to check what permissions are on the said .mdb file. Robin Bolton wrote: > > 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