title: Oracle Ole DB drivers won't work: ADODB.Connection error '800a0e7a'
body: <p>I've installed three of the client packages on Windows Server 2008 Standard but still cannot open a connection because of the error &quot;Provider not found&quot;. All of these packages are for 64bit.</p>
  <p>C:\Windows\System32\odbcad32.exe screenshot:</p>
  <p><img src="https://i.stack.imgur.com/R6QBV.jpg" alt="This is the C:\Windows\System32\odbcad32.exe result" /></p>
  <p>c:\windows\SysWOW64\odbcad32.exe screenshot: NO ORACLE DRIVER!!!</p>
  <p><img src="https://i.stack.imgur.com/A3LJt.jpg" alt="enter image description here" /></p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="false" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;%  
  Set conn = Server.CreateObject("ADODB.Connection")
  conn.Open "Provider=OraOLEDB.Oracle;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"
  %&gt;</code></pre>
  </div>
  </div>
  </p>
  <p>When I run the code, it gives an error:</p>
  <blockquote>
  <p>ADODB.Connection error '800a0e7a'</p>
  <p>Provider not found.</p>
  </blockquote>
  <p>I've also read similar questions and did what they suggest but I'm stuck at this error.</p>
  <p>32bit app pool is also enabled.</p>
  <p><img src="https://i.stack.imgur.com/tLdSc.png" alt="enter image description here" /></p>
  <p>Connection string help page: <a href="http://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/" rel="nofollow noreferrer">http://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/</a></p>
  <p>Oracle 11g release 2 client ODBC drivers link: <a href="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html" rel="nofollow noreferrer">http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html</a></p>