Re: Help -- Oracle
| From: | Philippe Saladin | Date: | Thu, 24 Jan 2002 15:05:09 +0000 |
| Subject: | Re: Help -- Oracle | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16146@lists.php.net to get a copy of this message | ||
Have you tried to replace the tnsname with its exact definition ? not the
best thing to do, but it could be a workaround.
Example : something like :
$oracletns = "(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 201.1.1.445)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 201.1.1.445)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)";
// instead of $oracletns = "mydb_tcp"
$Conn=OCILogon($oracleusername, $oraclepassword,$oracletns) or
die("connexion impossible");
Regards,
Philippe
"Yuwin" <yuwin@msctrustgate.com> a écrit dans le message news:
20020123065506.89391.qmail@pb1.pair.com...
> Help, i'm trying to connect to a remote oracle database from
> win98/apache/php4 and win2k/iis/php4 but it always gives me tns error.
Other
> apps however, works fine with the tns configuration. the php oracle module
> was loaded successfully on both platforms.
> I've tried all sorts of possibilities. path to tnsnames.ora is correct.
> I've even tried with ODBC but when i used it with php, i get "server
refused
> connection". However, ODBC test was successfull and other apps can work
with
> it.
>
> Thanks in advance.
>
> --
> yuwin
>
>