4 Replies Latest reply: May 15, 2012 7:24 AM by Daniel Rozental RSS

    Connect Via OLEDB - Timeout

    Matan Chalamish

      Hello All.

      On my server (Windos Server SP2 - QV10) I have a script that reload qvw file (my reloads schedule By external scheduler - JIT Scheduler) :


      "C:\Program Files\QlikView\Qv.exe" /r "C:\QlikView\Model-Rolls Data Retrieval\Model\Rolls Data Retrieval.qvw"


      Some times (maybe because connection erors, etc.) this reload   - hangs on the row:

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=XXX ;Data Source=XXX ;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID= XXX;Use Encryption for Data=False;Tag with column collation when possible=False] 

      And not go on (see pic attached.).



      It's possible to set a timeout for OLEDB CONNECT ?


      Example (pseudo):

      If (tmieout for OLEDB CONNECT TO... > 3000, Exit Script)...


      So if I'll geting a connection error I will can do "Exit Script"...


      Maybe another solution?


      Sorry on my english,

      Tnks -