topic Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' thrown in ArcGIS Enterprise Questions

Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' thrown

LakshmananVenkatesan — Wed, 02 Apr 2014 16:29:12 GMT

Hi

I am developing custom geoprocessing tool (class-library project) on ArcGIS 10.2. This project uses Oracle.DatAccess from C:\Oracle\product\10.2.0\client_32\ODP.NET\bin\1.x . This is a simple tool which queries oracle 10g database and returns a distinct records from a table. This tool is working fine from tool box but when this tool is published in REST, it throws Oracle type initialize exception on line

Connection = new OracleConnection(constr);

ArcGIS server 10.2, Visual Studio 2012.

Server: Windows 2012 64bit OS

Oracle client : installed both oracle 32 and oracle 64bit (C:\oracle\product\10.2.0\Client_32, C:\oracle\product\10.2.0\Client_64)

PATH: c:\oracle\product\10.2.0\client_64\bin;c:\oracle\product\10.2.0\client_32\bin;

Any clues on this?

Re: Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' thrown

MarcoBoeringa — Fri, 02 May 2014 06:52:36 GMT

In case you wish to try the Oracle Instant Client, instead of Oracle Client, to which Vince referred in the other thread, Richard Watson provided some install instructions in this post:

http://forums.arcgis.com/threads/74635-Is-it-necessary-to-install-the-%E2%80%9CMicrosoft-SQL-server%E2%80%9D-before-installing-the-%E2%80%9CArcSDE%E2%80%9D?p=261569&viewfull=1#post261569

Re: Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' thrown

LakshmananVenkatesan — Mon, 05 May 2014 18:28:17 GMT

Marco

Can you explain difference between Oracle instant client and regular oracle client software which comes with Oracle installer?.
As said, I have installed oracle client (64 and 32bit) and set a PATH variable as ESRI specified. Still am struggling to get the result.