Re: [PHP-DB] help php4.0.6&Oracle9i !

2002-03-22 Thread Rafael Schleuss 

ORA-12154: TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the
TNSNAMES.ORA file.

Action: Make the following checks and correct the error:
- Verify that a TNSNAMES.ORA file exists and is in the proper place and
accessible. See the operating system specific manual for details on the
required name and location.
- Check to see that the service name exists in one of the TNSNAMES.ORA files
and add it if necessary.
- Make sure there are no syntax errors anywhere in the file. Particularly
look for unmatched parentheses or stray characters. Any error in a
TNSNAMES.ORA file makes it unusable. See Chapter 4 in the SQL*Net V2
Administrator's Guide. If possible, regenerate the configuration files using
the Oracle Network Manager.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] help php4.0.6&Oracle9i !

2002-03-12 Thread Steve Farmer 

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

[PHP-DB] help php4.0.6&Oracle9i !

2002-03-12 Thread varin valery 

  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