0

I am trying to install Oracle Developer Tools for Visual Studio 2015 so that I can connect to a remote 11g database from SSRS/Visual Studio Projects in general, from my dev machine. When I go to the downloads page, I see this:

enter image description here

So I went to Visual Studio to determine whether I already had ODT, and found this: enter image description here

However, I don't think I installed this ODP, and it just came with the Visual Studio installation. Is there a way to uninstall this provider, or am I OK to just install the new ODT over top? Lastly, as I did more research for this post I became a little more unsure: does ODAC include ODP.net?

Thanks.

element_j
  • 103
  • 1
  • 1
  • 15

1 Answers1

1

Microsoft OLE DB Provider for Oracle and .NET Framework Data Provider for Oracle are providers from Microsoft, i.e. they are part of your Windows installation.

Indeed, they are deprecated from many years, however there is no reason to remove them. They are just two little DLL's.

It is no problem to install Oracle Provider for OLE DB and Oracle Data Provider for .NET (ODP.NET) from Oracle, the drivers from Oracle and the drivers from Microsoft do not interfere with each other.

Yes, ODAC (Oracle Data Access Components) is a collection of various drivers, ODP.NET, OLE DB, ODBC and a few more.

Just a note, unless you use the ODP.NET Managed Driver all drivers mentioned above require an Oracle Client installation, typically an Oracle Instant Client. I think the Oracle Instant Client is also included in the ODAC package.

Maybe have a look at this post to get a little overview: How to connect to Oracle 11 database from . net

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110
  • Thanks, this is also what I found myself through lots of googling; good to see you confirm it! (As a side note I recognize your name on some previous posts). I did install the ODTwithODAC from this [link](http://www.oracle.com/technetwork/topics/dotnet/whatsnew/vs2012welcome-1835382.html) directly over the existing implementation (I even had other clients actually), and it worked. – element_j Mar 13 '18 at 20:30
  • I have a very obscure follow-up, which I will probably make a new question for, but have do you know anything of this issue "https://www.databaseusers.com/article/6268815/NA.+Kerberos5%3A+Authentication+Handshake+Failure"? – element_j Mar 13 '18 at 20:30
  • 1
    I never worked with Kerberos, maybe check also http://docs.oracle.com/cd/E56485_01/win.121/e55744/featConnecting.htm#ODPNT8270 - but it would be better to open a new question for this. – Wernfried Domscheit Mar 13 '18 at 21:24
  • Thanks, I took a look at the link, but it didn't work. I opened a new question: https://stackoverflow.com/questions/49286732/kerberos-error-when-trying-to-connect-to-remote-oracle-database-using-odp-net – element_j Mar 14 '18 at 20:10