title: Excel ODBC and 64 bit server
body: <p>using ASP.NET I need to update an excel template.</p>
  
  <p>Our server is running Windows 2008 in 64 bit mode.</p>
  
  <p>I am using the following code to access the excel file:</p>
  
  <pre><code>    ...
      string connection = 
  @"Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=" + path + ";";
      ...
  </code></pre>
  
  <p>IF the application pool is set to Enable 32 bit applications the code works as expected; however the oracle driver I am using fails as it is only 64 bit.</p>
  
  <p>If Enable 32-bit applications is set to false the excel code fails with the error:</p>
  
  <blockquote>
    <p>Data source name not found and no
    default driver specified</p>
  </blockquote>
  
  <p>Any suggestions?</p>