DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2300599 - Last Review: August 25, 2010 - Revision: 1.0

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  (http://support.microsoft.com/kb/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:

SqlCeTransaction Class (http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlcetransaction(VS.90).aspx)

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  (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

APPLIES TO
  • Microsoft SQL Server Compact 3.5
Keywords: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2300599
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support