TNS name problem -php_oracle.dll library
| From: | Enrique Grajeda | 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