topic Auto reload Qlikview Dashboard in QlikView

Auto reload Qlikview Dashboard

kdejong — Mon, 07 Dec 2015 16:02:14 GMT

Hello,

I've got a question considering the auto reload of a QVW.

In the script there's the following OLEDB connection:

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=DB****;Data Source=*****] (XPassword is scrambled password);

The manual reload works excellent, the auto reload returns an error in the log file:
021 OLEDB CONNECT32*Provider*XPassword*

Error: ErrorSource: (null), ErrorMsg: (null)

General Script Error

Execution Failed

Execution finished.

What needs to be done to make the auto reload work?

Thanks for any help finding a solution

Gysbert_Wassenaar — Mon, 07 Dec 2015 18:45:05 GMT

No idea. But check:

1. The oledb driver is installed on the machine that does the reloading

2. You have the correct 32-bit version of the driver installed on that machine

You could also try installing the Oracle OLEDB driver from Oracle itself and connect using that driver.

roger_stone — Tue, 08 Dec 2015 11:54:26 GMT

Make sure that the QlikView server account has access to the database table. It looks like you have access but the server account does not.

manojkulkarni — Thu, 10 Dec 2015 10:03:28 GMT

Tick the Force 32bit check box (Forced the OLEDB connection to 32-bit ). Should solve the issue

kdejong — Thu, 10 Dec 2015 10:12:17 GMT

The checkbox is ticked. So i can rule this out.

kdejong — Thu, 10 Dec 2015 10:13:18 GMT

Gysbert and Roger thanks for your responses.

I'll let you know if your responses provided the solution