topic Re: Macro to connect to ODBC datasource in QlikView https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783615#M665400 <HTML><HEAD></HEAD><BODY><P>Marcus, thanks for your reply. Unfortunately, i do not think that those codes are meant to be run with Direct Discovery.</P><P></P><P>Have already tweaked the time-out settings but the database still fails to connect. </P></BODY></HTML> Thu, 15 Jan 2015 09:02:57 GMT 2015-01-15T09:02:57Z Macro to connect to ODBC datasource https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783613#M665398 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to create a macro to connect to ODBC datasource automatically after fixed time intervals. Can anyone help with that? </P><P></P><P>My Qlikview application is connected to a PostgreSQL through ODBC connector. The tabs and objects work fine most of the time but sometimes after some standby period (no user using the app) the connection gets broken somehow and it starts showing "Database Connection failed". </P><P></P><P>After that, the only way i have figured out to reconnect is to close the application and open it again (or re-publish it again). A macro code to re-connect again will help in such a case.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 14 Jan 2015 07:03:37 GMT https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783613#M665398 2015-01-14T07:03:37Z Re: Macro to connect to ODBC datasource https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783614#M665399 <HTML><HEAD></HEAD><BODY><P><SPAN>Look through these - </SPAN><A href="https://community.qlik.com/t5/forums/searchpage/tab/message?q=macro+write+odbc">http://community.qlik.com/search.jspa?q=macro+write+odbc</A><SPAN> - various posting maybe they give you a hint how to (re)connect yout database. But it could be that it don't work with direct discovery. Maybe it's better to go to your database/odbc-driver and change the timeout-settings.</SPAN></P><P></P><P>- Marcus</P></BODY></HTML> Wed, 14 Jan 2015 09:54:23 GMT https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783614#M665399 marcus_sommer 2015-01-14T09:54:23Z Re: Macro to connect to ODBC datasource https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783615#M665400 <HTML><HEAD></HEAD><BODY><P>Marcus, thanks for your reply. Unfortunately, i do not think that those codes are meant to be run with Direct Discovery.</P><P></P><P>Have already tweaked the time-out settings but the database still fails to connect. </P></BODY></HTML> Thu, 15 Jan 2015 09:02:57 GMT https://community.qlik.com/t5/QlikView/Macro-to-connect-to-ODBC-datasource/m-p/783615#M665400 2015-01-15T09:02:57Z