Cumulative Update 1 for SQL Server Compact 3.5 Service Pack 2

Article ID: 982841 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

Cumulative Update 1 for SQL Server Compact 3.5 Service Pack 2 contains hotfixes for the Microsoft SQL Server Compact 3.5 issues that are fixed since the release of SQL Server Compact 3.5 Service Pack 2.

Note This build of the cumulative update package is also known as build 3.5.8081.00.

We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server Compact 3.5 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix.
Back to the top | Give Feedback

MORE INFORMATION

How to obtain Cumulative Update 1 for SQL Server Compact 3.5 Service Pack 2

A supported cumulative update package is now available from Microsoft. However, this update package s intended to correct only the problems that are described in this article. Apply this cumulative update package only to computers that are experiencing these problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server Compact 3.5 service pack that contains the hotfixes in this cumulative update package.

If the cumulative update package is available for download, you will view a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note If additional issues occur or if any troubleshooting is required, you may have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
Back to the top | Give Feedback

Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.

For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Collapse this tableExpand this table
VSTS bug numberKB article numberDescription
446975982565
(http://support.microsoft.com/kb/982565/ )
FIX: "An SqlCeParameter with ParameterName '<Parameter Name>' is not contained by this SqlCeParameterCollection" error message when you use the .NET Compact Framework Data Provider for SQL Server Compact to access SQL Server Compact 3.5

Cumulative update package information

Prerequisites

There are no prerequisites for installing this cumulative update.

Restart information

You may have to restart the computer after you apply this cumulative update.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Back to the top | Give Feedback

File information


The English version of this cumulative update package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For all supported 32-bit versions of SQL Server Compact 3.5 Service Pack 2
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
System.data.sqlserverce.entity.dll3.5.8081.0231,28031-May-201017:16x86
System.data.sqlserverce.dll3.5.8081.0296,81631-May-201017:16x86
Policy.3.5.system.data.sqlserverce.dll3.5.8081.010,09631-May-201017:16x86
Policy.3.5.system.data.sqlserverce.entity.dll3.5.8081.010,09631-May-201017:16x86
Sqlceca35.dll3.5.8081.0342,38431-May-201017:14x86
Sqlcecompact35.dll3.5.8081.083,31231-May-201017:14x86
Sqlceer35en.dll3.5.8081.0147,31231-May-201017:14x86
Sqlceme35.dll3.5.8081.063,34431-May-201017:14x86
Sqlceoledb35.dll3.5.8081.0169,32831-May-201017:14x86
Sqlceqp35.dll3.5.8081.0640,88031-May-201017:14x86
Sqlcese35.dll3.5.8081.0361,84031-May-201017:14x86
System.data.sqlserverce.dll3.5.8081.0296,81631-May-201017:17x86
Microsoft.synchronization.data.dll1.0.1208.0115,74431-May-201009:32x86
Microsoft.synchronization.data.server.dll1.0.1208.0115,74431-May-201009:32x86
Microsoft.synchronization.data.sqlserverce.dll3.5.8081.092,01631-May-201017:16x86
For all supported 64-bit versions of SQL Server Compact 3.5 Service Pack 2
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
System.data.sqlserverce.entity.dll3.5.8081.0231,28031-May-201017:22x86
System.data.sqlserverce.dll3.5.8081.0296,81631-May-201017:22x86
Sqlceca35.dll3.5.8081.0573,29631-May-201017:21x64
Sqlcecompact35.dll3.5.8081.0117,61631-May-201017:21x64
Sqlceer35en.dll3.5.8081.0147,82431-May-201017:21x64
Sqlceme35.dll3.5.8081.089,45631-May-201017:21x64
Sqlceoledb35.dll3.5.8081.0257,39231-May-201017:21x64
Sqlceqp35.dll3.5.8081.01,131,37631-May-201017:21x64
Sqlcese35.dll3.5.8081.0670,57631-May-201017:21x64
Microsoft.synchronization.data.dll1.0.1208.0115,74431-May-201009:32x86
Microsoft.synchronization.data.server.dll1.0.1208.0115,74431-May-201009:32x86
Microsoft.synchronization.data.sqlserverce.dll3.5.8081.092,01631-May-201017:22x86
System.data.sqlserverce.dll3.5.8081.0296,81631-May-201017:22x86
System.data.sqlserverce.entity.dll3.5.8081.0231,28031-May-201017:22x86
SQL Server Compact 3.5 Service Pack 2 for Windows CE 5.0 on Armv4i-based pocket PC devices
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Sqlce.dev.enu.ppc.wce5.armv4i.cabNot Applicable102,45531-May-201019:27Not Applicable
Sqlce.ppc.wce5.armv4i.cabNot Applicable763,72731-May-201019:27Not Applicable
Sqlce.repl.ppc.wce5.armv4i.cabNot Applicable340,63331-May-201019:27Not Applicable

How to install the cumulative update package for 32-bit and 64-bit desktop versions of SQL Server Compact 3.5 Service Pack 2

To install the cumulative update package, follow these steps:
  1. Download and locate the SSCERuntime-ENU.exe file.
  2. Double-click the SSCERuntime-ENU.exe file to start the extraction process.
  3. In the SQL Server Compact 3.5 SP2 Self-Extractor dialog box, specify the folder to contain the extracted files, and then click OK.
  4. Move to the extraction folder that you set in step 3.
  5. Double-click the SSCERuntime_x86-ENU.msi file or the SSCERuntime_x64-ENU.msi file, and then follow the setup instructions.
On 64-bit computers, install both the 32-bit and the 64-bit versions of the SQL Server Compact 3.5 SP2 CU1 MSI files. Existing SQL Server Compact 3.5 applications may fail if the 32-bit version of the MSI file is installed on a 64-bit computer. Developers should attach both the 32-bit and the 64-bit MSI files together with their applications and install both on 64-bit computers. For more information, refer to Microsoft Knowledge Base (KB) article 974247
(http://support.microsoft.com/kb/974247)
or the Install.txt file that is extracted together with the MSI files.

How to install the cumulative update package for SQL Server Compact 3.5 Service Pack 2 for Windows CE 5.0 on Armv4i-based pocket PC devices

To install the cumulative update package, follow these steps:
  1. Download the cumulative update package for your system.
  2. Extract the .cab files from the cumulative update package.
  3. On the device, install the three .cab files.

How to uninstall the cumulative update package for 32-bit and 64-bit desktop versions of SQL Server Compact 3.5 Service Pack 2


To uninstall the cumulative update package, follow these steps:
  1. In Control Panel, open the Add or Remove Programs item.

    Note     If you are using Windows 7, in Control Panel, open the Programs and Features item.
  2. Find the entry that corresponds to “Microsoft SQL Server Compact 3.5 SP2 ENU” and “Microsoft SQL Server Compact 3.5 SP2 X64 ENU”. Then, right-click each of them and select “Uninstall” to uninstall the cumulative update.
Because SQL Server Compact cumulative updates install the whole product, step 2 will also uninstall SQL Server Compact 3.5. If you want to install SQL Server Compact 3.5 SP2 again, you must install the MSI files one more time. You can download the MSI files at the following URL:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e497988a-c93a-404c-b161-3a0b323dce24
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e497988a-c93a-404c-b161-3a0b323dce24)
Back to the top | Give Feedback

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
Back to the top | Give Feedback

Properties

Article ID: 982841 - Last Review: October 18, 2010 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server Compact 3.5
Keywords: 
kbhotfixrollup kbhotfixserver kbautohotfix kbexpertiseadvanced kbsurveynew kbfix kbqfe KB982841
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top