Connecting to remote databases
| From: | Daniel Furse | Date: | Wed, 28 Feb 2001 14:51:50 +0000 |
| Subject: | Connecting to remote databases | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5754@lists.php.net to get a copy of this message | ||
Hi everyone,
I'm trying to connect an Access database that is not on the same server as
the web server. All the servers are Windows NT 4, the web server is IIS4,
and I'm using PHP4. Whenever I try to query the database, it returns:
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 inSQLExecDirect
I've checked that the database is not opened by anyone else. I've also tried
creating a new database on the web server and creating links to the tables
in Access, but I still get the same error. The remote database has read
permissions for the 'Everyone' group, so does the entire directory path, and
the share.
Can anyone help?
Many thanks,
Dan