5 Replies Latest reply on Aug 16, 2014 3:49 PM by Alex Keh - Product Manager-Oracle

Managed ODAC.NET

2733539 Aug 15, 2014 2:04 PM

I tried to get the oracle ODBC driver working with my application and had major issues with the x64 driver and after working with the 32 bit driver I discovered more the same. So I am looking into writing a native link in my C# .net application.

My application is compiling in "Any CPU" and I do not want to change that because of other bigger issues I'll have.

My understanding with the issues on the x64 code was that numbers were being returned with a much bigger precision than what can be handled. Will I still have these issues using the x64 ODAC.NET?

I downloaded the 32bit ODAC.net for visual studio but when I add the reference to the library I get a processor mismatch error. I found a post on here referring to using the managed odac.net but no link was provided so I did a search and found this:

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

But when I click on download the latest odp.net I get a list of the same downloads I saw before:

http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html

What is the path I need to pursue to link your dll into my app and will I still have issues with x64 as I did with the ODBC driver?

Honestly, with all the libraries I use this one seems to be the worst for compatibility and confusion. As a developer I shouldn't have to worry about making "work-arounds" for your library to use it. I should just be able to link and code...

Thanks for your help!

1. Re: Managed ODAC.NET

Alex Keh - Product Manager-Oracle Aug 15, 2014 6:14 PM (in response to 2733539)

If you installed the 32-bit ODAC release 12.1 version, the managed ODP.NET will be available. You can use that to avoid all possible conflicts with 32-bit and x64 version. When you add a reference, look for Oracle.ManagedDataAccess.dll. That's the one to use.
Like Show 0 Likes(0)

Actions
2. Re: Managed ODAC.NET

2733539 Aug 15, 2014 9:10 PM (in response to Alex Keh - Product Manager-Oracle)

So will that actually be using the 32bit ODAC in the 64bit app so I don't have to worry about the number precision?

Also, will just that dll be enough to ship with my package to make connections to oracle or will they have to install the odac client for it to work?
Like Show 0 Likes(0)

Actions
3. Re: Managed ODAC.NET

Alex Keh - Product Manager-Oracle Aug 15, 2014 9:53 PM (in response to 2733539)

With respect to number precision, I assume you are referring to Oracle NUMBER data types that can store 38 significant digits. That "issue" will always exist since that is a fundamental difference between Oracle NUMBER and .NET Decimal.

In the end, you will be using ODP.NET, Managed Driver with your 64-bit app. You can't actually use any other part of 32-bit ODAC with your 64-bit app due to the bitness difference, but you can use managed ODP.NET with it.

Managed ODP.NET does not require the Oracle Client. The 2MB ODP.NET, Managed Driver download is all you need to connect to Oracle DB from .NET.
Like Show 0 Likes(0)

Actions
4. Re: Managed ODAC.NET

2733539 Aug 16, 2014 12:19 AM (in response to Alex Keh - Product Manager-Oracle)

So when I deploy the app, the DLL that gets packaged with it will not be enough; they will have to download the odp.net managed driver?
Like Show 0 Likes(0)

Actions
5. Re: Managed ODAC.NET

Alex Keh - Product Manager-Oracle Aug 16, 2014 3:49 PM (in response to 2733539)

If you use distributed transactions, there's a second DLL to include and a transaction recovery service to install. If you don't need distributed transactions, then the single managed ODP.NET DLL is enough. That single DLL is the managed driver.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.