2 Replies Latest reply: Jan 15, 2015 4:02 AM by Akshay Jain RSS

    Macro to connect to ODBC datasource



      I want to create a macro to connect to ODBC datasource automatically after fixed time intervals. Can anyone help with that?


      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".


      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.