title: Data source name not found, and no default driver specified
body: <p>I need help fixing an error: <code>SQL state IM014 in SQLConnect</code> and <code>SQL state IM002 in SQLConnect</code>.</p>
  
  <p>I run the same script,  one on <code>webserver/remote/</code> and the other one from the local Machine trying to access the same database but i get different error message. </p>
  
  <p>When i run it from web server i get </p>
  
  <blockquote>
    <p>SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQL</p>
  </blockquote>
  
  <p>where as when i run it on local machine i get </p>
  
  <blockquote>
    <p>[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application</p>
  </blockquote>
  
  <p>I used the following code in php script to connect to the Local database</p>
  
  <pre><code>$odbc['dsn'] = "SageLine50v19";
  $odbc['user'] = "Peac";
  $odbc['pass'] = "XXXX";
  $mysql['host'] = "localhost";
  $mysql['user'] = "root";
  $mysql['pass'] = "";
  $mysql['dbname'] = "sagetest";
  $mysql['idfield'] = "id";
  
  
  // Step 1: Connect to the source ODBC database
  if ($debug) echo "Connect to " . $odbc['dsn'] . ' as ' . $odbc['user'] . "\n";
  $conn = odbc_connect($odbc['dsn'], $odbc['user'], $odbc['pass']);
  if (!$conn) {
  die("Error connecting to the ODBC database: " . odbc_errormsg());
  }
  
  // loop through each table 
  $allTables = odbc_tables($conn);
  $tablesArray = array();
  while (odbc_fetch_row($allTables)) {
   if (odbc_result($allTables, "TABLE_TYPE") == "TABLE") {
      $tablesArray[] = odbc_result($allTables, "TABLE_NAME");
   }
  }
   //print_r($tablesArray);      // to list all tables
  </code></pre>
  
  <p>My <strong><em>ODBC.ini</em></strong> looks like below</p>
  
  <pre><code>[ODBC 32 bit Data Sources]
  manager=Sage Line 50 v16 (32 bit)
  t=SQL Server Native Client 10.0 (32 bit)
  s1=Pervasive ODBC Client Interface (32 bit)
  SageLine50v19=Pervasive ODBC Client Interface (32 bit)
  [manager]
  Driver32=C:\Windows\SysWOW64\S16DBC32.dll
  [t]
  Driver32=C:\Windows\system32\sqlncli10.dll
  [s1]
  Driver32=C:\Program Files (x86)\Pervasive Software\PSQL\bin\w3odbcci.dll
  [SageLine50v19]
  Driver32=C:\Program Files (x86)\Pervasive Software\PSQL\bin\w3odbcci.dll
  </code></pre>