ODBC connection ORA-12154 Sql State:8004
Hi All ,
Tried setting up Oracle ODBC Driver Configuration with TNS Service Name but it was not able to recognise the tnsnames.
tnsnames.ora
-------------------
NRP45P_APP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora-svc-NRP45P-APP.extend.local)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = NRP45P_APP.extend.local)
))
I am
Able to connect via SQL Plus ( but SQL plus connects as ROBBOm/Anger_me1@'(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(HOST = ora-svc-NRP45P-APP.extend.local)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = NRP45P_APP.extend.local)))' )- notice teh single quotes
Able to connect to SQL Developer using just hostname and service name - no single quotes
I wanted to put the string of SQL PLus connection ( with single quote) but in TNS Servic ename but seems to have a limit of character .
Pleasse help me undertstand , tried two days with no success.Also had no success connecting via a JDBC driver which is why i though ODBC will be more better.