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

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 "How to Remove SQL Server CE" 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.

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.

SQL Server CE Issues

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:


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:
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:

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.

IBuySpy Delivery Sample Application

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 (http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=95d10225-1446-43d5-b3bd-7cd1dc4ebfdd)

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: