Memory Usage Problem

[Alan Cheuk]

I am using LabVIEW 7.0 and the database toolkit. I build a program to perform data acquisition and save the collected data into a Microsoft Access database (with Microsoft Jet 4.0 OLE DB Provider). The main VI is used to perform data acquisition and the collected data is passed into a subVI for saving. After I run the program for a few days, I receive a warning that my system memory is in a low level and the program is stopped. I find a problem that the data saving subVI will occupy more and more memory and will not release it until I close the main program. There ia an article (under ni.com named “Why Does My LabVIEW Application Leak Memory when Logging to an Access Database?”) stated that this problem is a behavior of Access and not a problem in the database toolkit. I follow the instructions to set the “MaxBufferSize” to a small value but the problem still occurs.

Does anyone know how to solve this problem? The attached picture shows the content of my data saving subVI. Am I made a wrong programming? Thanks

ni article : http://digital.ni.com/public.nsf/websearch/862567530005F09E862568020079A9B7?OpenDocument

microsoft article: http://support.microsoft.com/kb/154384/en-us

 

[Wiebe@CARYA]

Some long shots that come to mind:


Some Access ODBC drivers have leaks in them. Try to update to the newest.
The Close reference is suspicious. Perhaps the reference is not closed when there is an error? (I can't image they build it like that, but you never know...)


Hope it helps.


Regards,


Wiebe.




"Alan Cheuk" <x@no.email> wrote in message news:1140752442139-329683@exchange.ni.com...
I am using LabVIEW 7.0 and the database toolkit. I build a program to perform data acquisition and save the collected data into a Microsoft Access database (with Microsoft Jet 4.0 OLE DB Provider). The main VI is used to perform data acquisition and the collected data is passed into a subVI for saving. After I run the program for a few days, I receive a warning that my system memory is in a low level and the program is stopped. I find a problem that the data saving subVI will occupy more and more memory and will not release it until I close the main program. There ia&nbsp;an article (under ni.com named ?Why Does My LabVIEW Application Leak Memory when Logging to an Access Database??) stated that this problem is a behavior of Access and not a problem in the database toolkit. I follow the instructions to set the ?MaxBufferSize? to a small value but the problem still occurs.


&nbsp;&nbsp;


Does anyone know how to solve this problem? The attached picture shows the content of my data saving subVI. Am I made a wrong programming? Thanks


&nbsp;


&nbsp;


ni article : <a href="http://digital.ni.com/public.nsf/websearch/862567530005F09E862568020079A9B7?OpenDocument" target="_blank">http://digital.ni.com/public.nsf/websearch/862567530005F09E862568020079A9B7?OpenDocument</a>


microsoft article: <a href="http://support.microsoft.com/kb/154384/en-us" target="_blank">http://support.microsoft.com/kb/154384/en-us</a>


&nbsp;



pic.jpg:
http://forums.ni.com/attachments/ni/170/169640/1/pic.jpg