Connect Via OLEDB - Timeout

[matancha]

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.

[danielrozental]

If you're using external reloads you should look into using the qlikviewdistributionservice.exe to do it.

Yes, you can set timeouts on oledb connections but sorry, I'm not sure about the correct syntax, try Connection TimeOut=60;

[matancha]

Hello Daniel.

Thanks for your response.

Where can i check for qlikviewdistributionservice.exe ?

Where i type the connection Time out?

Somthing like this?

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True; TimeOut = 60 ] etc...

Tnks again -

Matan.

[matancha · Accepted solution]

Think that I got it.

set ErrorMode=0;
OLEDB CONNECT TO [Provider=SQLOLEDB.1; ....... ; Connect Timeout=5] ;
IF (ScriptError>0) THEN
 EXIT Script;
ENDIF;

2.Somone can help me with -  qlikviewdistributionservice.exe ? Where can i find details?

Tnks -

Matan.

[danielrozental]

You can find the details in the server reference manual.