topic Re: Two different connection strings in QlikView

Two different connection strings

Mon, 16 Jul 2012 09:33:24 GMT

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.

Re: Two different connection strings

rbecher — Mon, 16 Jul 2012 09:51:39 GMT

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

Re: Two different connection strings

Mon, 16 Jul 2012 10:52:10 GMT

Thanks Ralf