problem with dbase connections using ODBC

From: 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

« previous php.db (#12252) next »