Mark Bole wrote:
> Draniom wrote:
>
>> Hello,
>>
>> With a 8.0.5 client, i'm unable to connect to an Oracle9 server.
>>
>> The tnsname.ora on the client computer seems to be ok. When i make a
>> test with the Net8 Assistant, the test succeeds.
>>
>> But when i try to connect with SQL+ 8 , an error is returned :
>> error : 0RA-12154: TNS: could not resolve service name...
>>
>> Any idea ?
>>
>> Thanks.
>>
>
> Client 8.0.5 has never been supported for connecting to 9.0 or 9.2 server.
>
> See Metalink Note:207303.1 for more information on client / server
> version interoperabitlity.
>
> -Mark Bole
>
>
>
Which has nothing to do with the problem at hand. Better yet: the
combination was supported (but as 8.0 isn't, not anymore)
Check whether you have 2 oracle_homes - I bet you have: one (with
the net assistant) has a correct tnsnames.ora - the other has not.
Copy the correct one over to the other home (the one with sqlplus
in it)
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Sep 28 2005 - 14:53:24 CDT
