Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory Leaks SQL CE 3.0 Expand / Collapse
Author
Message
Posted Wednesday, January 9, 2008 2:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2008 4:12 PM
Points: 1, Visits: 5
Hi,

I am working with SQLCE3.0 and when I use a lot of times an SQLCEDataAdapter.Fill() my application has the exception "Not enough storage is available to complete this operation...". I am sure I dispose all the objects, the SqlCeCommand, SqlCeDataAdapter etc..

Does anybody know what should I do to fix this?

Please I am desperate!!!! I have six months with this problem.

Thanks
Post #440916
Posted Wednesday, April 16, 2008 10:50 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:03 AM
Points: 79, Visits: 211
From what I know, SQLCEDataAdapter has performance issue, it drains the memory fast. since you are using sql CE 3.0, why don't you use SqlCeResultSet Class . Here's a another post on MSDN.
Post #486105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse