Symptoms
Testing the connection to a new Oracle data source results in an error message. However, using an ADO.net Any Source or the local oracle client via TNS connection succeeds.
Connection Failed. System error description:
The type initializer for 'Oracle.DataAccess.Client.OracleConnectionStringBuilder' threw an exception.
Cause
There may be a conflict between Oracle Native Client and Oracle Data Provider
Resolution
Remove the Oracle Native Client and install only the Oracle Data Provider according to the instructions provided in the below article