Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Tick the Force 32bit check box (Forced the OLEDB connection to 32-bit ). Should solve the issue
The checkbox is ticked. So i can rule this out.
Gysbert and Roger thanks for your responses.
I'll let you know if your responses provided the solution