Not enough storage is available to complete this operation
I get this exception after awhile of browsing thru my application, i dunno what causes this because it never happens in the same place. I would like to know if anyone else is experiencing this situation and if there is a solution.
SqlCeException
Not enough storage is available to complete this operation.
em System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
em System.Data.SqlServerCe.SqlCeConnection.Open()
em System.Data.SqlServerCe.SqlCeConnection.Open()
em System.Data.Common.DbDataAdapter.QuietOpen()
em System.Data.Common.DbDataAdapter.FillInternal()
em System.Data.Common.DbDataAdapter.Fill()
em System.Data.Common.DbDataAdapter.Fill()
The problem is actually because of DLL Squeeze. To get around this problem, please open a connection to SQL Server Mobile database at the very beginning of your application.
[Note: You will face this problem on the very first instance of accessing SQL Server Mobile that is when we load all our binaries and if there is not enough memory we will fail with the above error]
Thanks,
Laxmi
I get the same message but it is not on my first connection to the database. I am opening and closing connections to fill drop down lists with typed datasets using table adapters throughout my application. Everything seems to go ok until durring one search I try to fill a table with one row of about 25 columns.
Is a strongly typed dataset of 1 row and 25 columns too much to hold in memory on a mobile device? Also I only seem to have the problem with the emulators.
Thanks,
Patrick
