Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two different connection strings

Hi all,

I have to two database connection strings which are from two different oracle database servers but contains same tables and views.

I need to connect to main database server, if connection is successful then i will use this connection string else, I will connect to secondary database server and use secondary connection string to pull the data.

I think script would be like this,

if ConnectionString1='Success' then

ConnectionString1

Else

ConnectionString2

End if

Now how do I check if first/second connection is successful or not in script?

Any help would be great.

Thanks in advance.

Cheers,

Amay.

1 Solution

Accepted Solutions
rbecher
MVP
MVP

Hi Amay,

you can catch the ScriptError:

set ErrorMode=0;

CONNECT <ConnectionString1>...;

if ScriptError>1 then

     //not connected ConnectionString1...

     CONNECT <ConnectionString2>...;

end if

set ErrorMode=1;

- Ralf

Astrato.io Head of R&D

View solution in original post

2 Replies
rbecher
MVP
MVP

Hi Amay,

you can catch the ScriptError:

set ErrorMode=0;

CONNECT <ConnectionString1>...;

if ScriptError>1 then

     //not connected ConnectionString1...

     CONNECT <ConnectionString2>...;

end if

set ErrorMode=1;

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Thanks Ralf