Re: Oracle + PHP +Apache connect problem?

Christian Darnell wrote: > I'm running Apache and PHP on my working station and a Oracle database (version 8.1) on a > computer in my Intranet. When i try to do $conn = > ocilogon("username","password", ORACLE_SID); I get this: Warning: > _oci_open_server: Error while trying to retrieve text for error ORA-12154 > > I heard someting about that tnsnames.ora should be installed on the webserver? Where sould > tnsnames.ora be placed? > > Do also have to add somthing like this to the httpd.conf: > > PassEnv ORACLE_HOME ? > > /Christian > > -- > 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 Hi! ;^) $ORACLE_HOME/network/admin/tnsnames.ora then in httpd.conf you need add : SetEnv TNS_ADMIN "/path/to/your/tnsnames.ora_file" SetEnv ORACLE_HOME "/path/to/your/oracle_home_dir" c ya! Jarek