Solved

Where to obtain Oracle Data Provider for .NET 3.5

Posted on 2016-09-24
7
51 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

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.

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
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…

813 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

15 Experts available now in Live!

Get 1:1 Help Now