Can someone help me with an error message received when trying to establish an Oracle database connection to DSP 6.5.2?

DSP User

• December 21, 2016 13:08

I have an Oracle database connection to DSP 6.5.2 and I’m receiving the following error message when I click "Test Connection" on the Data Source page. – can anyone help me out?

“Internal Error - The provider is not compatible with the version of Oracle client. The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception. Exception has been thrown by the target of an invocation. Check that the appropriate database drivers are installed. A connection could not be established with the underlying data source. Check that the appropriate database drivers are installed. An unhandled exception occurred during the execution of the plugin. An unhandled exception was caught while executing a plugin.”

Background info:

• Version of the Oracle client installed on the app server is 11g
• 32bit client is installed
• Put a proper connection TNS string in the TNSNames.ora file
• Able to successfully TNSPING the database to which I’m trying to connect

Steps I’ve completed:

1. Verified that the Oracle Driver is installed by looking at the environment variable PATH.
2. Verified that the WebApp server has been rebooted since the Oracle Driver was install.
3. Verified IUSER and IIS_IUSRS have READ and EXECUTE permissions on the Oracle folder and that the sub-folders have inherited these permissions.
4. Verified that the files TNSNAMES.ORA and SQLNET.ORA exist.

NOTE: the ODBC shows a message ‘Connection Successful’

The issue I’m having is when I try to establish an Oracle Database connection to DSP 6.5.2.

1

• 

  DSP User

  • February 10, 2017 15:58

  I’ve taken the following steps to make the FE1 Connection work:

  1. Uninstalled all Oracle drivers from the system and checked that there were no entries in the registry hanging out from those previous installations.
  2. Installed 32-bit Admin version of the driver and received warning that "Environment does not meet minimum requirements." A search showed that this was not an actual issue (log file showed "Reference data is not available for verifying prerequisites on this operating system distribution").
  3. Completed configuration for newly installed driver (tnsnames updated, connection added to 32-bit ODBC administrator, test connection passed).
  4. Double checked configuration in the DSP. Test connection still fails with the same error. Verified folder permissions for the Oracle path, which had no change. When I changed the connection type from Oracle to ODBCOracle, the test connection passed.
  5. Refresh on package completed with no issue (and showed as being faster than the Oracle connection on the old system).

  1

Please sign in to leave a comment.