topic Re: Multiple database connectivity. in QlikView

Multiple database connectivity.

Thu, 14 Nov 2013 02:07:40 GMT

Hi !

I need a help. I want to connect to multiple database i.e., if my first ODBC connection to the database fails I want to try to connect to the next database in the list through ODBC. Is there a way to do it please.

Thanking you in anticipation!

Regards,

Sundeep.

Re: Multiple database connectivity.

jagan — Thu, 14 Nov 2013 02:32:38 GMT

Hi Sundeep,

Try like this

set ErrorMode=0; // Qlikview will simply ignore the failure and continue script execution at the next script statement

ODBC connect ConnectionString1;

IF ScriptError <> 0 THEN

ODBC connect ConnectionString1;

END IF

set ErrorMode=1; // script execution will halt and the user will be prompted for action

Hope this helps you.

Regards,

Jagan.

Re: Multiple database connectivity.

Thu, 14 Nov 2013 09:24:49 GMT

Thank you so much for your help Jagan

I would try and let you know the result.

Many thanks,

Sundeep.

Re: Multiple database connectivity.

Fri, 15 Nov 2013 11:50:35 GMT

Hi Jagan,

It is working as expected. Many thanks for your help.

Rgrds,

Sundeep.

Re: Multiple database connectivity.

jagan — Mon, 18 Nov 2013 11:25:52 GMT

Hi Sundeep,

Please close this discussion by giving Correct Answer to my post, it helps others in finding the answers to the similar ones.

Regards,

Jagan