title: How to connect PHP with Microsoft Access database
body: <p>I am currently faced with a new challenge to develop a site using Microsoft Access as the primary database instead of mysql. I have not used MS Access before and I would like guidiance on how to go about it, I have looked up the w3c website on <a href="http://www.w3schools.com/php/php_db_odbc.asp" rel="noreferrer">W3schools</a> but the code gives error</p>
  
  <blockquote>
    <p>Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\Users\NNALI\Desktop\root\test.php on line 2</p>
  </blockquote>
  
  <p>and this error</p>
  
  <blockquote>
    <p>Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Users\NNALI\Desktop\Breweries\root\test.php on line 4</p>
  </blockquote>
  
  <p>I am stuck and do not know what to do, I would appreciate all help on this. </p>
  
  <pre><code>&lt;?php
      $conc = odbc_connect("northwind", "","");
      $sql  = "Select * From customers";
      $rs   = odbc_exec($conn, $sql);
  ?&gt;
  </code></pre>
  
  <p>Above is the code I used</p>