Error#1:
—————————
ODBC 32Bit Test Program
—————————
SQLSTATE: S1000
Native Error Code:12514
Driver Message:[Oracle][ODBC][Ora]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Need Any suggestions to avoid error ?
—————————
Yes No
—————————
Cause: Unable to locate the Specified Host by name
Fix: Create an entry in Hosts file
Say you are creating an inst03.dev.test.lab, then in the hosts file ("C:WindowsSystem32driversetchosts") make an entry for inst03.dev.test.lab and specify your target oracle DB IP address.
Error#2:
—————————
ODBC 32Bit Test Program
—————————
SQLSTATE: 08004
Native Error Code:12154
Driver Message:[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name
Need Any suggestions to avoid error ?
—————————
Yes No
—————————
Cause: Unable to resolve the TNS entry specified in "C:Oracleora81networkADMINtnsnames.ora" file.
Fix: Make sure you have entry for chosen TNS in tnsnames.ora file.
Say you are connecting to inst03.dev.test.lab, then in the tnsnames.ora file make an entry for inst03.dev.test.lab exists and specified service name is correct.
