title: Set Query timeout time via PHP ODBC OpenEdge Progress drivers
body: <p>I'm working on a project where I am required to query a database using PHP ODBC methods via OpenEdge Progress drivers.  I need a way to set the timeout on the MySQL query so it is much shorter than the default settings (if there even is one).</p>
  
  <p>I tried using "odbc_setoption($stmt, 2, 0, 30)", as in the example statements below...</p>
  
  <pre><code>  $stmt = odbc_prepare($this-&gt;odbc, $query);
    odbc_setoption($stmt, 2, 0, 30);//Set query timeout to 30 seconds.
    return odbc_execute($stmt);
  </code></pre>
  
  <p>But that failed because "0" is unsupported as the option for query timeout.  I'm not aware of the number, I tried everything including attempting to set it in my database connections DSN string and via the registry.  Any ideas on the variable name and or option number in PHP?  Nobody uses this thing...</p>
  
  <p>Thanks</p>