topic Re: Connecting to Oracle Database without Oracle Client in Data Management Questions

Connecting to Oracle Database without Oracle Client

LakshmananVenkatesan — Thu, 01 May 2014 19:59:24 GMT

Hi:

I would like to know the other options to connect oracle database (10g) without using oracle client. At present we are using ODP.NET (Oracle.DataAccess.dll) to connect to oracle to fetch/insert/update. I don't want to use oracle libraries any more because of oracle
32 /64 bit issues in 10.2. Please provide me other list of options.

Please throw some light on this.

Re: Connecting to Oracle Database without Oracle Client

WilliamCraft — Thu, 01 May 2014 20:01:59 GMT

I don't want to use oracle libraries any more because of oracle
32 /64 bit issues in 10.2.

Just curious, what 32/64 bit issues are you referring to with 10.2?

Re: Connecting to Oracle Database without Oracle Client

LakshmananVenkatesan — Thu, 01 May 2014 20:16:54 GMT

Here is the orginal problem http://forums.arcgis.com/threads/105848-Error-The-type-initializer-for-Oracle.DataAccess.Client.OracleConnection-thrown?p=377520#post377520

I dont want to go into this again, because I would like to find alternative way to connect to database instead of oracle.dataaccess
libraries

Re: Connecting to Oracle Database without Oracle Client

VinceAngelo — Thu, 01 May 2014 22:21:35 GMT

You can't connect to an Oracle database without Oracle libraries. The closest you can come is using an ArcSDE application server connection, but that is deprecated. Far better to learn how to use Instant Client and move on. - V

Re: Connecting to Oracle Database without Oracle Client

LakshmananVenkatesan — Fri, 02 May 2014 02:36:18 GMT

Vince,

Thanks for your reply. Does instant client work in both 32bit and 64 bit? .I want to connect to oracle using .NET (programmetically) in custom Geoprocessing tool which is registered with ArcGIS 10.2 (32bit) and ArcGIS server 10.2 which is 64bit.
When I use Oracle.DataAccess.dll there is an compatibility issue between ArcGIS desktop, Server and Oracle libaries. Please throw some light on this. Thanks again.

Re: Connecting to Oracle Database without Oracle Client

VinceAngelo — Fri, 02 May 2014 09:45:45 GMT

Direct Connect works with both 32-bit and 64-bit if you follow Oracle's instructions to place the 64-bit client in the PATH first. If you aren't connecting to a geodatabase, then you should really be asking this question in an oracle.com forum. -V