topic Using connect with failure codes in QlikView https://community.qlik.com/t5/QlikView/Using-connect-with-failure-codes/m-p/280085#M104231 <HTML><HEAD></HEAD><BODY><P>Is there any way we can get error codes from a connect statement? We develop lots of different documents from different sources using ole, odbc &amp; excel and then move to 3 different servers. Often one of the TNS names or ODBC connection is missing on one of the servers, but from QEMC QV will just sit there &amp; we are unaware that one of the connections is failing. If we are awrae it's a simple thing to ask IT to make a new connection on their boxes.</P><P></P><P>So I am looking for a mthod to trap connnetion errors &amp; have QV flag the error, alert us &amp; exit gracefully. We just moved to QV 10.</P><P></P><P>Thank you</P><P></P><P>Bruce </P></BODY></HTML> Wed, 21 Sep 2011 19:39:17 GMT 2011-09-21T19:39:17Z Using connect with failure codes https://community.qlik.com/t5/QlikView/Using-connect-with-failure-codes/m-p/280085#M104231 <HTML><HEAD></HEAD><BODY><P>Is there any way we can get error codes from a connect statement? We develop lots of different documents from different sources using ole, odbc &amp; excel and then move to 3 different servers. Often one of the TNS names or ODBC connection is missing on one of the servers, but from QEMC QV will just sit there &amp; we are unaware that one of the connections is failing. If we are awrae it's a simple thing to ask IT to make a new connection on their boxes.</P><P></P><P>So I am looking for a mthod to trap connnetion errors &amp; have QV flag the error, alert us &amp; exit gracefully. We just moved to QV 10.</P><P></P><P>Thank you</P><P></P><P>Bruce </P></BODY></HTML> Wed, 21 Sep 2011 19:39:17 GMT https://community.qlik.com/t5/QlikView/Using-connect-with-failure-codes/m-p/280085#M104231 2011-09-21T19:39:17Z