blocks|key|347482|text|IIS/IWAM用户是否具有Oracle目录的权限？是否可以使用其他应用程序连接到此数据源？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|347483|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Does the IIS/IWAM user have permissions on the Oracle directory? Can you connect to this data source using another app, such as Excel or Access?

blocks|key|345260|text|在我看来，尽管您在Oracle+Istant客户端上使用了ODP，但ODP可能正在尝试使用实际的Oracle客户端。您的计算机上是否也安装了标准的Oracle客户端？我记得，当Oracle在同一台机器上使用多个客户端时，它非常挑剔。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|345261|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It would seem to me that though you have ODP with the Oracle Istant Client, the ODP may be trying to use the actual Oracle Client instead. Do you have a standard Oracle client installed on the machine as well? I recall Oracle being quite picky about when it came to multiple clients on the same machine.

blocks|key|347509|text|我只安装了Oracle+Data+Provider+for+.NET+2.0+(11.1.0.6.20)，而没有安装Oracle+Instant+Client+(11.1.0.6.0)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|347510|我只是安装了它，错误就消失了！|347511|entityMap^0|1M|Y|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

I only installed the Oracle Data Provider for .NET 2.0 (11.1.0.6.20) and I did not install the Oracle Instant Client (11.1.0.6.0). 

I just installed it and the error disappeared!

blocks|key|3336186|text|这可能是由于在32位.NET客户端上运行64位Oracle运行时造成的。如果您的服务器上运行的是64位应用程序，则可能会发生这种情况。它将使用64位运行时运行.NET应用程序。您可以在VS中设置项目的CPU标志，使其在32位运行时运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336187|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This can be caused by running a 64bit .NET runtime against a 32bit Oracle client. This can happen if your server you are running the app on it 64 bit. It will run the .NET app with the 64bit runtime. You can set the CPU flag on your project in VS to run in the 32bit runtime.

blocks|key|347528|text|我也遇到了同样的问题。在编译应用程序之后，我删除了oraociei11.dll+(并且忘记我已经删除了)。在尝试执行时，它会出现此错误。所以当它找不到oraociei11.dll的dll时，它会显示这个错误。可能还有其他情况，它会给出这个错误，但这似乎是其中之一。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|347529|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the exact same problem. I deleted (and forgot that I had deleted) oraociei11.dll after compiling the application. And it was giving this error while trying to execute. So when it cant find the dll that oraociei11.dll, it shows this error. There may be other cases when it gives this error, but this seems to be one of them.

blocks|key|3123320|text|我已经进一步研究了这个问题，您只需要从相同的下载版本的ODP.Net中获取所有适当的DLL，并将它们放在与您的Exe文件相同的文件夹中，因为ODP.Net对于不混用版本号很挑剔。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123321|我已经在这里解释了如何做到这一点：http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c这里是它的要点：|offset|length|3123322|3123323|Download+ODP.Net|unordered-list-item|3123324|解压文件|3123325|解压其中的所有JAR|3123326|获取刚刚解压的dll:oci.dll(从'ociw32.dll.dbl')|3123327|重命名为|3123328|​|3123329|3123330|将所有all放在与C#可执行|3123331|相同的文件夹中|3123332|entityMap|0|LINK|mutability|MUTABLE|url|http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c^0|0|H|1V|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@$D|18|E|19|1|1A]]|A|$]]|$1|F|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|1C|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|1D|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|1E|8|@]|9|@]|A|$]]|$1|N|3|O|5|I|7|1F|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1G|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1H|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|I|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]]]

I've been looking into this problem further, and you simply need to grab all the appropriate DLL's from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers.

I've explained how to do this here: <a href="http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c" rel="noreferrer">http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c</a>
Here's the gist of it though:

<ul>
<li>Download ODP.Net</li>
<li>Unzip the file</li>
<li>Unzip all the JAR's in it</li>
<li>Grab these dll's that were just unzipped:

<ul>
<li>oci.dll (renamed from 'oci.dll.dbl')</li>
<li>Oracle.DataAccess.dll</li>
<li>oraociicus11.dll</li>
<li>OraOps11w.dll</li>
<li>orannzsbb11.dll</li>
<li>oraocci11.dll</li>
<li>ociw32.dll (renamed from 'ociw32.dll.dbl')</li>
</ul></li>
<li>Put all the DLLs in the same folder as your C# Executable</li>
</ul>

blocks|key|350228|text|在目标机器上安装ODP.Net应该可以解决这个问题...复制dll看起来不是一个好主意...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|350229|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

install ODP.Net on the target machine and it should solve the issue... copying the dll's does not look a good idea...

blocks|key|346691|text|对于Oracle+11g+(11.1.0.7.20)，我必须添加以下dll和我的Exe才能工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|346692|346693|oci.dll|ordered-list-item|346694|OraOps11w.dll|346695|oraociicus11.dll+(在30mb)|346696|Oracle.DataAccess.dll|346697|附近相当庞大|346698|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

For Oracle 11g (11.1.0.7.20) I had to add the following dlls along with my Exe to work.

<ol>
<li>oci.dll</li>
<li>OraOps11w.dll</li>
<li>oraociicus11.dll (pretty huge close to 30mb)</li>
<li>Oracle.DataAccess.dll</li>
</ol>

blocks|key|3123453|text|同时查找IIS应用程序池启用32位真或假标志，当你看到这条消息时，一些oracle论坛指导我这样做！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123454|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Also look for IIS Application pool Enable 32-bit true or false flag, when you see this message, some oracle forum directed me for this!

blocks|key|3123465|text|我们也遇到了同样的问题，因为我们的数据库管理员更新了网络共享上的Oracle.Data.dll程序集，从项目中删除引用并重新添加就解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123466|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

We had the same problem, because the Oracle.Data.dll assembly on a network share was updated by our DBA's. Removing the reference from the project, and adding it again solved the problem.

blocks|key|3336374|text|我也有同样的问题，但在我的例子中，我不能简单地将dll复制到bin文件夹，然后我只能‘重新绑定’程序集版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336375|<?xml+version="1.0"+encoding="utf-8"+?>
<configuration>
++<runtime>++++
++++<assemblyBinding+xmlns="urn:schemas-microsoft-com:asm.v1">
++++++<dependentAssembly>
++++++++<assemblyIdentity+name="Oracle.DataAccess"+publicKeyToken="89B483F429C47342"+culture="neutral"/>
++++++++<bindingRedirect+oldVersion="2.112.2.0"+newVersion="2.112.1.0"/>
++++++</dependentAssembly>
++++</assemblyBinding>
++</runtime>
</configuration>|code-block|syntax|javascript|3336376|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

i have the same problem but in my case i can't just copy the dlls into the bin folder, then i only 'rebind' the assembly version.

<pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;configuration&gt;
 &lt;runtime&gt; 
 &lt;assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"&gt;
 &lt;dependentAssembly&gt;
 &lt;assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342" culture="neutral"/&gt;
 &lt;bindingRedirect oldVersion="2.112.2.0" newVersion="2.112.1.0"/&gt;
 &lt;/dependentAssembly&gt;
 &lt;/assemblyBinding&gt;
 &lt;/runtime&gt;
&lt;/configuration&gt;
</code></pre>

blocks|key|3123495|text|在64位计算机上，将"msvcr71.dll“从C：\Windows\|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123496|64复制到32位计算机的application.|unordered-list-item|3123497|On的bin目录，将"msvcr71.dll”从C:\Windows\System32复制到应用程序的bin目录。|3123498|3123499|http://randomdevtips.blogspot.com/2012/06/provider-is-not-compatible-with-version.html|offset|length|3123500|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|2E|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|U|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@$J|X|K|Y|1|Z]]|A|$]]|$1|L|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|I]]]]

<ul>
<li>On a 64-bit machine, copy "msvcr71.dll" from C:\Windows\SysWOW64 to
the bin directory for your application.</li>
<li>On a 32-bit machine, copy "msvcr71.dll" from C:\Windows\System32 to
the bin directory for your application.</li>
</ul>

<a href="http://randomdevtips.blogspot.com/2012/06/provider-is-not-compatible-with-version.html" rel="nofollow">http://randomdevtips.blogspot.com/2012/06/provider-is-not-compatible-with-version.html</a>

blocks|key|3336405|text|只需两个步骤即可解决此问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336406|3336407|转到应用程序池的高级设置，并将‘启用32位应用程序’标志设置为True。|ordered-list-item|3336408|确保您的存储库中的所有Dlls现在都是32位版本...|3336409|3336410|祝你好运。|3336411|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|P|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|L|$]]

Just two steps to solve this issue.

<ol>
<li>go to advance setting of application pool and set 'Enable 32 bit Application' flag to True.</li>
<li>Make sure all Dlls in your Bin is 32 bit version now...</li>
</ol>

best of luck.

blocks|key|345395|text|最近，我不得不在一个较旧的项目中工作，该项目的解决方案和所有包含的项目都针对x32平台。我一直在尝试在所有地方复制Oracle.DataAccess.dll和所有其他建议的甲骨文文件，但每次都遇到困难。最后，头部的灯泡亮起(8小时后：)，并要求检查已安装的ODAC程序集及其平台。我已经安装了所有的64位(x64)+ODAC客户机，但还没有安装32位的(x32)。已安装32位ODAC，问题消失。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|345396|如何检查已安装的ODAC的版本:在文件夹C:\Windows\assembly中查找。"Processor+Architecture“属性将通知平台已安装的ODAC。|345397|八个小时对灯泡来说是一段很长的时间。难怪我总是要在工作中吃力:)。|345398|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Recently I had to work on an older project where the solution and all contained projects were targeted to x32 platform. I kept on trying to copy Oracle.DataAccess.dll and all other suggested Oracle files on all the places, but hit the wall every time. Finally the bulb in the head lit up (after 8 hours :)), and asked to check for the installed ODAC assemblies and their platform. I had all the 64-bit (x64) ODAC clients installed already but not the 32 bit ones (x32). Installed the 32-bit ODAC and the problem disappeared.

How to check the version of installed ODAC: Look in folder C:\Windows\assembly. The "Processor Architecture" property will inform the platform of installed ODAC.

Eight hours is a long time for the bulb to light up. No wonder I always have to slog at work :).

blocks|key|3336465|text|以下是我为解决这个持续了3个小时的问题所做的工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336466|3336467|位于C:\oracle\product\11.2.0的Oracle主目录下我有一个名为client_1的文件夹，之前我在这个文件夹中安装了Windows64位的ODP.NET位。|ordered-list-item|offset|length|style|CODE|3336468|后来在尝试使用Visual+Studio2012调试我的ASP.NET+Web+API应用程序时，我不断收到这样的错误消息：+provider与Oracle+Google的版本不兼容我发现发生这种情况是因为我使用的是ODP.NET+64位。然后我抓取了Windows32位的ODP.NET并安装了它，但是我一直收到相同的错误信息，删除了文件夹client_1并重新安装了32位的ODP.NET。在某种程度上，安装程序混合了来自64位版本和32位版本的位。Go+figure...|BOLD|3336469|Now我又高兴了，我可以开一个新的OracleConnection了。最后！:)|3336470|3336471|entityMap^0|0|0|2|O|17|8|28|7|0|1Q|4X|30|7|3T|7|4R|8|59|7|0|0|14|H|G|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@$F|U|G|V|H|I]|$F|W|G|X|H|I]|$F|Y|G|Z|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|10|8|@$F|11|G|12|H|L]|$F|13|G|14|H|I]|$F|15|G|16|H|I]|$F|17|G|18|H|I]|$F|19|G|1A|H|I]]|9|@]|A|$]]|$1|M|3|N|5|E|7|1B|8|@$F|1C|G|1D|H|L]|$F|1E|G|1F|H|I]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|Q|$]]

Here's what I did to solve this problem that persisted for 3 long hours:

<ol>
<li>Under Oracle home located at <code>C:\oracle\product\11.2.0</code> I had a folder called <code>client_1</code> where I had previously installed <code>ODP.NET</code> bits for Windows 64 bits.</li>
<li>Later while trying to debug my ASP.NET Web API app with Visual Studio 2012, I kept getting this error message: The provider is not compatible with the version of Oracle client.</li>
<li>Searching Google I found that this was happening because I was using <code>ODP.NET</code> 64 bits. Then I grabbed <code>ODP.NET</code> for Windows 32 bits and installed it but I kept getting the same error message.</li>
<li>SOLUTION: deleted the folder <code>client_1</code> and resinstalled <code>ODP.NET</code> 32 bits. Somewhat the installer was mixing bits from the 64 bit version with the 32 bit version. Go figure...</li>
<li>Now I'm happy again and I can open a new <code>OracleConnection</code>. FINALLY! :)</li>
</ol>

blocks|key|3336517|text|对于初学者，您应该“忽略”这里的所有x86/x64对话，而不是尝试ODP.NET托管驱动程序(如果您使用的是.Net+v4%2B)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336518|https://www.nuget.org/packages/Oracle.ManagedDataAccess/|offset|length|3336519|https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/|3336520|Oracle+ODP.net+Managed+vs+Unmanaged+Driver|3336521|避免所有的“非托管”什么DLL什么架构问题！:D+(关于时间Oracle)。|3336522|+NuGet包(也适用于11g):|style|BOLD|3336523|​|3336524|📷|atomic|3336525|3336526|旧的/手动方法：|3336527|有关如何转换为使用托管库的信息：|3336528|首先，这里是托管和非托管的很好的代码比较：http://docs.oracle.com/cd/E51173_01/win.122/e17732/intro005.htm#ODPNT148|3336529|Ensure您已经下载了ODP.NET，托管驱动程序Xcopy+|unordered-list-item|3336530|
|3336531|从下载的压缩文件，复制并粘贴到您的项目目录中：|3336532|Oracle.ManagedDataAccessDTC.dll|3336533|Oracle.ManagedDataAccess.dll|3336534|3336535|3336536|3336537|应用程序添加对Oracle.ManagedDataAccess.dll|3336538|Ensure的引用您的可执行文件已随两个dlls|3336539|
一起释放(添加到VS2010中的应用程序文件夹)|3336540|entityMap|0|LINK|mutability|MUTABLE|url|1|2|https://stackoverflow.com/questions/17583289/oracle-odp-net-managed-vs-unmanaged-driver|3|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/2092e725bc2f7eaf6db4aafa019f0fd0.png|imageAlt|4|http://docs.oracle.com/cd/E51173_01/win.122/e17732/intro005.htm#ODPNT148^0|0|0|1K|0|0|0|20|1|0|0|16|2|0|0|0|H|0|0|0|1|3|0|0|0|8|0|0|L|20|4|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|23|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|24|8|@]|9|@$D|25|E|26|1|27]]|A|$]]|$1|F|3|G|5|6|7|28|8|@]|9|@$D|29|E|2A|1|2B]]|A|$]]|$1|H|3|I|5|6|7|2C|8|@]|9|@$D|2D|E|2E|1|2F]]|A|$]]|$1|J|3|K|5|6|7|2G|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|2H|8|@$D|2I|E|2J|N|O]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|2K|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|2L|8|@]|9|@$D|2M|E|2N|1|2O]]|A|$]]|$1|U|3|Q|5|6|7|2P|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|2Q|8|@$D|2R|E|2S|N|O]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|2T|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|2U|8|@]|9|@$D|2V|E|2W|1|2X]]|A|$]]|$1|11|3|12|5|13|7|2Y|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2Z|8|@]|9|@]|A|$]]|$1|16|3|17|5|13|7|30|8|@]|9|@]|A|$]]|$1|18|3|19|5|13|7|31|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|13|7|32|8|@]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|33|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|34|8|@]|9|@]|A|$]]|$1|1E|3|Q|5|6|7|35|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|6|7|36|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|13|7|37|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|6|7|38|8|@]|9|@]|A|$]]|$1|1L|3|-4|5|6|7|39|8|@]|9|@]|A|$]]]|1M|$1N|$5|1O|1P|1Q|A|$1R|C]]|1S|$5|1O|1P|1Q|A|$1R|G]]|1T|$5|1O|1P|1Q|A|$1R|1U]]|1V|$5|1W|1P|1X|A|$1Y|1Z|20|-4]]|21|$5|1O|1P|1Q|A|$1R|22]]]]

You should "ignore" all the x86/x64 talk here for starters and instead try the ODP.NET Managed Driver (if you are using .Net v4+):

<a href="https://www.nuget.org/packages/Oracle.ManagedDataAccess/" rel="noreferrer">https://www.nuget.org/packages/Oracle.ManagedDataAccess/</a>

<a href="https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/" rel="noreferrer">https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/</a>

<a href="https://stackoverflow.com/questions/17583289/oracle-odp-net-managed-vs-unmanaged-driver">Oracle ODP.net Managed vs Unmanaged Driver</a>

Avoid all the "unmanaged" what DLL what architecture issues! :D (about time Oracle).

The NuGet package (also works for 11g):

<a href="https://i.stack.imgur.com/i7l0w.png" rel="noreferrer"><img src="https://i.stack.imgur.com/i7l0w.png" alt="enter image description here"></a>

The old / manual method:

For info on how to convert to using the managed libraries:

<ul>
<li>First, here is a great code comparison of managed vs unmanaged: <a href="http://docs.oracle.com/cd/E51173_01/win.122/e17732/intro005.htm#ODPNT148" rel="noreferrer">http://docs.oracle.com/cd/E51173_01/win.122/e17732/intro005.htm#ODPNT148</a></li>
<li>Ensure you have downloaded the ODP.NET, Managed Driver Xcopy version only</li>
<li>From the downloaded zip file, copy and paste into your project directory:

<ul>
<li>Oracle.ManagedDataAccessDTC.dll</li>
<li>Oracle.ManagedDataAccess.dll</li>
</ul></li>
<li>Add a reference to Oracle.ManagedDataAccess.dll</li>
<li>Ensure your exe is released (added to Application Folder in VS2010) with both dlls</li>
</ul>

blocks|key|350350|text|Chris的解决方案也适用于我。但是，我确实收到了以下错误消息，指出：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|350351|Could+not+load+file+or+assembly+'Oracle.DataAccess'+or+one+of+its+dependencies.+An+attempt+was+made+to+load+a+program+with+an+incorrect+format.|code-block|syntax|javascript|350352|显然，在外语Oraclish中，这意味着您的程序要么面向所有平台，要么面向32位计算机。只需在项目属性中将目标平台更改为64位，并希望是最好的。|350353|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Chris' solution worked for me as well. I did however get a follow error message that states: 

<pre><code>Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.
</code></pre>

Apparently, in the foreign language of Oraclish, that means that your program are either targeting all platforms, or 32-bit machines.
Simply change your target platform in Project Properties to 64-bit and hope for the best.

blocks|key|3336573|text|对于仍然有这个问题的人:基于这篇文章|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336574|http://oradim.blogspot.com/2009/09/odpnet-provider-is-not-compatible-with.html|offset|length|3336575|我发现我的服务器缺少Microsoft+Library+--因为安装了C%2B%2B，我把它放在了我的开发机器上。我从这里下载并安装了(当前)最新版本的库：|3336576|http://www.microsoft.com/en-us/download/details.aspx?id=13523|3336577|运行设置，来自C#的oracle调用成功了！|3336578|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|26|0|0|0|0|1P|1|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]|S|$5|O|P|Q|A|$R|I]]]]

For anyone still having this problem: based on this article

<a href="http://oradim.blogspot.com/2009/09/odpnet-provider-is-not-compatible-with.html" rel="nofollow">http://oradim.blogspot.com/2009/09/odpnet-provider-is-not-compatible-with.html</a>

I found out that my server was missing the Microsoft C++ Visual Runtime Library - I had it on my dev machine because of the Visual Studio installed. I downloaded and installed the (currently) most recent version of the library from here:

<a href="http://www.microsoft.com/en-us/download/details.aspx?id=13523" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=13523</a>

Ran the setup and the oracle call from C# made it!

blocks|key|350373|text|我没有走上获得新的DLL的道路，我们有一堆现有的项目工作得很好，只有我的新项目让我头疼，所以我决定尝试其他的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|350374|我的项目使用的是依赖于Oracle.DataAccess.dll+v4.112.3.0的内部开发的Internal.dll。由于某些原因，当发布时，Visual+Studio总是上传v4.121.0.0，即使它没有在任何配置文件中显式指定。这就是我得到一个错误的原因。|offset|length|style|CODE|350375|所以我所做的是：|350376|350377|将Internal.dll从一个成功运行的项目复制到我的网站的/bin中(只是为了安全起见)。|ordered-list-item|350378|将Oracle.DataAccess.dll从一个成功运行的项目复制到我的网站的/bin.|350379|Add引用中。我的web+site.|350380|Finally+Oracle.DataAccess引用显示在myWebSite.csproj中，但它显示了错误的版本：v4.121.0.0而不是safe手动更改了myWebSite.csproj中的引用，因此它现在显示为：|350381|350382|False+bin\Oracle.DataAccess.dll+|350383|entityMap^0|0|X|A|2J|A|0|0|0|V|4|0|14|4|0|0|U|G|1N|A|29|G|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]|$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|N|3|O|5|M|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1C|8|@]|9|@]|A|$]]|$1|R|3|S|5|M|7|1D|8|@$D|1E|E|1F|F|G]|$D|1G|E|1H|F|G]|$D|1I|E|1J|F|G]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1L|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|X|$]]

I didn't go down the road of getting new DLL's. We had a bunch of existing projects that work perfectly fine and it was only my new project that was giving me headache so I decided to try something else. 

My project was using an internally developed Internal.dll that depended on Oracle.DataAccess.dll <code>v4.112.3.0</code>. For some reason, when publishing, Visual Studio always uploaded <code>v4.121.0.0</code>, even though it wasn't explicitly specified in any of the config files. That's why I was getting an error.

So what I did was:

<ol>
<li>Copied Internal.dll from one of the successfully running projects to my web site's <code>/bin</code> (just to be on the safe side).</li>
<li>Copied Oracle.DataAccess.dll from one of the successfully running projects to my web site's <code>/bin</code>.</li>
<li>Add Reference to both of them from my web site.</li>
<li>Finally Oracle.DataAccess reference showed up in <code>myWebSite.csproj</code>, but it showed the wrong version: <code>v4.121.0.0</code> instead of <code>v4.112.3.0</code>.</li>
<li>I manually changed the reference in <code>myWebSite.csproj</code>, so it now read:

<pre><code>&lt;Reference Include="Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86"&gt;
 &lt;SpecificVersion&gt;False&lt;/SpecificVersion&gt;
 &lt;HintPath&gt;bin\Oracle.DataAccess.dll&lt;/HintPath&gt;
&lt;/Reference&gt; 
</code></pre></li>
</ol>

blocks|key|346837|text|我在Oracle.DataAccess.dll+v4.121.2.0上也遇到了同样的问题。2-+home安装(32位和64位版本)。32位版本的workerd，64位版本没有。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|346838|在我的例子中(经过两天的尝试)，我发现问题出在64位主版本的权限上。该版本中的许多目录具有独占覆盖的权限，其中"Authenticated+Users“角色没有"Read”访问权限，这是在父目录上默认设置的。这些子目录包括"bin“、"network/admin”、"nls“、"oracore”、"RDBMS“等。我通过从sysinternals中过滤掉“访问被拒绝”导致的“进程监控”(Procmon.exe)实用程序找到了它们。一旦权限从父目录继承到那些子子目录，一切都开始正常工作。|346839|我不知道如何覆盖整个oracle主目录上的权限，所以我一次只覆盖了一个目录，但我猜如果您不太担心安全性，可以在整个相应的oracle主目录上重置它。|346840|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I had the same issue with Oracle.DataAccess.dll v4.121.2.0. with 2- homes installation (32 and 64 bit versions). 32-bit version workerd, 64-bit version didn't.

In my case (after 2 days of trying) I found that the problem was permissions on the 64-bit-home version. Many Directories in that version had exclusively overridden permissions where "Authenticated Users" role did not have "Read" access, which is set by default on the parent directory. Those sub-directories included "bin", "network/admin", "nls", "oracore", "RDBMS" and possibly others. I found them by filtering out "ACCESS DENIED" result in "Process Monitor" (Procmon.exe) utility from sysinternals. Once the permissions were inherited from the parent directory to those child subdirectories everything started to work. 

I didn't what to override the permissions on the whole oracle home so I did them one directory at a time, but I guess if you don't worry about security so much you can reset it on the whole corresponding oracle home directory.

blocks|key|3123726|text|在我为Visual+Studio+2015安装了Oracle+Data+Tools之后，我遇到了这个问题，然后与Oracle斗争了一个小时。我决定再次尝试重新安装Oracle客户端，而不是在文件复制、配置更改等方面搞得一团糟，这对我有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3123727|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I encountered this problem after I installed Oracle Data Tools for Visual Studio 2015, and then fighting with Oracle for a good hour. I decided to try reinstalling Oracle client again instead of this mess with file copying, config changes, etc., and that worked for me.

blocks|key|346864|text|TLDR版本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|346865|346866|改用12c+100%25+managed+provider。|unordered-list-item|offset|length|346867|如果必须使用旧提供程序，则需要将Oracle.DataAccess.dll指向正确版本的非托管Oracle客户机Dlls。如果您在计算机上安装了多个Oracle客户端，可能只需在应用程序配置中包含"DllPath“配置变量(见下文)，但您可能还需要安装一个新的oracle客户端以指向。|346868|346869|完整版本：|346870|首先，让我们确保了解旧的未管理提供程序的组件(而不是新的12c+100%25托管提供程序)。它由两部分组成：|346871|非托管(非.net+)客户端组件-+Oracle.DataAccess.dll|346872|the+|346873|.net|ordered-list-item|346874|346875|346876|简单地说，Oracle.DataAccess.dll几乎只是一个包装器，为非托管客户机将.net指令转换为ORACLE-NET指令。|346877|也就是说，当您加载Oracle.DataAccess时，它会按照一定的顺序尝试定位它所需要的非托管客户端dlls。从Oracle+Documentation|346878|346879|+Oracle.DataAccess.dll将根据以下顺序搜索相关的非托管DLL(如Oracle客户端)：|blockquote|346880|346881|1.应用程序或可执行文件的目录。|346882|2.DllPath设置由应用程序配置或web.config指定。|346883|3.+machine.config指定的3.DllPath设置。|346884|4.由Windows注册表指定的4.DllPath设置。|346885|HKEY_LOCAL_MACHINE\Software\Oracle\ODP.NET\version\DllPath|346886|5.+Windows+PATH环境变量指定的目录。|346887|346888|因此，在您的示例中，您的应用程序遵循了上面的过程，并找到了一条路径，该路径具有相对于您正在使用的Oracle.DataAccess.dll程序集太旧的未受管理的dll。|346889|这可能是因为该计算机上安装的唯一Oracle客户端太旧。但是，如果您在计算机上安装了多个客户端，并且未管理的文件首先是在不同但较旧的安装中找到的，则会出现这种情况。如果是后者，简单的做法是在配置中使用dllPath配置变量，并将其指向正确的Oracle+Home+Bin文件夹：|346890|<configuration>
++<oracle.dataaccess.client>+
++++<add+key="DllPath"+value="c:\oracle\product\1.1.0-xcopy-dep\BIN"/>
++</oracle.dataaccess.client>
</configuration>|code-block|syntax|javascript|346891|如果您想要安装客户端的最新副本，xcopy+version是最小的，并且包含“即时客户端”，并将上面的DllPath指向这个新位置。但是任何oracle客户端安装都可以。|346892|但如果你想避免所有这些非托管客户端解析的东西，看看你是否可以更新你的应用程序来使用100%25托管提供程序-它实际上只是一个或两个托管程序集，没有任何对未管理文件的依赖。|346893|如果你的bin目录和GAC中都安装了Oracle.DataAccess.dll，你也有可能没有加载你认为的那个文件，但我认为这是不太可能的。有关详细信息，请参阅assembly+resolution+process。|346894|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/17583289/oracle-odp-net-managed-vs-unmanaged-driver/17618179#17618179|1|http://docs.oracle.com/cd/E16655_01/win.121/e17732/InstallODP.htm|2|http://www.brothersincode.com/post/Oracle-ODPnet-xcopy-deployment-for-aspnet.aspx|3|https://blogs.msdn.microsoft.com/pranav_rastogi/2010/10/17/asp-net-assembly-loading-from-gac-or-bin/^0|0|0|6|L|0|0|0|0|0|0|0|0|0|0|0|0|1M|K|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|G|D|2|0|0|28|R|3|0^^$0|@$1|2|3|4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|2E|8|@]|9|@$F|2F|G|2G|1|2H]]|A|$]]|$1|H|3|I|5|E|7|2I|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|2K|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|2L|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|2M|8|@]|9|@]|A|$]]|$1|Q|3|R|5|E|7|2N|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|2O|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|2P|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|2R|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|2S|8|@]|9|@$F|2T|G|2U|1|2V]]|A|$]]|$1|11|3|-4|5|6|7|2W|8|@]|9|@]|A|$]]|$1|12|3|13|5|14|7|2X|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|2Y|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|2Z|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|30|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|31|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|32|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|33|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|34|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|35|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|6|7|36|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|6|7|37|8|@]|9|@]|A|$]]|$1|1N|3|1O|5|1P|7|38|8|@]|9|@]|A|$1Q|1R]]|$1|1S|3|1T|5|6|7|39|8|@]|9|@$F|3A|G|3B|1|3C]]|A|$]]|$1|1U|3|1V|5|6|7|3D|8|@]|9|@]|A|$]]|$1|1W|3|1X|5|6|7|3E|8|@]|9|@$F|3F|G|3G|1|3H]]|A|$]]|$1|1Y|3|-4|5|6|7|3I|8|@]|9|@]|A|$]]]|1Z|$20|$5|21|22|23|A|$24|25]]|26|$5|21|22|23|A|$24|27]]|28|$5|21|22|23|A|$24|29]]|2A|$5|21|22|23|A|$24|2B]]]]

TLDR Version:

<ul>
<li>Use the 12c <a href="https://stackoverflow.com/questions/17583289/oracle-odp-net-managed-vs-unmanaged-driver/17618179#17618179">100% managed provider</a> instead.</li>
<li>If you must use the old provider, you need to point Oracle.DataAccess.dll to the unmanaged Oracle Client Dlls that are of the correct version. If you have multiple Oracle Clients installed on your machine that maybe a simple as including the "DllPath" configuration variable (see below) in you app config, but you may also need to install a new oracle client to point to.</li>
</ul>

Full version:

First, lets make sure we understand the components of the old unmnaged provider (not the new 12c 100% managed provider). It's made up of two pieces:

<ol>
<li>the managed .net component - Oracle.DataAccess.dll</li>
<li>the unmanaged (non-.net) client</li>
</ol>

Simply speaking, Oracle.DataAccess.dll is nearly just a wrapper, translating .net instructions into ORACLE-NET instructions for the unmanaged client.

That said, when you load Oracle.DataAccess there is a order in which it tries to locate the unmanaged client dlls that it needs. From the <a href="http://docs.oracle.com/cd/E16655_01/win.121/e17732/InstallODP.htm" rel="nofollow noreferrer">Oracle Documentation</a>:

<blockquote>
 The Oracle.DataAccess.dll searches for dependent unmanaged DLLs (such
 as Oracle Client) based on the following order:
 
 1.Directory of the application or executable.
 
 2.DllPath setting specified by application config or web.config.
 
 3.DllPath setting specified by machine.config.
 
 4.DllPath setting specified by the Windows Registry.
 
 HKEY_LOCAL_MACHINE\Software\Oracle\ODP.NET\version\DllPath
 
 5.Directories specified by the Windows PATH environment variable.
</blockquote>

So in your case, your app followed this process above and found a path that has unmananged dlls that are too old relative to the Oracle.DataAccess.dll assembly that you are using.

It could just be that the only Oracle Client install on that machine is too old. But this comes into play if you have more than one client installed on the machine and the unmananaged files were found first in a different but older installation. If the later, the simple thing to do is use the dllPath configuration variable in your config and point it at the correct Oracle Home Bin folder:

<pre><code>&lt;configuration&gt;
 &lt;oracle.dataaccess.client&gt; 
 &lt;add key="DllPath" value="c:\oracle\product\1.1.0-xcopy-dep\BIN"/&gt;
 &lt;/oracle.dataaccess.client&gt;
&lt;/configuration&gt;
</code></pre>

If you want to install a fresh copy of the client, the <a href="http://www.brothersincode.com/post/Oracle-ODPnet-xcopy-deployment-for-aspnet.aspx" rel="nofollow noreferrer">xcopy version</a> is the smallest and contains the "instant client" and point the DllPath above to this new location. But any oracle client install will work.

But if you want to avoid all this unmanaged client resolution stuff, see if you can update your app to use the 100% managed provider instead - it truely is just one or two managed assemblies,without any dependency on unmananged files.

Its also possible that you aren't loading the Oracle.DataAccess.dll that you think you are if it is installed in both your bin directory and your GAC, but I think that is the less likely senario. See the <a href="https://blogs.msdn.microsoft.com/pranav_rastogi/2010/10/17/asp-net-assembly-loading-from-gac-or-bin/" rel="nofollow noreferrer">assembly resolution process</a> for more information.

blocks|key|350450|text|我遇到了一个类似的问题，根本原因是GAC有两个oracle.dataaccess版本，即v4.0_4.112.2.0和v4.0_4.112.4.0。我的应用程序引用的是v4.0_4.112.2.0，所以当我从GAC中删除v4.0_4.112.4.0时，它工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|350451|GAC路径:+C:\Windows\Microsoft.NET\assembly\GAC_64\Oracle.DataAccess|350452|之前：|350453|📷|atomic|offset|length|350454|​|350455|之后：|350456|350457|350458|要删除某个版本，只需从GAC中删除相应的文件夹即可。|350459|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/aedeee9899928dee8ee0ccc0e5e96161.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/71fc02c2c39886c79c617d17f7716394.png^0|0|0|0|0|1|0|0|0|0|0|1|1|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|16|8|@]|9|@$I|17|J|18|1|19]]|A|$]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|O|3|G|5|H|7|1C|8|@]|9|@$I|1D|J|1E|1|1F]]|A|$]]|$1|P|3|L|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]|11|$5|V|W|X|A|$Y|12|10|-4]]]]

I faced a similar issue and the root cause was that GAC had 2 oracle.dataaccess versions i.e. v4.0_4.112.2.0 and v4.0_4.112.4.0 . My application was referring to v4.0_4.112.2.0 , so when I removed v4.0_4.112.4.0 from GAC, it worked fine.

GAC path : C:\Windows\Microsoft.NET\assembly\GAC_64\Oracle.DataAccess

Before : 
<a href="https://i.stack.imgur.com/2m47P.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2m47P.png" alt="enter image description here"></a>

After :
<a href="https://i.stack.imgur.com/Qw4gD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qw4gD.png" alt="enter image description here"></a>

To remove a version, one can simply delete the corresponding folder from GAC.

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle client" error message. Any help would be appreciated.

I've referenced the Data Provider in Visual Studio 2005 and the code behind looks like this:

<pre><code>using Oracle.DataAccess.Client;
..

OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString =
 "Data Source=MyOracleServerName;" +
 "Integrated Security=SSPI";
oOracleConn.Open();

//Do Something

oOracleConn.Close();
</code></pre>

The error for the page looks like this:

<pre><code>Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

Source Error: 
Line 21: 
Line 22: 
Line 23: OracleConnection oOracleConn = new OracleConnection();
Line 24: oOracleConn.ConnectionString =
Line 25: "Data Source=MyOracleServerName;" +

[OracleException (0x80004005): The provider is not compatible with the version of Oracle client]
 Oracle.DataAccess.Client.OracleInit.Initialize() +494
 Oracle.DataAccess.Client.OracleConnection..cctor() +483

Stack Trace: 
[TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.]
 Oracle.DataAccess.Client.OracleConnection..ctor() +0
 Boeing.IVX.Web.RoyTesting.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\CE218C\Desktop\IVX.Net\Web\IVX\RoyTesting.aspx.cs:23
 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
 System.Web.UI.Control.OnLoad(EventArgs e) +99
 System.Web.UI.Control.LoadRecursive() +47
 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
</code></pre>

The provider is not compatible with the version of Oracle client

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正尝试在我的ASP.net项目上使用Oracle ODP.NET 11g (11.1.0.6.20) Instant Client作为ASP.net数据提供程序，但是当我运行aspx页面时，我收到一条错误消息“该提供程序与Oracle client的版本不兼容”。任何帮助都将不胜感激。我引用了Visual Studi...

问提供程序与Oracle客户端的版本不兼容
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问提供程序与Oracle客户端的版本不兼容EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问提供程序与Oracle客户端的版本不兼容
EN