Solved

Where to obtain Oracle Data Provider for .NET 3.5

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

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 34

Expert Comment

by:ste5an
ID: 41813783
It should be compatible. When you load it by nuget, you'll get the necessary version.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

717 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