Error: System.ApplicationException: Oracle Import: System.TypeInitializationException when using Oracle connection in Sync & Save.
The Oracle client software must be installed before connecting to an Oracle database. To install the Oracle client, follow one of the two approaches:
1. Copy the required Oracle client files to your machine:
Go to http://www.oracle.com/technetwork/database/windows/downloads/index.html. Download the correct version of ODAC with XCopy Deployment.
Unzip the file and copy the following files to the install folder of Sync & Save.
ODAC1120320Xcopy_32bit\instantclient_11_2\oci.dll
ODAC1120320Xcopy_32bit\instantclient_11_2\orannzsbb11.dll
ODAC1120320Xcopy_32bit\instantclient_11_2\oraocci11.dll
ODAC1120320Xcopy_32bit\instantclient_11_2\ociw32.dll
ODAC1120320Xcopy_32bit\instantclient_11_2\oraociei11.dll
ODAC1120320Xcopy_32bit\odp.net4\bin\OraOps11w.dll
ODAC1120320Xcopy_32bit\odp.net4\odp.net\bin\4\Oracle.DataAccess.dll
2. Install the Oracle Data Access Components for Oracle Client:
Go to http://www.oracle.com/technetwork/database/windows/downloads/index.html. Download the correct version of ODAC with Oracle Developer Tools of Visual Studio and run the setup.exe.
In the Oracle Universal Installer, choose the Oracle Data Provider for .Net 11.2.0.3.0 and any required components. Note that this installer is much larger than option 1.