title: Which odbc connector to use?
body: <p>I am getting this error from the following code:</p>
  
  <p>$result = odbc_connect("DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=$database_name",$database_username, $database_password);</p>
  
  <blockquote>
    <p>Warning: odbc_connect(): SQL error:
    [unixODBC][Driver Manager]Data source
    name not found, and no default driver
    specified, SQL state IM002 in
    SQLConnect in /dbconnect.php on line
    xx odbc not connected</p>
  </blockquote>
  
  <p>I am using <strong>MySQL</strong> version <em>5.1.41-3ubuntu12.3</em></p>
  
  <p>My phpinfo gives the following output:</p>
  
  <pre><code>Additional .ini files parsed /etc/php5/apache2/conf.d/odbc.ini, /etc/php5/apache2/conf.d/pdo_odbc.ini  
  
  odbc
  ----
  
  ODBC Support            enabled &lt;br&gt;
  </code></pre>