title: PHP ODBC connect() to Access - architecture mismatch
body: <p>I have googled for hours now.</p>
  
  <p>I have read countless articles such as: <a href="https://stackoverflow.com/questions/2013837/is-there-a-windows-7-odbc-driver-for-access">Is there a Windows 7 ODBC driver for Access?</a></p>
  
  <p>I have tried using both the ODBC admin - and have managed to successfully add there system DSN for both:</p>
  
  <ul>
  <li>Microsoft Access Database</li>
  <li>Microsoft do Access Database</li>
  </ul>
  
  <p>When I attempt to connect to Access DB stored locally:</p>
  
  <pre><code>odbc_connect('Aquarius2', '', '');
  </code></pre>
  
  <p>I get the following error(s):</p>
  
  <blockquote>
    <p>odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, SQL state IM014 in SQLConnect in C:\export\export.php on line 3</p>
  </blockquote>
  
  <p>Simple script tried installing the latest access drivers - <code>Aquarius2</code> is the name of my DSN still fails.</p>
  
  <p>I'm out of ideas - what am I missing?</p>
  
  <p>Regards,
  Alex</p>