'ORA-12154 TNS:could not resolve the connect identifier specified'
CAUSE:This is a result of the TNS Service Name extension not being set properly in the DSN configuration .
ACTION:Add the proper TNS Service Name extension in the ODBC Data Source Administrator and verify that the test connection is successful in Strategy Connectivity Wizard
KB015863