when will the OLEDB connection gets closed in QVW, is it after closing the QVW?
Is there a way to explicitly close the OLEDB connection in Qlikview?
I have data to be loaded from multiple table but i need to re-open the connection while fetching the data from each table, to avoid qvd refresh issues since the data is huge.
If I use the same connection string for each table, will the previous connection be close automatically?
Yes, It is closed automatically when the load script finishes, or another connection is created. You can close it manually with DISCONNECT.
I am not sure that there would be any advantages (and I can think of some disadvantages) with disconnect and reconnecting for each table, but you could do this:
...
OLEDB CONNECT .....;
SQL SELECT .... FROM table1;
DISCONNECT;
OLEDB CONNECT .....;
SQL SELECT .... FROM table2;
DISCONNECT;
...
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Yes, It is closed automatically when the load script finishes, or another connection is created. You can close it manually with DISCONNECT.
I am not sure that there would be any advantages (and I can think of some disadvantages) with disconnect and reconnecting for each table, but you could do this:
...
OLEDB CONNECT .....;
SQL SELECT .... FROM table1;
DISCONNECT;
OLEDB CONNECT .....;
SQL SELECT .... FROM table2;
DISCONNECT;
...
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
