Don,
Your DSN may be set to "exclusive" connection mode (check under options).
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Don Jackson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 8:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC connection problem
>
>
> 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]
>
>
--
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]
