Microsoft KB Archive/330971

= SQL Server 2000 Windows CE Edition 2.0 for Visual Studio .NET 2003 =

Article ID: 330971

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition 2.0

-



This article was previously published under Q330971



SUMMARY
SQL Server CE and SQL Server CE Books Online are included with Microsoft Visual Studio .NET 2003. This article discusses issues that might occur when you use SQL Server CE 2.0 with Visual Studio .NET 2003.



Side-by-Side Installations
Side-by-side installations of this release of SQL Server CE 2.0 with earlier versions of SQL Server CE are supported. However, if you have a previous beta version of SQL Server CE 2.0 installed, you must remove the beta version before you install this final release version. For more information about removing a beta version of SQL Server CE 2.0, see the &quot;How to Remove SQL Server CE&quot; section of this article.

Note: If you have a beta version of SQL Server CE 2.0 installed, you are prompted to remove it as part of the setup process.

Supported Versions of Microsoft Windows
SQL Server CE 2.0 is supported on computers that are running Microsoft Windows 2000 or Microsoft Windows XP. Microsoft Windows NT 4.0 is supported only for SQL Server CE 2.0 Server Tools installations.

Installation Requirements
For installation requirements for SQL Server CE 2.0, visit the following Microsoft Web site:

http://www.microsoft.com/sql/ce/productinfo/sysreq.asp

How to Remove SQL Server CE
The only way to remove SQL Server CE is to remove Microsoft Visual Studio .NET. However, if you have also installed Microsoft SQL Server CE 2.0 Server Tools, you must remove it separately. To remove SQL Server CE 2.0 Server Tools, follow these steps:


 * 1) In Control Panel, double-click Add or Remove Programs.
 * 2) In the Add or Remove Programs window, click to select Microsoft SQL Server CE 2.0 Server Tools from the list of installed programs.
 * 3) Click Remove.

Note You can also use these steps to remove a beta version of SQL Server CE 2.0 Server Tools. However, if you have a beta version of SQL Server CE 2.0 Server Tools installed, you are prompted to remove it as part of the setup process.

Incorrect Deployment Warning
When you deploy a SQL Server CE 2.0 application to a Pocket PC device, you might receive a warning with the following error text:

Files in the package 'sqlce.ppc3.arm.cab' are more recent on the device than on the development computer. Consider upgrading to the latest version. Files affected are: Sscemw20.dll

The warning is wrong and you can ignore it. The file on the device is actually correct, as is the one in the .cab file on the desktop.

Encryption
For more information about encryption and SSL with SQL Server CE, see the following article in the Microsoft Knowledge Base:

814852 INF: How to Enable Encryption Support for SQL Server CE Databases

Encryption is not supported on Handheld PC 2000-based devices. Encryption is also not supported in emulation.

Addition Error on a MIPS Pocket PC-based Device
When two large numbers, one of type bigint and the other of type float, with approximately the same absolute value are added, the result that should return is 0. However, on the MIPS Pocket PC-based device, the result that is returned is -1024.

The CONSTRAINT Keyword Must Be Preceded by a Comma
When you create a constraint programmatically by using SQL Server CE, you must separate the column data type from the CONSTRAINT keyword with a comma. The following example creates a primary key constraint over two columns in a table:

CREATE TABLE MyTable (col1 int, col2 int, CONSTRAINT PK_MyConstraint PRIMARY KEY (col1, col2))

This requirement differs from the Transact-SQL behavior in SQL Server 2000.

Changes in System.Data.SqlServerCe Namespace
Since the previous release of the Microsoft .NET Compact Framework, there have been several changes of class names in the System.Data.SqlServerCe namespace, as shown in the following table.

Installation Location for the IBuySpy Delivery Sample Application
After Visual Studio .NET is installed, the IBuySpy Delivery sample application is located at \Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\Samples\VB\Pocket PC\IBuySpyDelivery, where \Program Files\Microsoft Visual Studio .NET 2003 represents the root installation directory for Visual Studio .NET.

C# Version of IBuySpy Delivery Is Not Included with Visual Studio .NET
A C# version of the IBuySpy Delivery sample application is not included with Visual Studio .NET. Only the Visual Basic .NET version of this sample is installed. To download a C# version of this sample, visit the following Microsoft Web site:

GotDotNet User Sample: IBuySpy Delivery C# Sample

SQL Server CE Books Online
If you have Visual Studio .NET 2003 installed, you can open SQL Server CE Books Online by double-clicking the Sqlce.chm file that is located in the CompactFrameworkSDK\v1.0.5000\Windows CE folder. By default, this folder is installed in C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE.

Information about SQL Server CE 2.0 that was not available when the SQL Server 2000 Windows CE Edition Version 2.0 Readme.txt file was published is provided in the following Microsoft Knowledge Base article:

327957 INF: SQL Server 2000 Windows CE Edition Version 2.0 Readme.txt Additions

Keywords: kbproductlink kbinfo KB330971

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.