 |
 |
Find a programming school near you
php-db | 2001011
Date: 01/05/01
- Next message: Partyka Robert: "[PHP-DB] Re: [PHP] Autologin problem"
- Previous message: Joachim Maier: "AW: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive"
- In reply to: Richard Crawford: "[PHP-DB] Connecting to a Remote Oracle Database"
- Next in thread: Richard Crawford: "RE: [PHP-DB] Connecting to a Remote Oracle Database"
- Reply: Richard Crawford: "RE: [PHP-DB] Connecting to a Remote Oracle Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- application/x-pkcs7-signature attachment: S/MIME Cryptographic Signature
- Next message: Partyka Robert: "[PHP-DB] Re: [PHP] Autologin problem"
- Previous message: Joachim Maier: "AW: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive"
- In reply to: Richard Crawford: "[PHP-DB] Connecting to a Remote Oracle Database"
- Next in thread: Richard Crawford: "RE: [PHP-DB] Connecting to a Remote Oracle Database"
- Reply: Richard Crawford: "RE: [PHP-DB] Connecting to a Remote Oracle Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
