SqlCeException Unspecified error [ 655360 ]

I spend a fair amount of time searching the net for this. All because i couldn’t notice the Native Error: 25101 in the exception.

SSCE_M_OUTOFBUFFERPOOLSPACE
SQL Server Compact has exceeded the buffer size. The default size can be increased on initialization by modifying the ssce: max buffer size property.

from: http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring(VS.80).aspx

max buffer size
The largest amount of memory, in kilobytes, that SQL Server Mobile can use before it starts flushing changes to disk. If not specified, the default value is 640.

You can try increasing your buffer size.

conn.ConnectionString =
“Persist Security Info = False; Data Source = ‘SalesData.sdf’;” +
“Password = ‘
‘; File Mode = ‘shared read’; ” +
“Max Database Size = 256; Max Buffer Size = 1024″;

Getting a PropertyInfo from a PropertyDescriptor in .NET

PropertyDescriptor pd;
PropertyInfo pi;

//when pd is actually pointing to some real Property Descriptor object
pi = pd.ComponentType.GetProperty(pd.Name);