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]
