topic Re: Can we add multiple Oledb connection strings in the include statement in QlikView

Can we add multiple Oledb connection strings in the include statement

varunreddy — Wed, 07 Feb 2018 21:51:42 GMT

Hi All,

I am trying to create a notepad with multiple "OLEDB" connection strings.

Now I am trying do a include statement and use these OLEDB connection string to load data from those tables.

When I try to load the QVW, I see that all the OLEDB connections are running successfully, but I get the warning "Table or View doesn't exist".

Is there a way we can add multiple connection strings?

Cheers!

maxgro — Wed, 07 Feb 2018 22:57:17 GMT

You can only have one OLEDB active connection at a time.

Usually an include has one connection string

You can manage different connections in this way

// include for oracle db connection, 1 file

$(Must_Include=ConnOracle.qvs);

// select Oracle db tables

select .....

// include for sql server db connection, 1 file

$(Must_Include=ConnSqlServer.qvs);

// select Sql Server db tables

select .....