This content has been marked as final. Show 6 replies
Thanks Sanjay - I had this problem and your suggestion fixed it: setting the TNS_ADMIN did the trick.
Note: This was on a development PC which already had the Oracle Client drivers installed (so I already had a different TNS_NAMES.ORA in that installation).
It is worth noting that on my target deployment machine which DOESN'T have the Oracle Client drivers (just the InstantClient + Instant-ODBC) I didn't need to set TNS_ADMIN
I'm using the 11g InstantClient (18.104.22.168.0 32 bit)
Hope this helps someone, and thanks again Sanjay for posting :o)
This helped me as well. Thank you.
From cmd.exe window
Remember that your path to \product\10.2.0\server\NETWORK\ADMIN may be different to mine
Edited by: Gaillimh on Feb 8, 2011 11:20 AM