title: The provider is not compatible with the version of Oracle client ODP.NET
body: <p>I landed in a tricky situation. I am working on a legacy .NET application that used ADODB (only 32bit dlls available) in conjunction with Oracle.DataAccess (32/64 bit available) which was running earlier on 2003 server with some version of Oracle (I am not sure on the version number).</p>
  <p>Now with minimal changes I need to port this to work on 2012 server (64bit) and Oracle 11g with .NET 4.0. When I use the 64bit of Oracle client, the system is failing at ADODB. When I am using 32bit Oracle client, it says <code>The provider is not compatible with the version of Oracle client.</code></p>
  <p>The environment / tools used are:
  Oracle 11g, ODP.NET, ADODB, Windows 2012 (64bit), .NET 4.0</p>
  <p>Is there a way to solve this riddle?</p>
  <p><strong>Edit :</strong></p>
  <p>I tried with System.Data.OracleClient instead of ODP.NET I got the following exception</p>
  <pre><code>System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
  </code></pre>