topic Re: Dynamic ODBC connection is Qlikview in QlikView

Dynamic ODBC connection is Qlikview

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

My source is SQL server and database have different password for different environment.

I am trying to handle the ODBC connection dynamically.

I am using below script:

if (wildmatch (v_compName,'100-BIQVW-D*') then

ODBC CONNECT TO $(vODBC) (XUserId is NYOOWIRNJbaCEEBKNKYEHaVV, XPassword is TOSJTQBNQLbCGZROdF)

else if (wildmatch (v_compName,'100-BIQVW-T*') then

ODBC CONNECT TO $(vODBC) (XUserId is VPXPcIRNJbaCEEBKNKYEHadS, XPassword is BXVQJJVMNbbMXSVJFbbB)

else if (wildmatch (v_compName,'100-BIQVW-P*') then

ODBC CONNECT TO AHP_PRD (XUserId is VbcAQIRNJbaCEEBKNKYEHaZc, XPassword is BTCDcQBNQLbCGZROZE)

else if (wildmatch (v_compName,'SBYCSQLSCLNT01*') then

ODBC CONNECT TO $(vODBC) (XUserId is NYOOWIRNJbaCEEBKNKYEHaVV, XPassword is TOSJTQBNQLbCGZROdF

end if

But this is not working.

Can anyone please help me.

Thanks,

Sarif

Re: Dynamic ODBC connection is Qlikview

jubarrosor — Thu, 05 Jul 2018 08:47:17 GMT

Hi Mohammad:

You can use a configuration file to import the odbc connection from each enviroment

Best Regards,

Juan P. Barroso

Re: Dynamic ODBC connection is Qlikview

Peter_Cammaert — Thu, 05 Jul 2018 08:51:29 GMT

Do you get any messages from QlikView? The ODBC driver? The DBMS? None at all?

Re: Dynamic ODBC connection is Qlikview

mhmmd_srf — Thu, 05 Jul 2018 08:58:43 GMT

it is showing syntax error..I did not executed yet..

Re: Dynamic ODBC connection is Qlikview

mhmmd_srf — Thu, 05 Jul 2018 09:15:10 GMT

for that we need to maintain different config file in diff environment. But we do not want that.

We want single config file across the landscape.

Re: Dynamic ODBC connection is Qlikview

tresB — Thu, 05 Jul 2018 09:24:39 GMT

I guess, it's parenthesis issue. Try removing unnecessary '(' after all If (s), like:

if (wildmatch (v_compName,'100-BIQVW-D*') then

Re: Dynamic ODBC connection is Qlikview

mhmmd_srf — Thu, 05 Jul 2018 09:33:02 GMT

Tanks TB for your reply...I did that...still not working.

Attaching file. Could you please check once.

Re: Dynamic ODBC connection is Qlikview

tresB — Thu, 05 Jul 2018 09:39:12 GMT

Try this (at least I don't see error with it now).

if wildmatch (v_compName,'100-BIQVW-D*') then

ODBC CONNECT TO $(vODBC) (XUserId is NYOOWIRNJbaCEEBKNKYEHaVV, XPassword is TOSJTQBNQLbCGZROdF);

elseif wildmatch (v_compName,'100-BIQVW-T*') then

ODBC CONNECT TO $(vODBC) (XUserId is VPXPcIRNJbaCEEBKNKYEHadS, XPassword is BXVQJJVMNbbMXSVJFbbB);

elseif wildmatch (v_compName,'100-BIQVW-P*') then

ODBC CONNECT TO AHP_PRD (XUserId is VbcAQIRNJbaCEEBKNKYEHaZc, XPassword is BTCDcQBNQLbCGZROZE);

elseif wildmatch (v_compName,'SBYCSQLSCLNT01*') then

ODBC CONNECT TO $(vODBC) (XUserId is NYOOWIRNJbaCEEBKNKYEHaVV, XPassword is TOSJTQBNQLbCGZROdF);

end if

end if

end if

end if

;

Re: Dynamic ODBC connection is Qlikview

mhmmd_srf — Thu, 05 Jul 2018 09:44:20 GMT

oopss..it was semicolon issue..

Re: Dynamic ODBC connection is Qlikview

tresB — Thu, 05 Jul 2018 09:45:57 GMT

And also, Elseif, not else if

Re: Dynamic ODBC connection is Qlikview

Peter_Cammaert — Thu, 05 Jul 2018 10:07:30 GMT

Both are allowed by the Script syntax spec. The only difference is that ELSEIF doesn't need repeated END IF statement terminators. An IF with multiple ELSEIF clauses is still a single statement, while ELSE IF starts a new statement, leading to nested IF blocks that each must be terminated.

So you may want to adjust your example code.

Re: Dynamic ODBC connection is Qlikview

Peter_Cammaert — Thu, 05 Jul 2018 10:14:36 GMT

Tres, QV11.20 allows for isolated END IF keywords (as many as you like and wherever you like), but 12.xx gives an error message for your three superfluous END IF terminators. And the message is really informative:

"The control statement is not correctly matched with its corresponding start statement

END IF"

We were warned that QV12 was going to be more strict about script syntax...

Re: Dynamic ODBC connection is Qlikview

tresB — Thu, 05 Jul 2018 10:33:25 GMT

I could remember faintly, that I used both in some earlier version. But with new qlix engine (QV 12.1) I could not use "else if". I guess, you meant for the older version, right (may be QV 11.2 as you mentioned in the below post)?

Re: Dynamic ODBC connection is Qlikview

Peter_Cammaert — Thu, 05 Jul 2018 10:52:42 GMT

You can use ELSE IF but not on the same line. This

IF var = 1 THEN

LET Othervar = 'One';

ELSE IF var = 2 THEN

LET Othervar = 'Two';

END IF

doesn't work in 12.xx, but this one

IF var = 1 THEN

LET Othervar = 'One';

ELSE

IF var = 2 THEN

LET Othervar = 'Two';

END IF

does.

Also apparently this one doesn't work in v12 anymore, while it used to work in 11.20.

IF var = 1 THEN

LET Othervar = 'One';

ELSEIF var = 2 THEN

LET Othervar = 'Txo';

END IF

Re: Dynamic ODBC connection is Qlikview

mhmmd_srf — Thu, 05 Jul 2018 11:30:34 GMT

yes...but I am getting error now.