C# Programming
04-09-2009, 02:40 PM
hello
Trying to switch my project over from "System.Data.OracleClient" to ODP.NET "Oracle.DataAccess.Client". It failed from get go (see this article from Oracle http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html[^ (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)]):
DbProviderFactory oDbFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
(As in article from Oracle: ) (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)[^ (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)]
Keep getting System.Configuration.ConfigurationErrorsException saying:
"Failed to find or load the registered .Net Framework Data Provider."
I checked my assembly cache it's there and also referenced in my machine.config (yes I have to add them myself):
D:\Program Files\Microsoft Visual Studio 9.0\VC>gacutil /l | findstr Oracle
System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77
a5c561934e089, processorArchitecture=x86
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec
23701, processorArchitecture=MSIL
...
See, I'm sure the assembly has been installed and in machine.config I used the right key/version. Weird thing is, Red Gate's reflector won't allow me to "Open" (from Cache) the dll, this prevented me to check if there exists "Oracle.DataAccess.Client.OracleClientFactory" within the assembly. So I select "Copy Local" and examined the dll from "Red Gates Reflector". There's no "Oracle.DataAccess.Client.OracleClientFactory" in the dll ???
See here for a Reflector screencap if you don't believe it: http://www.codeguru.com/forum/showthread.php?p=1831221#post1831221[^ (http://www.codeguru.com/forum/showthread.php?p=1831221#post1831221)]
Reflector can be downloaded here: http://www.red-gate.com/products/reflector/[^ (http://www.red-gate.com/products/reflector/)]
modified on Thursday, April 9, 2009 6:32 AM
Trying to switch my project over from "System.Data.OracleClient" to ODP.NET "Oracle.DataAccess.Client". It failed from get go (see this article from Oracle http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html[^ (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)]):
DbProviderFactory oDbFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
(As in article from Oracle: ) (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)[^ (http://www.oracle.com/technology/oramag/oracle/06-winsupp/win06odp.html)]
Keep getting System.Configuration.ConfigurationErrorsException saying:
"Failed to find or load the registered .Net Framework Data Provider."
I checked my assembly cache it's there and also referenced in my machine.config (yes I have to add them myself):
D:\Program Files\Microsoft Visual Studio 9.0\VC>gacutil /l | findstr Oracle
System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77
a5c561934e089, processorArchitecture=x86
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec
23701, processorArchitecture=MSIL
...
See, I'm sure the assembly has been installed and in machine.config I used the right key/version. Weird thing is, Red Gate's reflector won't allow me to "Open" (from Cache) the dll, this prevented me to check if there exists "Oracle.DataAccess.Client.OracleClientFactory" within the assembly. So I select "Copy Local" and examined the dll from "Red Gates Reflector". There's no "Oracle.DataAccess.Client.OracleClientFactory" in the dll ???
See here for a Reflector screencap if you don't believe it: http://www.codeguru.com/forum/showthread.php?p=1831221#post1831221[^ (http://www.codeguru.com/forum/showthread.php?p=1831221#post1831221)]
Reflector can be downloaded here: http://www.red-gate.com/products/reflector/[^ (http://www.red-gate.com/products/reflector/)]
modified on Thursday, April 9, 2009 6:32 AM