
- THE ORACLE DATAACCESS CLIENT IS NOT INSTALLED INSTALL
- THE ORACLE DATAACCESS CLIENT IS NOT INSTALLED FULL
This can be accomplished by uninstalling from the Windowsassembly folder by right clicking on the Policy.X.X.Oracle.DataAccess and choosing uninstall, or by using gacutil and issuing C:> gacutil /u Policy.X.X.Oracle. During the first run, deinstall only ODAC components using ODAC OUI. If you are deinstalling other DB components and ODAC components from the same home, you will run a deinstaller twice. Oracle Data Access Components for Oracle Client) from the tree control.
THE ORACLE DATAACCESS CLIENT IS NOT INSTALLED FULL
I suspect the ODAC on its own is not sufficient, I would try installing the full Oracle Client with Admin option first, then adding the ODAC on top. Choose the Oracle Home(s) to deinstall (i.e. I got one machine working using Oracle 11 so Im trying to hold onto that for as long as possible. Ive wasted so much time on it over the years.

Now I get the following exception when attempting to add the Oracle.DataAccess reference, or when attempting to build the solution with the reference included. When installing Oracle Data Access Components (ODAC) in a new Oracle Home, Oracle Universal Installer (OUI) automatically copies the Oracle local naming (tnsnames.ora), profile (sqlnet.ora), and directory (ldap.ora) parameter files and settings from an existing Oracle home into the newly installed ODAC home, as long as they share the same bitness.

This did not solve the issue, so I uninstalled and re-installed Ranorex.
THE ORACLE DATAACCESS CLIENT IS NOT INSTALLED INSTALL
I installed Oracle Data Access Components (ODAC) 11.1.0.6.21 And i added referance odp.net1x\odp.net\bin\1.x\ I am importing the following in my page Imports System.IO Imports System.Configuration Imports My Code is as below = Dim con As OracleConnection = New OracleConnection("server=testdb uid=tuser password=tuser") con.Open() Dim cmd As OracleCommand = New OracleCommand("tuser.XML_SACHIN1", con) cmd.CommandType = CommandType.StoredProcedure Dim p_refcursor As OracleParameter = New OracleParameter p_refcursor.OracleDbType = OracleDbType.RefCursor 'Cursor 'RefCursor p_refcursor.Direction = ParameterDirection.ReturnValue 'ReturnValue (p_refcursor) Dim da As OracleDataAdapter = New OracleDataAdapter(cmd) Dim ds As DataSet = New DataSet da.Fill(ds) ds.Dispose() da.Dispose() cmd.Dispose() My oracle function = CREATE OR REPLACE FUNCTION tuser. Open the nfig file from the pathI am creating one asp.net application in vs2003, and using Oracle 9i functions, refcursor return data. I installed Oracle Data Access Components (ODAC) 11.1.0.6.21 And i added referance .DataAccess.dll I am importing the following in my page Imports System.IO Imports System.
