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 -

      Matan.