Database.ca SQL Server Blog

My Blog

Sunday, March 23 2014

Keywords: Oracle, .NET drivers, ODP, ODTwithODAC, Oracle 11g, Oracle 12g, Oracle 12c, ODP.NET, Oracle Data Provider for .NET

ODP.NET managed Oracle Data Provider for .NET for Oracle 11g or Oracle 12c

A common question I receive is how do I install Oracle Data Provider for .NET, otherwise known as ODP.NET managed .NET drivers for Oracle 11g or 12c?

 

A) 11g
 
To get ODP.net installed on your workstation in order to connect to Oracle 11g servers, there are various ways, amongst the best methods are:
 
1) Get the newest (11.2.0.4 at this time) oracle client driver setup, and install it opting either for 'Administrator' option, or 'Custom' and choose ODP.NET from the list of choices later on.
 
2) Install ODTwithODAC121012, it's backward compatible with 11g. I am using this to connect and debug 11g as well as 12c databases.
 
3) Install ODTwithODAC1120320, and then you might need to run some patches. I prefer to install 11.2.0.4 and no patch, by doing step #1 above.

 

Oracle, .NET drivers, ODP, ODTwithODAC, Oracle 11g, Oracle 12g, Oracle 12c, ODP.NET, Oracle Data Provider for .NET

B) 12c
 
To get ODP.net installed on your workstation in order to connect to Oracle 12c servers, there are various ways, amongst the best methods are:
 
1) Get the newest 12c oracle client driver setup, and install it opting either for 'Administrator' option, or 'Custom' and choose ODP.NET from the list of choices later on.
 
2) Install ODTwithODAC121012.

 

Oracle, .NET drivers, ODP, ODTwithODAC, Oracle 11g, Oracle 12g, Oracle 12c, ODP.NET, Oracle Data Provider for .NET

C) Registry verification
 
You could also verify if a machine has ODP.Net drivers installed on it or not, and if so what versions... by verifying the registry.
 
On a 32bit OS verify this path:
HKEY_LOCAL_MACHINE\Software\Oracle\ODP.NET\[version]
 
On a 64bit OS verify this path:
HKEY_LOCAL_MACHINE\Software\WOW6432node\Oracle\ODP.NET\[version]

 

Oracle, .NET drivers, ODP, ODTwithODAC, Oracle 11g, Oracle 12g, Oracle 12c, ODP.NET, Oracle Data Provider for .NET

D) Download
 
To download ODTwithODAC, I navigated to the official Oracle website where I was required to login or create a free account first. You could download these files and more from the official oracle site.

 

E) Recommendation
 
In conclusion, I would recommend installing ODTwithODAC121012, it works with 12c servers, but it is also backward compatible with 11g. With one setup you get to work with both database versions, so making this the preferred way to get Oracle Data Provider for .NET.

 

 

 

 

 

Written by Ramin Haghighat