Monday, August 3, 2009

SQL Compact 3.5 SP1 downloadable hotfix list

A number of SQL Compact 3.5 hot fixes have been released recently and are publicly available at the Microsoft support site. The table below gives an overview of the hotfixes. Note that the hotfixes are cumulative, meaning that the latest hotfix contains all previous hotfixes. Some hotfixes are only applicable for a particular platform, however. All hotfixes apply to SQL Compact 3.5 SP1, version 3.5.5692.0.

The number column indicates the revision number, so 7 would be version 3.5.5692.7 and so on.

No KB Title Platforms
1 958478 Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses" x86, x64
2 959697 Error message when you try to open a database file from a CD in SQL Server Compact 3.5 with Service Pack 1: "Internal Error using read only database file" x86
3 963060 An error message is logged, and the synchronization may take a long time to finish when you synchronize a merge replication that contains a SQL Server Compact 3.5 subscriber: "UpdateStatistics Start app=<UserAppName>.exe"
UPDATE: More info about required code changes and new api here
x86, wce4, wce4-ppc, wce5, wce5-ppc
5 967963 Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5 wce5, wce5-ppc
7 968864 Error message when you run a query in SQL Server Compact 3.5: "The column name cannot be resolved to a table. Specify the table to which the column belongs" x86, wce5-ppc, wce5-phone
7 969858

FIX: Non-convergence occurs when you synchronize a SQL Server Compact 3.5 client database with the server by using Sync Services for ADO.NET in a Hub-And-Spoke configuration

Same fix as above
9 970269 FIX: Access violations occur when you run an application under heavy load conditions after you install the 64-bit version SQL Server Compact 3.5 Service Pack 1 x64
11 970414 FIX: Initial synchronization of a replication to SQL Server Compact 3.5 subscribers takes significant time to finish wce4-ppc, wce5-ppc
11 971273

You do not receive error messages when you run a query in a managed application that returns columns of invalid values in SQL Server Compact 3.5

wce5, wce5-ppc
12 971027 FIX: Error message when you upgrade a very large database to SQL Server Compact 3.5: "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only" x86, x64
12 972002 FIX: Error message when you try to create an encrypted database in SQL Server Compact 3.5: "The operating system does not support encryption" x86
13 972390 FIX: The application enters into an infinite loop when you run an application that uses Microsoft Synchronization Services for ADO.NET to synchronize a SQL Server Compact 3.5 database½ x86
14 974068 FIX: Error message when an application inserts a value into a foreign key column in SQL Server Compact 3.5: "No key matching the described characteristics could be found within the current range" x86, x64

 

Please let me know if there are errors or omissions.

No comments: