Last post Aug 11, 2014 05:46 PM by Lannie
Aug 11, 2014 08:40 AM|PC king|LINK
Anyone can help in interacting with Oracle 64Bit Client using System.Data.Oracle Library with .NET Framework 4.0.
I have to install Oracle Client 32Bit instead. this made me concede on 64bit performance.
Aug 11, 2014 09:00 AM|PatriceSc|LINK
http://stackoverflow.com/questions/8433803/system-data-oracleclient-with-32-bits-oracle-client-driver-on-seven-64-bits-oper it seems ODP.NET is preferred.
For now my understanding is that System.Data.OracleClient has no 64 bit version available...
Aug 11, 2014 09:06 AM|PC king|LINK
I can't find any reliable document or resource that explain how to install and use ODP.NET.
Oracle provide some installation guide I followed it but nothing work with me. although I'm using Visual Studio 2012.
Is there anyway to avoid this problem and work on Oracle 64-bit
Aug 11, 2014 05:46 PM|Lannie|LINK
Do not use System.Data.Oracle.. it is deprecated
To work with 64-bit AND VS 2012, install
64-bit ODAC 12c Release 2 (22.214.171.124.2) for Windows x64
[Released December 20, 2013]
ODAC121012_x64.zip - 282 MB (296,131,056 bytes)
Uninstall all previous Oracle component installations to include removing ORACLE Key from Registry HKEY LOCAL MACHINE > SOFTWARE
and any ENVIRONMENT references to Oracle .
Then Install the CLIENT INSTALL of this driver, not DATABASE INSTALL
THis driver can talk to Oracle 12c, 11g, and 10g
The 64-bit Oracle.DataAccess.dll for .NET 4.0 is located in the client installation home directory > ODP.NET > BIN > 4
Copy that dll to the /BIN directory of your application and make a LOCAL reference to it.
Make sure the application is explicitly compiled as X64 and not ANY or X86.