topic Connect Via OLEDB - Timeout in QlikView

Connect Via OLEDB - Timeout

matancha — Mon, 26 Jan 2026 18:19:17 GMT

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.

Connect Via OLEDB - Timeout

danielrozental — Mon, 14 May 2012 14:13:37 GMT

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;

Re: Connect Via OLEDB - Timeout

matancha — Tue, 15 May 2012 04:42:31 GMT

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.

Re: Connect Via OLEDB - Timeout

matancha — Tue, 15 May 2012 08:25:03 GMT

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.

Re: Connect Via OLEDB - Timeout

danielrozental — Tue, 15 May 2012 11:24:44 GMT

You can find the details in the server reference manual.