{{tag>category:"OpenInsight 32-Bit" author:"Brad Bishop"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== MqSQL ODBC Timeout (OpenInsight 32-Bit) ====
=== At 09 MAY 2011 10:42:33AM Brad Bishop wrote: ===
 
 
<QUOTE>
We are connecting to a MySQL database located on another server.  The database is defined within OpenInsight using the native OI utilities. 99% of the time the connection works correctly.  1% of the time the code will hang with the logon box on the windows (dataset, userid, and password). The error has to be manually cleared.



How do I get Open Insight to return an error to the code after a set period of time (say 30 seconds) and then does anyone have a code sample of handling the error that they are willing to share ?



thanks in advance.
</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=94DCD29F436998EF8525788B0050CCEF|View this thread on the Works forum...]]