This content has been marked as final. Show 6 replies
The ODBC driver was working. I tried with Microsoft Excel, I can pull the tables out from the database. I think there is a bug here in the microsoft ODBC driver manager. in the ODBC driver manager, it failed the connection test and gives the error msg which is in my first posted message.
Try setting the TNS_ADMIN=<the path of tnsname.ora directory> as and enviornment variable on your client machine.
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 (126.96.36.199.0 32 bit)
Hope this helps someone, and thanks again Sanjay for posting :o)
how can we configure this setting?
I am having same issue.
where can i find TNS_ADMIN, so that i can make necessary changes.
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