RE: [PHP-WIN] RE: Connecting to remote databases

Thank you! Now it works! This problem first popped up over six months ago, and I've been working round it since then. Many thanks, Dan -----Original Message----- From: Mayo, Bill [mailto:bemayo@co.pitt.nc.us] Sent: 01 March 2001 16:10 To: 'Daniel Furse'; PHP Windows List (E-mail) Subject: [PHP-WIN] RE: Connecting to remote databases I had this exact problem and it took me days of beating my head against the wall to find the solution. First, you do want to make sure that the Access security permissions are correct on the database. For example, "Admin" typically needs to be the owner; it can sometimes get corrupted, causing a problem. Secondly, you need to make sure that the IIS user account has the appropriate NT permissions to the database. I have found that write access is required for it to work. Thirdly, and most likely your problem, is a bug in IIS. Check out Microsoft TechNet article Q189408 (FIX: ASP Fails to Access Network Files Under IIS 4.0 and IIS 5.0). ~~~~~~~~~~~~~~~~~~~ Bill Mayo Network Administrator Pitt County MIS > -----Original Message----- > From: Daniel Furse [SMTP:daniel.furse@iptest.com] > Sent: Wednesday, February 28, 2001 9:52 AM > To: PHP Windows List (E-mail) > Subject: Connecting to remote databases > > 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