title: Microsoft access with PHP and PDO
body: <p>I am trying to connect to my access database but cannot. I have on my Microsoft server 2008 with IIS 7. I keep getting this error message. SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Not Sure what I am doing wrong. Any ideas would help.</p>
  
  <pre><code>&lt;?php
  try {
  
   $conn = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\\staffing.mdb;Uid=Admin");
  
  }
  catch (PDOException $e) {
    echo $e-&gt;getMessage();
  }
  ?&gt;
  </code></pre>