Re: problem with dbase connections using ODBC

boy, if i remember my old dbase days, dbase uses a table locking scheme. and a pessimistic locking style. if you are just querying the table, how about making a copy of it when a local user opens it and again, when they close it. your remote users will then query the copy... Don Jackson wrote: > > Windows NT 4.0 workstation > Apache > PHP 4 > > the following code works fine and returns the correct results... > -------------------------------------------------------------------- > <? > $connect = odbc_connect("partner","",""); > > $query = "SELECT company FROM listing"; > > $result = odbc_exec($connect, $query); > > while(odbc_fetch_row($result)){ > print odbc_result($result, "company") . "<br>"; > } > > odbc_close($connect); > ?> > ----------------------------------------------------------------------- > > but if someone else is accessing the table (not exclusively) i get the error > message..... > ---------------------------------------------------------------------- > Warning: SQL error: [Microsoft][ODBC dBase Driver] The Microsoft Jet > database engine cannot open the file 'N:\listing.DBF'. It is already opened > exclusively by another user, or you need permission to view its data., SQL > state S1000 in SQLExecDirect in c:\Program Files\Apache > Group\Apache\htdocs/test.php on line 6 > ---------------------------------------------------------------------- > > Is there a work around for this or a fix? > I need to give internet access for this older internal database at the same > time local users are accessing it. > > I've tried using ASP and PWS and it works but I really want to use PHP ;> > > thanks in advance > > don > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Leo G. Divinagracia III ldivinag@csuhayward.edu