Connecting to remote databases

From: 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

« previous php.windows (#5754) next »