ODAC 11.2 Release 3 (11.2.0.2.1) with Xcopy Deployment


myObjectiveOLAP 2010 (V2.2) only supports Version: 2.112.2.0 of Oracle.DataAccess.dll

You must ensure you have the correct version installed on your computer, otherwise you will get an "Oracle.DataAccess TYPE Error" when trying to use myObjectiveOLAP functions.


Getting Oracle Data Provider for .NET 2.0

To get the latest version of the Oracle Data Provider for .NET 2.0 you can Google:


“oracle odac 11g xcopy download”


Alternatively, version 11.2.0.2.1 can be downloaded from this URL:


http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html 

(URL Correct at time of writing)


Preparing to Install


Unzip ODAC112021Xcopy.zip into a temporary directory on the computer you wish to install ODAC and myObjectiveOLAP on, for example:


C:\ODAC112021Xcopy

               

Install the Oracle Data Provider for .NET 2.0 to a directory on your PC. In this example we will install ODAC to c:\oracleOdac


We will install Oracle Data Provider for .NET 2.0 so that we can see any information returned from the install.bat program


Windows start [Menu Button]↑ → Run → cmd.exe Press [OK]


Hint

On Windows 7 right click on cmd.exe and press Run as Administrator.  Enter your Admin Credentials.


Change the directory to your temporary directory


cd \ODAC112021Xcopy


[where ODAC112021Xcopy is your temporary staging directory] Press [Enter key]



Enter the following command, changing the location of your temporary directory and where you wish to install Oracle Data Provider for .NET 2.0 as appropriate.


install.bat odp.net20 c:\oracleOdac odac


Command

Explanation

Install.bat

This is the install executable made available by Oracle

odp.net20

This is the ODAC component we want to install

C:\oracleOdac

This is the directory we want to install ODAC into.

Odac

This is the Oracle_Home name we are giving our install


Press [Enter]



When the command line returns Oracle Data Provider for .NET 2.0 will have been installed.