Unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified in ms odbc administrator

excel oracle odbc tnsnames instantclient
sandhiya picture sandhiya · Sep 11, 2016 · Viewed 23.9k times · Source

I want to add two service names in one tnsnames.ora file and getting error in below 2 image in "Microsoft ODBC Driver Configuration". enter image description here

Answer

PV8 picture PV8 · Jul 14, 2020

One trick which help me is, when you fill:

Data Source Name     Test
TNS Service Name     10.1.1.105:1521/ALXTEST

so you need to specify the hostname:port/servicename, then it should work

Related questions

Oracle ODBC TNS-less connection string (for 64-bit Excel)

Is there a 64-bit Oracle ODBC driver that supports TNS-less connection (or EZ-Connect) convention? I used to use "Microsoft ODBC for Oracle" which allowed a TNS-less connection string, but that has been depreciated for a long time and there is …

Read More
how to provide username and password in tnsnames.ora

I have connected oracle server database in excel with the help of oracle instant client software and i am getting table and data but whenever i am restarting excel to connect with oracle database it is asking username and password …

Read More
How to escape comma and double quote at same time for CSV file?

I am writing a Java app to export data from Oracle to csv file Unfortunately the content of data may quite tricky. Still comma is the deliminator, but some data on a row could be like this: | ID | FN | LN | …

Read More