ODBC connection problem

From: Date: Tue, 11 Sep 2001 00:08:51 +0000
Subject: ODBC connection problem
Groups: php.db 
Request: Send a blank email to php-db+get-12328@lists.php.net to get a copy of this message
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

« previous php.db (#12328) next »