Last post Jun 26, 2013 06:13 PM by Lannie
Jun 24, 2013 03:38 PM|nvielbig|LINK
Today I had to reinstall my Visual Studio 2012 unfortunately, and after doing so my ODAC has sort of been 'broken' in the midst of this install. It is a very simple oracle access for my project, but for some reason the project is saying ODAC is not installed
when I try to visit the page that utilizes the ODAC. When I look in my solution, reference for ODAC is present ("Oracle.DataAccess"), my web.config file contains all of the ConnectionString information that it did prior to the reinstallation. This is why I
am confused. It appears that the necessary stuff for ODAC "is there", but according to VS2012... it's not. What would you suggest to me for my issue. Error below that I am receiving when I try to visit the page utilizing the ODAC.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
Thank you very much,
Jun 24, 2013 08:42 PM|Lannie|LINK
Try puting your oracle.dataaccess.dll in your application /BIN folder, and make a LOCAL reference to it.
Jun 25, 2013 09:11 AM|nvielbig|LINK
I want to say I am already doing so. oracle.dataaccess.dll is in my /bin folder, could you give me an example of a local reference to the .dll? Not sure if I am doing that or not at the moment.
Jun 25, 2013 09:28 AM|nvielbig|LINK
For reference as to what I have done so far . . . :
1. I checked to make sure that the ODAC 2.x (for my x86 dev machine) was installed. When I tried to run the install, it said there was already an Oracle base present, so I believe that is all configured.
2. my page utilizing ODAC has a
at the top of it.
3. My web.config has
4. The location of my Oracle.DataAccess.Client 4.0 reference is
C:\Users\name\Documents\Visual Studio 2012\Projects\ProjName\Project\packages\odp.net.x126.96.36.199\lib\net40\Oracle.DataAccess.dll
Thanks for any help.
Jun 26, 2013 06:13 PM|Lannie|LINK
I am migrating out of the quirky, version sensitive unmanged ODP.NET into the MANAGED ODP.NET
Drop in the client and the tnsnames.ora, make reference, change import/using statements, recompile and you are in business.
I just converted an app today in 5 minutes.
dll is in the XCOPY extract and look in COMMON folder for single DLL that works in both 32-bit and 64-bit
watch quick start video
updated ODP.NET developer guide discusses new managed driver as well.
Now, some functions are not yet supported, but for average ODP.NET work like executing statements, calling refcursor, etc. It Works.
BYE BYE GAC headaches.