Unable to connect SQLState=08004 [Oracle][ODBC][Ora]
Connecting an Oracle Database Using an ODBC Connection
Connectivity issue Overview during ODBC setup
Apps team installed Oracle instant client 11.1 (32-bit) on apps server. while testing
the connection (while creating system DSN) from the ODBC driver, getting the
below error. we have put the details as shown below.
- Data source Name: ORACLP
- Description: ODBC connection
- TNS Service name: oraaj01.ajara.tech
- User ID : DWRD
Click on Test connection.
Error: unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154:TNS could not resolve the connect identifier specified
Troubleshooting the ODBC Data Source Connection
Solution:
To configure an ODBC connection to the new ORACLP database, but within the ODBC set-up it
requires the TNS Service Name (provides a drop down list but this is empty).
resolved this issue… by putting in the following string in for the TNS Service Name –
oraaj01.ajara.tech:1521/ORACLP works….
Service Name :ORACLP
TNS Service name: oraaj01.ajara.tech:1521/ORACLP
See also