title: PHP ODBC - connection not working properly
body: <p>I wrote this code for the <code>ODBC</code> connection. But, I'm getting like this error. My <code>DB</code> is an MS Access database. Please, can anyone help me?</p>
  
  <pre><code>&lt;html&gt;
  &lt;body&gt;
  &lt;?php
  $conn=odbc_connect('finance','','');
  if (!$conn)
    {exit("Connection Failed: " . $conn);}
  $sql="SELECT * FROM Customers";
  $rs=odbc_exec($conn,$sql);
  if (!$rs)
    {exit("Error in SQL");}
  echo "&lt;table&gt;&lt;tr&gt;";
  echo "&lt;th&gt;Name&lt;/th&gt;";
  echo "&lt;th&gt;CustomerID&lt;/th&gt;&lt;/tr&gt;";
  while (odbc_fetch_row($rs))
  {
    $Name=odbc_result($rs,"Name");
    $CustomerID=odbc_result($rs,"CustomerID");
    echo "&lt;tr&gt;&lt;td&gt;$Name&lt;/td&gt;";
    echo "&lt;td&gt;$CustomerID&lt;/td&gt;&lt;/tr&gt;";
  }
  odbc_close($conn);
  echo "&lt;/table&gt;";
  ?&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p><strong>This is my error.</strong></p>
  
  <pre><code>    Warning: odbc_exec(): SQL error: [FINANCE ODBC]Base table:Customers not found., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\odbc\index.php on line 11
  Error in SQL
  </code></pre>