unable to connect to database on a networked drive

Question

Hi,

I'm trying to connect to an access database from a php script using ODBC.

When I put the db on my local c: drive create a system DSN i can connect no problem, but when it's on the networked drive I get the error:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in C:\wamp\www\suppliers\furniture.php on line 3

Ok so I'm guessing it's permissions somewhere anyone know specifically what/where?

Thanks,

Answer 1

If you used the defaults during installation then apache is running with the Local System account, which doesn't have any network privileges. So you have to make sure it runs as a (domain) user that can access the network drive. You can change this via Control Panel, Administrative Tools, Services (right click on Apache, select Properties and select a user on the Log On tab).