I have 2 Oracle Installation: Oracle 9i client and Oracle 11.2 server
Oracle 9i in: C:\oraclient9\
Oracle 11g in: C:\app\a.l\product\11.2.0\
I've an application that have to connect to Oracle via ODBC But every time I try to connect the odbc search Oracle 9i and I get this error:
ORA-12541: TNS no listener
If I try to start with sqlplus from: Start --> Run --> sqlplusw I get Oracle 9i version
If I run sqlplus from start --> Program --> Oracle 11 --> I can connect correctly.
If I try to create a new ODBC It connect always the Oracle 9i version.
In attach I send you tnsnames.ora and listener.ora from both versions.
Have you any idea How can I create a new ODBC to connect at Oracle 11g?
Thanks in advance!