topic Re: OLEDB connection close in QV in QlikView

OLEDB connection close in QV

Thu, 28 Nov 2013 07:30:06 GMT

Hi,

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?

Re: OLEDB connection close in QV

jonathandienst — Thu, 28 Nov 2013 07:55:43 GMT

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

Re: OLEDB connection close in QV

Thu, 28 Nov 2013 08:17:30 GMT

Thank you Jonathan