Re: Connecting to remote databases

Among other articles, look at the two ODBC articles: http://www.phpbuilder.com/columns/ Alain On Wed, Feb 28, 2001 at 02:51:50PM -0000, Daniel Furse wrote: > 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 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net