Do I have to uninstall oracle unmanaged dataAccess (Oracle.DataAccess) before installing managed ManagedDataAccess (Oracle.ManagedDataAccess)
odp.net-managed, oracle, visual-studio-2012
Solution
New Oracle.ManagedDataAccess.dll is a magnificent thing. Just do this: 1. Delete existing reference to Oracle.DataAccess from your project and add a new Oracle.ManagedDataAccess.dll from the downloaded folder: odp.net\managed\common\Oracle.ManagedDataAccess.dll. 2. Set it's property Copy Local = True so it will be deployed along with your project. 3. Don't forget to add a new "using" line to your code: using Oracle.ManagedDataAccess.Client; 4. You can change the project platform target to AnyCPU now and it will work !
There's no need to install anything more, no other clients, this is some kind of oracle's packed crossplatform (64-bit and 32-bit) dll client which worked perfectly for me after all those spended hours before figuring out which dll-s (oci.dll, orannzsbb11.dll, oraociei11.dll, OraOps11w.dll) need to go in with the project for 64-bit machine and 32-bit machine fo my application to work...
Problem
I am planning to move from oracle unmanaged data access client to managed data access client. Right now I have ODP.Net installed on my machine which contains the DLL - Oracle.DataAccess.dll. But I am planning to move to oracle's recently released Managed data access client which contains the assembly Oracle.ManagedDataAccess.dll. Do I have to un-install the previously installed ODP.Net (unmanaged one) and then install the managed client? I have seen the installation instructions but I am not sure if this step will be required. Any help will be highly appreciated.