Posted on 2011-10-25
I am able to connect to Oracle at the CMD screen with userid SYS and my password. I can run SQL commands like SELECT and DESC. So my TNSNAMES.ORA file must be good.
When I try to connect through ODBC, it doesn't work. I get the Oracle ODBC Driver Connect and put in the UID and PW. I get:
"ORA-12154: TNS:could not resolve the connect identifier soecified"
I am running Windows XP Professional. I installed the Oracle instantclient 11.2. I have the environment variable set.
Do I need other *.ORA files before the ODBC links will work? Like LISTENER.ORA?