topic Re: Stop Script execution when not connected with database in QlikView

Stop Script execution when not connected with database

Sat, 21 Jan 2012 18:53:12 GMT

Im using ODBC CONNECT32 TO [$(vDbInstance);DBQ=$(vDbInstance)] (UserId is $(vDbUsername), Password is $(vDbPassword)); to connect to my database. How to handle when database conneciton not available ?

set ErrorMode=0;

ODBC CONNECT32 TO [$(vDbInstance);DBQ=$(vDbInstance)] (UserId is $(vDbUsername), Password is $(vDbPassword));

if ScriptError >= 1 then // or ScriptError > 1

//no connect...

CALL Log('WARN:Error in commection - ' & '$(vDbInstance)' & ',cannot continue' );

exit Script;

end if

Script execution says

Failed to connect

Error Msg Box

SQL##f - SqlState: S1000, ErrorCode: 12541, ErrorMsg: [Oracle][ODBC][Ora]ORA-12541: TNS:no listener

ODBC CONNECT32 TO [dim74t1;DBQ=dim74t1] (UserId is IBI, Password is IBI)

Stop Script execution when not connected with database

disqr_rm — Sat, 21 Jan 2012 23:47:36 GMT

Would pingin the server help you?

http://community.qlik.com/message/80817#80817

Stop Script execution when not connected with database

Sun, 22 Jan 2012 03:40:04 GMT

Thanks Rakesh , will try that.

any Idea why it didnt catch up wtih ErrorCode >1 ?

Re: Stop Script execution when not connected with database

rbecher — Sun, 22 Jan 2012 18:09:16 GMT

Hi,

you could use the Oracle program tnsping:

//Load Script:

execute cmd.exe /C "tnsping dim74t1 >tnsping.out";

tnsping:

LOAD @1

FROM tnsping.out (txt, codepage is 1252, no labels, delimiter is '\t', no quotes)

WHERE left(@1,9)='TNS-12541';

IF NoOfRows('tnsping') THEN

TRACE TNS:no listener;

exit script;

END IF

- Ralf

Re: Stop Script execution when not connected with database

Mon, 23 Jan 2012 05:27:56 GMT

Thanks Ralf