Windows NT 4.0 workstation
Apache
PHP 4
I'm using ODBC to connect to dbase tables.
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.
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]