title: Connecting PHP5 to MS Access with pdo_odbc
body: <p>Hi im trying to connect php5 to MS Access on my unix server.
  I managed to install &amp; load pdo_odbc drivers.
  However, when i ran this code:</p>
  
  <pre><code>    $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=tra.mdb; Uid=; Pwd=;");
  </code></pre>
  
  <p>i get this error on my page:</p>
  
  <pre><code>    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'Microsoft Access Driver (*.mdb)' : file not found' in /usr/local/www/sks/php_access.php:1 Stack trace: #0 /usr/local/www/sks/php_access.php(1): PDO-&gt;__construct('odbc:DRIVER={Mi...') #1 {main} thrown in /usr/local/www/sks/php_access.php on line 1
  </code></pre>
  
  <p>Fyi, the MDB file is located within the same page.</p>