Solved

Where to obtain Oracle Data Provider for .NET 3.5

Posted on 2016-09-24
7
47 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
  • 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now