topic Re: Checking the Connectivity setting in QlikView

Checking the Connectivity setting

Thu, 12 Nov 2015 08:55:41 GMT

Hello,

When we are connecting Qlikview with Smart DB ,how can we check the connectivity whether it is working fine or not.

Re: Checking the Connectivity setting

buzzy996 — Thu, 12 Nov 2015 09:23:40 GMT

there are couple of ways,

1.at the time of creating connection string u could be enter username and password of ur db and click on test button,that helps whether u will able to connect ur db or not.

2.if u already created connection string,then try to pull some data,if u are able to see data on ur qv app..it's connecting else no.

hope helps.

Re: Checking the Connectivity setting

Peter_Cammaert — Thu, 12 Nov 2015 09:37:51 GMT

If you want to check for connection errors at script execution time, you can set the ErrorMode variable to 0 and check for any ScriptError values different from 0. For example,

SET ErrorMode = 0;

OLEDB CONNECT YourConnectionParameters;

IF ScriptError <> 0 THEN

// Do something with this error condition

END IF

SET ErrorMode = 1;

See also the Error Variables chapter in QV Desktop Help.

Best,

Peter