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.
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.
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.
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.
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]
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]
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.
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.
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
Fonte: DataBase.Ca
http://database.ca/blog.aspx?blogid=4049
Nenhum comentário:
Postar um comentário