ORA:12154 TNS Could Not Resolve Service Name

[Ram]

Hey,
I'm using ODP.Net on my server.
Until recently I had ODP version 9.2.0.2102 and now I've upgraded to
9.2.0.700.
All my applications that upgraded to 9.2.0.700 work perfectly,
But all the old applications still compiled with the 2102 version
receive:
ORA:12154 TNS Could Not Resolve Service Name
NOTE: both the applications work on the same server,
And on that server there is only ONE ORACLE_HOME...
Is there anything I'm forgetting?
Thanks ahead

--sternr

 

[Sahil Malik [MVP C#]]

You need to edit your tnsnames.ora file.

- SM

 

[Ram]

Hey Sahil thanks for your reply!
As I mentioned before - there is not problem with my TNSNAMES.ora file
- since
TNSPing does work...
Anyway - I found the problem!
It turns out the ODP.Net cant handle files with ")" in their names
(DONT ASK WHY!)
But the second I renamed my file, all went well!
Thanks again!

--sternr