Windows was throwing the error
"ORA-12154: TNS: could not resolve the connect identifier specified"
because the Environment Variables were incorrect. Specifically, the error was that the
TNS_ADMIN variable was set to:
C:\oracle\instantclient_10_2;
Yes, the problem was with the semicolon at the end position of the string. As soon as I removed it, I could configure the ODBC driver properly. Now I add a new connection in Visual Studio to the oracle database without any problem.
The semicolon was making the TNS_NAMES.ora file not accesible to windows, and thus the service was not known to the system.
I hope this post (though apparently silly) helps any other newbies like me...
tns_admin : 就是tnsnames。ora的路径 。。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-772397/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-772397/