title: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source
body: <p>I want to create connection with <code>teradata</code> DB form <code>php</code>. My code is hosted on  <code>Ubuntu</code> server but the below error occurred.</p>
  
  <blockquote>
    <p>"odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name
    not found, and no default driver specified, SQL state IM002 in
    SQLConnect in /path".</p>
  </blockquote>
  
  <p>while it is working properly from local host.</p>
  
  <p>php code is: </p>
  
  <pre><code>$sDriver = 'Teradata';
  $sDBCName = 'ip';
  $sDatabase = 'dbname';
  $sDSN = "Driver={$sDriver};DBCName={$sDBCName};Database={$sDatabase};";
  $connection = odbc_connect($sDSN, "username", "password");
  </code></pre>
  
  <p>but there is nothing wrong in the code bcoz it is working on local host.</p>