This content has been marked as final. Show 4 replies
If you installed a 32 bit Oracle client, the ODBC connection should appear in there and everything should work.
If you installed a 64 bit Oracle client, you'd have to use the 64 bit ODBC administrator (the one in Control Panel), and only 64 bit applications could use it.
Thanks for your reply!
Yes, I installed 11gr2 32 bit client as administrator, but still not work.
When I run odbcad32.exe located in C:\Windows\SysWOW64, a new System DSN can be added using OracleClientHome, but connection does not work. Do I miss anything?
The error message is:
Unable to connect
[ORACLE][ODBC][Ora]ORA-12154:TNS: could not resolve the connect identifier specified
Edited by: user11017933 on Dec 21, 2012 4:56 AM
What's the error when the connection doesn't work?
You likely at the very least need to set up tnsnames.ora in your oracle client's network\admin folder with your server connection information.
Thanks so much!! Yes, exactly as you said, after tnsnames.ora is added, the connection works.