Re: PHP And Oracle

On 2000-08-21, Krznaric Michael stated: } I've read the manual on oracle functions on php.net. I've also been } searching for an answer for a few days now. I am under the impression that } if your Oracle database is on a different machine than your PHP and Apache } then you need to install the oracle Clinet on you PHP machine in order to be } able to connect to the oracle databse. Is this correct? If I install } oracle client, does it come with the necessary libraries or do those need to } be copied over from my oracle databse? I've got a quick tutorial on this, but it's not yet ready for public consumption. I assume you're running windows, in which case you need to install the php4 version from http://www.php4win.de/ Then make sure you are running 8.1.6 *client* on the machine that has php4 and your w3 server running. 8.1.6 = 8i, FYI. Then you'll be all set. You need to have the Oracle 8i client installed on the w3 server as php uses some of the 8i libraries. Note that if you're using Apache as your w3 server, your TNS_ADMIN [aka tnsnames.ora] varable MUST point to a local drive. If your tnsnames.ora file is on a network drive, apache won't see it. Also note you must add TNS_ADMIN and ORACLE_HOME to your apache httpd.conf file as a "SetEnv." Your ORACLE_HOME must also be a local drive. It is unrelated to the ORACLE_HOME varable set on the Oracle *server*. The ORACLE_HOME on the 8i client machine simply points to the directory that has 8i installed. Note that you can connect to 7.3.5, 8.0.x and 8.1.x servers with this setup, as I am currently doing that now. When the tutorial is ready, I'll post the URL on php-windows and php-database } Anyone have any information on this. I can't believe that everyone running } oracle here is running the PHP and the webserver on the same machine. ??? Hmmm...weird, that's how PHP works! It runs on the same machine as the w3 server does... /vjl/