?
Solved

Where to obtain Oracle Data Provider for .NET 3.5

Posted on 2016-09-24
7
Medium Priority
?
73 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 35

Accepted Solution

by:
ste5an earned 2000 total points
ID: 41813736
0
 
LVL 1

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 35

Expert Comment

by:ste5an
ID: 41813783
It should be compatible. When you load it by nuget, you'll get the necessary version.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 1

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
 
LVL 1

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
 
LVL 1

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

Stack Overflow Podcast - Developer Story

Welcome to the Stack Overflow podcast recorded Thursday July 20 at Stack Overflow Headquearters in NYC. Your hosts today are podcast regulars Jay Hanlon, David Fullerton, and Ilana Yitzhaki, plus the quite irregular Matt Sherman (Stack Overflow Engineering Manager extraordinaire)

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
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…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

752 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