Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 .....