Re: Oracle Connection
| From: | Brian S. Dunworth | Date: | Tue, 10 Apr 2001 15:53:19 +0000 |
| Subject: | Re: Oracle Connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48042@lists.php.net to get a copy of this message | ||
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 4yeah, me too. :) - Brian ------------------------------------- Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 <brian@theprintinghouse.com> -------------------------------------