Test Accelerators       SAP  |  Oracle Fusion  |  Oracle EBS  |  Salesforce  |  Workday  |  Trackwise  |  Kronos  |  All

OpKey Blog

Troubleshooting connection issue between Oracle Database & OpKey

Radhe Shyam Prajapati 06.07.2018
While connecting OpKey with the Oracle database, located on local or remote machine, OpKey users come across such issues:
System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'Oracle.DataAccess.Client' is already present.
The most common cause of such type of issue is installing or uninstalling of ODAC driver multiple times.
Resolution for the above cause is to remove one row from machine.config file of Microsoft.Net folder.
The machine.config file can be found at the following path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
The row to be deleted is given below: 
"<add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342" />
Check before row deletion: Please check that the row with the above given value exists twice in the machine.config file. Now remove the last row with these values.

Tutorial Video:


Recent Posts

This site use Cookies to deliver our Service. By using this site you acknowledge that you have read and accepted Our Privacy and Cookie Policy. Your interest in OpKey or use of its free trial or purchase of a subscription package is subject to these Terms and Policies