TNS name problem -php_oracle.dll library

From: Date: Tue, 15 Jan 2002 15:38:30 +0000
Subject: TNS name problem -php_oracle.dll library
Groups: php.db 
Request: Send a blank email to php-db+get-15829@lists.php.net to get a copy of this message
Hello, I have the follow problem: I have installed oracle 7.3 client and work right, and I have installed apache and php the last version. When I try to connect to oracle with the libray php_oracle.dll I get the follow message: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name and testing the tns name solve very well(command window) The script is the follow: <html> <head> <title>Ejemplo PHP</title> </head> <body> <?php print "<HTML><PRE>"; $connn = ora_logon("name@TNSNAME","password"); function select_data($conn) { $stmt = ora_parse($conn,"select * from scott.names"); ora_exec($stmt); echo $conn."----selecting\n\n"; while (ora_fetch($stmt)) echo $conn." <".ora_do($stmt,"TEST").">\n\n"; echo $conn."----done\n\n"; } select_data($connn); // result of c1 ora_logoff(connn); ?> </body> </html> I need your help. Thanks in advance. Enrique -- _______________________________________________ 1 cent a minute calls anywhere in the U.S.! http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com

« previous php.db (#15829) next »