theKindOfMe

April 20, 2010

SqlCeException Unspecified error [ 655360 ]

Filed under: Uncategorized — Tags: , — yasi8h @ 12:44 pm

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”;

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: