Re: Problem of connection Oracle with PHP4

To solve this when it happened to me, I placed the actual IP address of the server in the TNSNAMES.ORA file instead of its DNS name..

Then the connection string can still use the tnsnames.ora entry..

"Aca Vasic" <acko_at_ni.ac.yu> wrote:

>
>"Bernard Marty" <bmarty_at_club-internet.fr> wrote in message
>news:9d1m04$rt7$1_at_front5.grolier.fr...
>> After a migration from php3 to PHP4, my application doesn't manage to
>> connect to
>> the database defined in the TNSNAMES.ora
>> Message : _oci_open_server:ORA-12154 : TNS:Symbolic adress can not be
>> resolved
>> Somebody can help me please???
>> Thanks
>>
>>
>I had the same kind of problem and my solution was to hardcode connection
>string into php script, something like this:
>
>$connectstring =
>"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)".
> "(PROTOCOL=TCP)(Host=myhost)(Port=1521)))".
> "(CONNECT_DATA = (SID = oracle)))";
>
>
Received on Fri May 18 2001 - 14:52:29 CDT