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" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
> 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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
