using two different connection strings

[#1]

Hi,

I am new to qlikview,I need to know how i could connect to  2 different servers like server for testing and the server for development in my qlikview application.Can anyone please let me know about how this could be done with a descriptive explaination

[sivarajs]

If two connection strings has given simultaneously,only the last string will establish the connection. So you may the following approach.

In load script,

Connecting string 1

Load * from table  //load the data

Connecting string 2

Load * from table  //load the data

[israrkhan]

Yes, You can create two connections.

just create your connection strings for on both servers.

and then in the script, you can load data from both data bases, or you can make a condition.

in the below script, will check if connection1 is not established then read from second, else from first

set script error =0;

Connecting1

if scripterror = 0

then

Load * from table  //load the data

else

Connecting string 2

Load * from table  //load the data