I am trying to setup a odbc connection for oracle server my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin
and here is the connection settings
(ADDRESS = (PROTOCOL = TCP)(Host = 10.1.100.113)(Port = 1521))
(SERVICE_NAME = ADVA)
when i am trying to setup i am under odbc
i am tring to enter
datasource name: history
tns service name10.1.100.113
and click on test connection
service name: AVDA
i am getting an error saying
ORA-12154: TNS:could not resolve the connect identifier specified.
can someone help me please.