Installing Oracle Data Access Components (ODAC) ODP.NET
In the past, Microsoft has provided their own Oracle classes with: System.Data.OracleClient
But with .NET framework 4.0, Microsoft will apparently be deprecating the use of System.Data.OracleClient. See this article on Microsoft Kills Its Oracle Data Provider for ADO.NET.I've been using the Oracle Data Access Components (ODAC) for several years and will provide some information on downloading and installing Oracle's Data Provider.
First, download the ODAC at Oracle's Oracle Data Access Components Download page. (Optionally, visit Oracle's .NET page for the latest news on support for .NET.)Find your appropriate ODAC download on the Oracle Data Access Components page.
Select the executable to install it, for instance:
ODAC1020221.exeThen go to the install directory and run setup.exe
Within your Visual Studio project, right click your web site within Solution Explorer and select to Add Reference. Find the installed component within a directory similar to this:
C:\oracle\product\10.2.0\client_1\ODP.NET\bin\2.x
Make sure ODAC is also installed on the web server that is hosting the application.
May your dreams be in ASP.NET!
Nannette Thacker
