title: ODBC to SAP HANA connection timeout in Perl
body: <p>Since I'm programming a Perl script to monitor the SAP HANA database, I'm experiencing problems with the connection timeout. I don't know how to set the timeout. This is my connection string:</p>
  
  <pre><code>use DBI;
  use DBD::ODBC;
  $dbh = DBI-&gt;connect("dbi:ODBC:dsn=$dsn");
  </code></pre>
  
  <p>Meanwhile in another script to monitor a Sybase database it works properly:</p>
  
  <pre><code>use DBI;
  
  dbh = DBI-&gt;connect("dbi:Sybase:server=$dbsvr;database=$dbname;".
                 timeout=$timeout;"."loginTimeout=$timeout", $user, $pass);
  </code></pre>
  
  <p>I think the problem comes with the ODBC. Which is the way to implement a timeout using ODBC connection?</p>