topic Do anyone have any idea how to connect QlikView to Redshift at regular intervals in QlikView https://community.qlik.com/t5/QlikView/Do-anyone-have-any-idea-how-to-connect-QlikView-to-Redshift-at/m-p/798064#M437941 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am building a Direct Discovery application(Desktop version) on QlikView which is fetching data from Redshift via PostgreSQL30 ANSI(x64)&nbsp; OBDC driver. We were able to establish proper connection between the two but the major concern is that it breaks in between with an error - "Error: Database Connection Failed". I can see people facing the same but none of them have posted any possible resolution for the same <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><P>Note: Known possible solution is to reload the file and then it works( It's because when we reload the Connect script runs and does it's work), but we can't do it on the published version</P><P></P><P>It would be of great help if anyone can help us in this regard. Any help will be highly appreciated</P><P></P><P>Regards,</P><P>Sagar Gupta</P></BODY></HTML> Thu, 15 Jan 2015 13:16:29 GMT 2015-01-15T13:16:29Z Do anyone have any idea how to connect QlikView to Redshift at regular intervals https://community.qlik.com/t5/QlikView/Do-anyone-have-any-idea-how-to-connect-QlikView-to-Redshift-at/m-p/798064#M437941 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am building a Direct Discovery application(Desktop version) on QlikView which is fetching data from Redshift via PostgreSQL30 ANSI(x64)&nbsp; OBDC driver. We were able to establish proper connection between the two but the major concern is that it breaks in between with an error - "Error: Database Connection Failed". I can see people facing the same but none of them have posted any possible resolution for the same <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><P>Note: Known possible solution is to reload the file and then it works( It's because when we reload the Connect script runs and does it's work), but we can't do it on the published version</P><P></P><P>It would be of great help if anyone can help us in this regard. Any help will be highly appreciated</P><P></P><P>Regards,</P><P>Sagar Gupta</P></BODY></HTML> Thu, 15 Jan 2015 13:16:29 GMT https://community.qlik.com/t5/QlikView/Do-anyone-have-any-idea-how-to-connect-QlikView-to-Redshift-at/m-p/798064#M437941 2015-01-15T13:16:29Z Re: Do anyone have any idea how to connect QlikView to Redshift at regular intervals https://community.qlik.com/t5/QlikView/Do-anyone-have-any-idea-how-to-connect-QlikView-to-Redshift-at/m-p/798065#M437942 <HTML><HEAD></HEAD><BODY><P>Sagar,</P><P></P><P>What version of Qlik are you working with ?</P><P>This may have to do with your connection timing out and unable re establish a connecition.</P><P></P><P><SPAN>Please do contact me at </SPAN><A class="jive-link-email-small" href="mailto:John.Park@qlik.com">John.Park@qlik.com</A><SPAN> or this thread.</SPAN></P></BODY></HTML> Fri, 16 Jan 2015 21:11:35 GMT https://community.qlik.com/t5/QlikView/Do-anyone-have-any-idea-how-to-connect-QlikView-to-Redshift-at/m-p/798065#M437942 2015-01-16T21:11:35Z