I am developing custom geoprocessing tool (class-library project) on ArcGIS 10.2. This project uses Oracle.DatAccess from ODP.NET 1.0 . This is a simple tool which queries - oracle 10g database and returns a distinct records from a specific table.
This tool is working fine from tool box but when this tool is published in REST, it throws below error:
Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception
ArcGIS server 10.2, Visual Studio 2012.
Server: Windows 2012 -6bit Operating system
Oracle client : installed both oracle 32 and oracle 64 bit (C:\oracle\product\10.2.0\Client_32,C:\oracle\product\10.2.0\Client_64)
Any pointer on this issue?
To begin with, this custom GP tool project was working in ArcGIS 10.0 for last 2 years successfully. As part of technology migration activity, I am upgrading this project to 10.2. As mentioned, am using Windows 2012 server (64 bit OS) where ArcGIS Desktop and ArcGIS server 10.2 has been installed in same box. Oracle client 32, 64 bit has been installed. Path is set as above.