SqlCe Error?"Not Enough Storage "

  • Thread starter Thread starter Altan Tunaboylu
  • Start date Start date
A

Altan Tunaboylu

Hi,
i'm using sqlce 2.0.i've got 2 sqlce File.One of them 400KB,one of them
1.4MB
i've got this error Randomly:
8007000E
Not Enough Storage is available to complete this operation.
i'm usig a lots of SqlCeDataReaderAbsolutely,i'm using "myReader.dispose();"
, end of code.
What can i do other?What is problem ? :((
thanx
<altan>
 
You have to check memory status(in [System]-[Setting]) during your program
running.
Do you do anything between these two db?

You may try
myReader=null;
after myReader is no more used.
Object set to null will be collected by GC immidately, but Dispose() it
depends.

After set to null, if the memory still be occupied, maybe you
have to check other object you used.

Best Regards,
Jan Yeh
 
While you might think that something like object = null will cause immediate
garbage collection... it doesn't. These kinds of statements only mark the
block of memory for collection - not immediately collect it.

Remember the purpose of 'managed' code is to take memory management off your
development plate... there are very few ways to interface with the collector
(see GC. Collect()) or manage memory yourself (see un-managed code).

Your problem could be simply from the settings on the device - and not
allocating enough space for running programs.

For a great reference... see the tutorial on garbage collection at:
http://www.dotnetextreme.com/articles/garbageCollector.asp

For a great garbage collection study...
http://www.c-sharpcenter.com/Tutorial/GC.htm

Rick Winscot
rickly@zyche dot com
 
Back
Top