Auto reload Qlikview Dashboard

[kdejong]

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]

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]

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]

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

[kdejong]

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

[kdejong]

Gysbert and Roger thanks for your responses.

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