RE: [PHP-DB] ODBC connection problem
| From: | Andrew Hill | Date: | Tue, 11 Sep 2001 13:06:05 +0000 |
| Subject: | RE: [PHP-DB] ODBC connection problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12340@lists.php.net to get a copy of this message | ||
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:djackson@soto.on.ca]
> Sent: Monday, September 10, 2001 8:09 PM
> To: php-db@lists.php.net
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>