topic Re: Check Connection Status in Script in QlikView

Check Connection Status in Script

Wed, 20 Jan 2016 09:58:40 GMT

Hi All,

I need to know about connection state in my project script.

Is there any way to check connection is succesful or not?

Thanks.

Re: Check Connection Status in Script

marcus_sommer — Wed, 20 Jan 2016 14:28:36 GMT

I don't think that this will be directly possible. But indirectly - you could run a very small and fast dummy-query which might return only one single record which could be checked - maybe within a check-loop with error-mode: ErrorHandling in Qlikview

- Marcus

Re: Check Connection Status in Script

Peter_Cammaert — Mon, 22 Feb 2016 23:10:17 GMT

Your connection is succesful when the CONNECT (or CONNECT32 or CONNECT64) statements return without an error (ScriptError = 0). By default, script execution is allowed to continue whenever the current statement succeeds.

Checking for an unsuccessful connection is easier because on average that is the condition about which ample information is available. After a CONNECT, check for ScriptError<>0. On the other hand, by default the script engine will notify you about a failed connection in very clear wording, so you may not have any checking to do after all.

Peter