Multiple database connectivity.

[#1]

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.

[jagan]

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.

[#3]

Thank you so much for your help Jagan

I would try and let you know the result.

Many thanks,

Sundeep.

[#4]

Hi Jagan,

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

Rgrds,

Sundeep.

[jagan · Accepted solution]

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