Hi varin, putenv("ORACLE_SID=TEST");
$uid = "scott"; $pwd = "tiger"; $inst = "test"; $conn = ocilogon($uid,$pwd,"$inst"); works for me you could also try OCIInternalDebug(8); and see what happens I just noticed you are using Ora_logon, you need to use the OCI functions !! HTH steve At 11:56 AM +0100 12/3/02, varin valery wrote: > I was successful in compiling php with the options --with-oracle >and --with-oci8. > but when i tried to connect to the database with the instruction >Ora_logon("user@tnsname", "password"), I got the following error message: > "Warning: Oracle: Connection Failed: Error while trying to retrieve >text for error ORA-12154 in /home/httpd/html/tmp/testoracle9i.php on line 7" > I don't quite understand since I defined the environment variables >ORACLE_HOME, ORACLE_SID and TNS_ADMIN > > > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- ------------------------------------------------- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php