Memory usage issue with SQL toolkit

[TiTou]

Hi all,

(duplicated post from LAVA)

I developped a relatively small application in LV 7.1.1 that saves data every 5 sec to a DataBase (MSSQL) using SQL toolkit.
This is the first time I use this toolkit and my knowlegde regarding DataBase is really poor so I might just be doing a beginner's mistake.


Here is the issue :
If I disable the "write to DataBase" functions my application can run forever without any trouble an its memory usage in thet task manager is 34120K and will not move of a byte.

If I enable the "write to DataBase" functions, the memory usage will slowly increase, then the system starts using Virtual Memory, and after 15 days (approximately), the max amount of virutal memory allowed is met, the PC crashes down and has to be restarted.

Obviously I must be making a bad use of SQL VIs...
So, is there any "common silly mistake" to avoid when writing data to MSSQL DataBase ?
If needed I can upload my code...

Thanks for any help.

[TiTou]

NI support pointed me this link 
I installed the patch and re-ran the soft.
In a couple of hours I'll be able to tell you if it solves the issue... stay in tune...