Re: Help! PHP database connection error.

Database may be open by MS Access application. I don'n know how to work around, but i was happen when I worked with ASP on IIS 4.0 and MS Access 8.0 Andris > I've just tried creating an entirely new database and receive the same error > as well as reparing the old database. I've restarted the web server, still > the same problem. > > The access 2000 db is on an iis 4.0 server which worked fine previously. > > Thanks, > Aaron > > "Gonzalo Vera" <gvz@eucalipto.net> wrote in message > news:1517593416.20010209131908@eucalipto.net... > This usually happens when another user opens a table for modification > (table definition): the table gets locked to all access. If you're > only running localhost try "repairing" your database: maybe you got a > corrupted table or db. Also if you're only on localhost, restart your > computer to make sure all files get closed. If you're not only running > localhost, and the database is on a remote server, you might have some > more trouble, but still would need to do some/all of these actions. > > That was like a gunshot, but it has worked for me in the past... ;) > > Gonzalo. > > > Up till late yesterday I was able to query my database but now I receive > > this error. > > > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The > Microsoft > > Jet database engine cannot open the file '(unknown)'. It is already opened > > exclusively by another user, or you need permission to view its data., SQL > > state S1000 in SQLConnect in wwwroot\test.php on line 2 > > > My script is only trying to make a connection at this time and it does not > > work > > > <?php > > $cnx = odbc_connect (equipment2,'',''); > ?>> > > > What went wrong? Thanks, > > Aaron > > > > -- > 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 > > > > > -- > 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 >