title: Oracle.DataAccess.Client Dependencies
body: <p>First of all, I want to use the <code>Oracle.DataAccess.dll</code> to use <code>OracleBulkCopy</code>.</p>
  
  <p>I want to know all the dlls that I need to be able to read from a database and then perform a bulkcopy in Oracle. Currently, we are using only one dll to perform all the reads from databases, we are using <code>Oracle.ManagedDataAccess.Client</code>. But I can't use it to perform a bulkCopy.</p>
  
  <p>I don't want to install ODP.NET for the users, I want to include the dll directly in the program. So I want to know the minimum required dlls to be able to use the <code>Oracle.DataAccess.dll</code> in 32bit and in 64bit.</p>
  
  <p>I know that there are some old post about this, but it's quiet old and the listed dlls are out of date. I can't event find some of them.</p>
  
  <p>I installed the ODP.net for ODAC12 and I retreived all the listed dlls in this <a href="https://stackoverflow.com/questions/3935808/how-can-i-deploy-a-net-application-that-uses-odac-without-installing-the-whole">post</a>. I also tried with with this <a href="https://stackoverflow.com/questions/659341/the-provider-is-not-compatible-with-the-version-of-oracle-client">post</a>. The listed dlls are pointing out the version 11.</p>
  
  <p>I made a dummy project that opens a connection, reads a table and bulk it in another table. I copied the listed dlls from the posts in the root of the project and I included <code>Oracle.DataAccess.dll</code> in the project. </p>
  
  <p>When I run my program in 64 bit I get the following error:</p>
  
  <blockquote>
    <p>Could not load file or assembly 'Oracle.DataAccess, Version=4.121.2.0,
    Culture=neutral, PublicKeyToken=89b483f429c47342'</p>
  </blockquote>
  
  <p>When I run it in 32 bit, I get this error:</p>
  
  <blockquote>
    <p>Unable to load DLL 'OraOps12.dll': The specified module could not be
    found. (Exception from HRESULT: 0x8007007E)"</p>
  </blockquote>
  
  <p>The dlls that I included are:</p>
  
  <ul>
  <li>oci.dll</li>
  <li>ociw32.dll</li>
  <li>Oracle.DataAccess.dll</li>
  <li>orannzsbb12.dll</li>
  <li>oraocci12.dll</li>
  <li>oraociei12.dll</li>
  <li>OraOps12.dll</li>
  </ul>