[quote]Originally posted by supernick:
The user was using Oracle Client 7.3.3 and everything was working fine with DOA.
But they are using now Oracle Client 8.1.x and when my program try to connect to the Alias , i receive this error :
"TNS cannot resolve Service Name"
Any Idea how to fix it ?
is it a Oracle 8 (SQL Net) problem ?
Thank's in advance...[/quote]
Hello,
This looks like an Oracle problem.
Oracle 8 and up uses a different TNS names file.
For Oracle 7.xx this file is located in <drive>\ORANT\NETWORK\ADMIN\
For Oracle 8.xx this file is located in <drive>\ORANT\NET80\ADMIM\
When upgrading you must create a new TNSNAMES for Oracle 8 with the same aliases as there where used for Oracle 7.
Normally the application will try to locate the first TNSNAMES, and that is the one from Oracle 7.
Oracle however will locate the version that matches the database version (Oracle 8)
So, ad the aliases to the TNSNAMES for Oracle 8 and the application will run fine.
------------------
JohaViss
