QDS task keep running while trying to connect Oracle via OLEDB
This is our first implementation of QlikView 11. Everything went well with development server but after deploying QVD Generator qvws on production server, I am not able to run the reload tasks from QMS that tries to connect to Oracle DB via OLEDB driver.
When I am trying to open same qvw in desktop version on the server and run, it works fine and uses the same driver. Also both development and production boxes installation versions are same. Not sure whats the issue here.
QlikView 11 installed on Win2012 64bit
The only line in my script is as below. There are no other statements in this test QVW.
OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxxx;Data Source=xxxx;Extended Properties=""] (XPassword is xxxxxxxx);