Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] Connecting to a Remote Oracle Database From: Richard Crawford (rscrawford <email protected>)
Date: 01/05/01

Very helpful. Thanks, Luis.

> -----Original Message-----
> From: Luis Castro Mendoza [mailto:lcastro <email protected>]
> Sent: Friday, January 05, 2001 12:00 PM
> To: Richard Crawford
> Cc: php-db <email protected>
> Subject: Re: [PHP-DB] 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 <email protected>
> > For additional commands, e-mail: php-db-help <email protected>
> > To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 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 <email protected>
> Phone: 56-2-6782662
> Fax: 56-2-6782670
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>