Re: Oracle Connection
| From: | Andrew Hill | Date: | Mon, 16 Apr 2001 00:07:59 +0000 |
| Subject: | Re: Oracle Connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48667@lists.php.net to get a copy of this message | ||
You can use ODBC as well.
Compile PHP with iODBC (http://www.iodbc.org) and you can use an ODBC driver
instead of the oci - this can bypass the Oracle client install in many
cases.
Best regards,
Andrew
--------------------------------------------
Andrew Hill . Director Technology Evangelism
OpenLink Software . www.openlinksw.com
Internet Data Integration Technology
On 4/10/01 11:53 AM, "Brian S. Dunworth" <brian@theprintinghouse.com> wrote:
> At 08:42 AM 4/10/01 -0700, Dunaway, Brian wrote:
>
>> I need to access a remote oracle database. What I mean is that the machine
>> that is allowed access to the oracle database is not running php...I have
>> access to the machine with the oracle access from my machine which is
>> running php. Boy that sounds confusing.
>
> No, not really.
>
>> anyway I am setting my environment with putenv(oracle_home=/something) and
>> putenv(oracle_sid=database)...what can I do? any ideas?
>
> I'm assuming that this isn't working for you. Make sure you set
> NLS_LANG etc, as well in your environment, as specified in the PHP
> documentation.
>
> Do you have an Oracle client installed on the machine that has PHP
> installed on it? Did you compile PHP with oci8 support?
>
> Here, our web server (Linux) has Apache/PHP and Oracle Net8 client
> installed. The Net8 client talks to our Sun box with Oracle 8i
> installed. Works with PHP with no hitches.
>
>> Brian D.
>
> yeah, me too. :)
>
>> Running PHP 4
>
> yeah, me too. :)
>
> - Brian
>
> -------------------------------------
> Brian S. Dunworth
> Sr. Software Development Engineer
> Oracle Database Administrator
> The Printing House, Ltd.
>
> (850) 875-1500 x225
> <brian@theprintinghouse.com>
> -------------------------------------
>