problem with dbase connections using ODBC
| From: | Don Jackson | Date: | Fri, 07 Sep 2001 17:54:49 +0000 |
| Subject: | problem with dbase connections using ODBC | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12252@lists.php.net to get a copy of this message | ||
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