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.
There may be a conflict between Oracle Native Client and Oracle Data Provider.
Remove the Oracle Native Client and install only the Oracle Data Provider according to the instructions provided here.
Author: Doug Wynkoop