Connect Oracle Issues with ODBC

If you use a 11g client and then connect to the 10g Oracle via ODBC (remote connection), the listener fails to start (ora-12541:tns: No listener)

At this point, you need to D:\instantclient_11_2 the Tnsnames.ora file in the client directory. In this file, the appropriate content:

Test =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 120.120.9.4) (PORT = 1521))
)
(Connect_data =
(SID = test1)
(SERVER = dedicated)
)
)

In this way, ODBC can connect to 10g Oracle

Connect Oracle Issues with ODBC