Solved

Where to obtain Oracle Data Provider for .NET 3.5

Posted on 2016-09-24
7
59 Views
Last Modified: 2016-09-24
Does anyone know where to obtain (please provide a specific link) the Oracle Data Provider for .NET 3.5 ? If it matters I am using Microsoft Visual Studio 2008 (I know its getting old). The Oracle DB I am trying to access is Oracle Database Enterprise Edition 11g release 2 (11.2.0.1) and the oracle client I have installed is the same version. If possible, or available, I would like both the 32bit and 64bit versions.
0
Comment
Question by:exptech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 41813736
0
 

Author Comment

by:exptech
ID: 41813756
Thanks ste5am,

Do you know if you can use the latest version with 11g R2 or do you have to match the versions. In other words is it backward compatible.  In addition I do not see .NET 3.5 listed. This is what it states:

       Oracle Data Provider for .NET 4 12.1.0.2.0
              Oracle Data Provider for .NET 2.0 12.1.0.2.0
              Oracle Providers for ASP.NET 4 12.1.0.2.0
              Oracle Providers for ASP.NET 2.0 12.1.0.2.0
0
 
LVL 33

Expert Comment

by:ste5an
ID: 41813783
It should be compatible. When you load it by nuget, you'll get the necessary version.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:exptech
ID: 41813815
Unfortunately I don't see a version of nuget for VS 2008. I will look closer at the oracle downloads and let you know.
0
 
LVL 21

Expert Comment

by:Tapan Pattanaik
ID: 41813878
Hi exptech,

You have to choose Oracle Data Provider for .NET 2.0 12.1.0.2.0 for  .NET 3.5

 http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

The version number of the .NET Framework doesn't necessarily correspond to the version number of the CLR it includes. Please check the below link.

Note: https://msdn.microsoft.com/en-us/library/8bs2ecf4(v=vs.110).aspx
For .NET Framework version 3.5 is CLR Version is 2.0

Regards,
Tapan Pattaniak.
0
 

Author Closing Comment

by:exptech
ID: 41813886
Thanks ste5an,

I found the downloads I needed plus a wealth of information in using Oracle with Visual Studio. I have done Oracle work in the past using the .Net DAC but the oracle providers are being depreciated and ever since we upgraded our Oracle DB we were having strange problems with the MS Data providers, not to mention they were not really optimized the way the oracle providers are.
0
 

Author Comment

by:exptech
ID: 41813887
Sorry Tapan,

I was closing the question while you were posting or I would have given you the assisted solution.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question