title: How do I add an MSAccess connection to CodeIgniter or CakePHP?
body: <p>I'm trying to use a Microsoft Access database for a demo project that I'm thinking of doing in either CodeIgniter or CakePHP. Ignoring the possible folly of using Microsoft Access, I haven't been able to figure out precisely how the connection string corresponds to the frameworks' database settings. In straight PHP, I can use this code to connect to an Access database:</p>
  
  <pre><code>$db_connection = odbc_connect(
    "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\path\\to\\db.mdb", 
    "ADODB.Connection", "", "SQL_CUR_USE_ODBC"
  );
  </code></pre>
  
  <p>How do those strings correspond to the Code Igniter db settings? This doesn't seem to be quite working:</p>
  
  <pre><code>$db['access']['hostname'] = "{Microsoft Access Driver (*.mdb)}";
  $db['access']['username'] = "ADODB.Connection";
  $db['access']['password'] = "";
  $db['access']['database'] = "\\path\\to\\db.mdb";
  $db['access']['dbdriver'] = "odbc";
  $db['access']['dbprefix'] = "";
  $db['access']['pconnect'] = TRUE;
  $db['access']['db_debug'] = TRUE;
  $db['access']['cache_on'] = FALSE;
  $db['access']['cachedir'] = "";
  $db['access']['char_set'] = "utf8";
  $db['access']['dbcollat'] = "utf8_general_ci";
  </code></pre>