About two database connections

[#1]

In Qlikview can we connect with two database at a time?If no why ?

[joshabbott]

Not at the same time, but in the same script, which I imagine is what you want to do.  Make a connection to a DB, and then any code or script under that connection (or in tab's to the right) will use that connection.  When you want another connect, make that connection after all the script that uses the first connection.  For instance:

Connection String #1

Script for #1

More Script #1

Connection String #2

Script for #2

More Script #2

Etc...

[aveeeeeee7en]

Hi Sreedhar

At a time, there will be only one Connection Active.

You can use Number of Connect Commands to fetch Data.

You can also Connect to one Database and Store files from that database in your system than disconnect the database. After this, again connect to a new database in the similar way than store and disconnect and so on.

eg.

1st Database:

ODBC Connect to .........

ABC

Load

.....

....

From

Store ABC into ..../.qvd(qvd);

Disconnect;

2nd Database:

ODBC Connect to .........

XYZ

Load

.....

....

From

Store XYZinto ..../.qvd(qvd);

Disconnect;

Hope that helps you and cleared some of your doubts.

Regards

Aviral Nag

[maxgro]

not at the same time because in Qlik, when you extract some data from a database (with the statement sql select ......) you're connected to the database (one database) of the last connect statement (oledb connect, odbc connect, ...)

[#5]

Thanx Josh for ur reply i got the point