Re: Connecting to a Remote Oracle Database

Richard Crawford wrote: > Does anyone have any thoughts on how to connect to an Oracle database which > resides on a remote server? The connection script looks something like this > already: > > putenv("ORACLE_SID=[db]"); > putenv("ORACLE_HOME=[location of tns file]"); > $db = ocilogon("[user]","[password]"); > > Is there a param I can put in somewhere to designate server ID? > > -- > 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 The first is install Oracle client software in the box where web-server resides. Add in apachectl ORACLE_HOME=path_to_oracle_home export ORACLE_HOME You must sure that you connect descriptor (thirth parameter in ocilogon) is in TNSNAMES.ORA in $ORACLE_HOME/network/admin Hope this helps -- Luis Castro Mendoza Universidad de Chile Vicerrectoría de Economía y Administración Servicios Tecnológicos de Gestión mailto:lcastro@uchile.cl Phone: 56-2-6782662 Fax: 56-2-6782670

Attachment: [application/x-pkcs7-signature] S/MIME Cryptographic Signature smime.p7s