You are currently offline, waiting for your internet to reconnect

FIX: Heap corruption occurs when you use SQL Server Compact 3.5 Service Pack 2

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SYMPTOMS
Assume that you have an application that uses the following pattern to commit a transaction to a SQL Server Compact 3.5 database on a computer that is running SQL Server Compact 3.5 Service Pack 2:

using (SqlCeTransaction transaction = connection.BeginTransaction(IsolationLevel.Serializable)) {... transaction.Commit(CommitMode.Deferred); }
In this scenario, the application may crash intermittently.

CAUSE
The issue occurs because an error in SQL Server Compact 3.5. In certain situations, the internal class System.Data.SqlServerCe.Accessor may experience a heap corruption.
RESOLUTION
The hotfix that resolves this problem is included in cumulative update package 2 for SQL Server Compact 3.5 Service Pack 2.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

2289547 Cumulative Update 2 for SQL Server Compact 3.5 Service Pack 2
MORE INFORMATION
For more information about SqlCeTransaction Class, visit the following Microsoft website:


STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
REFERENCES
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Properties

Article ID: 2300599 - Last Review: 08/25/2010 16:05:00 - Revision: 1.0

Microsoft SQL Server Compact 3.5

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2300599
Feedback
'true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >