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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
Leo G. Divinagracia III
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to