Multiple database connections with OLEDB

[#1]

Hi All,

I would like to connect to 2-3 databases first and then run the scripts in other tabs. Does Qlikview allow it?

For example:

Database Connections tab

OLEDB Connection 1

OLEDB Connection2

Script tab 1

Script that needs DB connection 1

Script tab 2

Script that needs DB connection 2

Script tab 3

Script that needs DB connection 1

Can scripts jump from connection to connection or does it have to be as below?

Database Connections tab

OLEDB Connection 1

Script tab 1

Script that needs DB connection 1

Script tab 2

Script that needs DB connection 1

Database Connections tab

OLEDB Connection 2

Script tab 3

Script that needs DB connection 2

Thoughts/ suggestions?

Thank you.

[Gysbert_Wassenaar · Accepted solution]

Qlikview can be connected to only one data source at a time. So you need to connect to the correct data source first before getting data from it. So your second setup will work while the first will fail because the first connection is disconnected because right after the second connection is made. That will make the code on the first script tab to fail.

[#3]

Thank you for your response.