SQL Server CE 2.0 Readme
The SQL Server documentation team cannot answer technical support questions, but welcomes your suggestions and comments about this readme documentation. You can quickly and directly send e-mail feedback. All feedback must be in English.
1.0 Introduction
This Readme file provides information about SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) that is not included in SQL Server CE Books Online. To open the SQL Server CE Books Online, double-click Sqlce.chm.
Visual Studio .NET
SQL Server CE and SQL Server CE Books Online will be shipped with the next release of Microsoft Visual Studio® .NET.
Note: This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.
If you have this release of Visual Studio .NET installed, you can open SQL Server CE Books Online by double-clicking Sqlce.chm located in the CompactFrameworkSDK\v1.0.330 folder. By default, this folder is installed in C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.330.
For information about this release, go to this Microsoft Web site.
1.1 Additional Information About SQL Server CE 2.0
Information about SQL Server CE 2.0 that was not available when this Readme file was published is provided in Knowledge Base article Q327957 at this Microsoft Web site.
General product information about SQL Server CE is available at this Microsoft Web site.
2.0 Installation Issues
This section describes issues relating to the installation and setup of SQL Server CE 2.0.
2.1 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. If you have a previous beta version of SQL Server CE 2.0 installed, however, you must remove this beta version prior to installing this final release version. For more information about removing a beta version of SQL Server CE 2.0, see 2.4 Uninstalling SQL Server CE.
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.
2.2 Supported Versions of Windows
SQL Server CE 2.0 is supported on computers running Microsoft Windows 2000 and Windows XP. Microsoft Windows NT 4.0 is supported only for SQL Server CE 2.0 Server Tools installations.
2.3 Installation Requirements
To develop SQL Server CE-based applications, you can use either Microsoft eMbedded Visual Tools or Microsoft Visual Studio .NET, which includes the Microsoft .NET Compact Framework. Each development environment has its own requirements.
Note SQL Server CE 2.0 does not support installation to a mapped drive. To install on a remote computer, copy the installation files to the remote computer and then run setup locally from that computer.
2.3.1 Setup for eMbedded Visual Tools
Before you install SQL Server CE for use with the eMbedded Visual Tools development environment, you must:
1. | Install Microsoft eMbedded Visual Tools 3.0 and at least one of the following software development kits: Microsoft Windows Powered Pocket PC 2002, Pocket PC, or Handheld PC 2000. Microsoft eMbedded Visual Tools 3.0 can be downloaded from this Microsoft Web site. | ||||||||||||||
2. | Upgrade to Microsoft ActiveSync 3.5 or later. Microsoft ActiveSync can be downloaded from this Microsoft Web site. | ||||||||||||||
3. | Verify that you have Administrator access on the target system and that the Administrators group has change permission on the installation directory. | ||||||||||||||
4. | Install Development Tools on the computer that you will use to develop your SQL Server CE-based applications, and install Server Tools on the computer that you will use as the server running Microsoft Internet Information Services (IIS). SQL Server CE Setup prompts you for a Development Tools or a Server Tools installation. If the development computer and the computer running IIS are the same, you can install both Development Tools and Server Tools.
|
To install SQL Server CE on a Pocket PC-based, Pocket PC 2002-based, or Handheld PC 2000-based device, use either the eMbedded Visual Basic procedure or the manual procedure described in SQL Server CE Books Online. The Include and Lib files for SQL Server CE are located in the Lib and Inc subdirectories of the SQL Server CE installation directory. The Include and Lib files for OLE DB for SQL Server CE are located in the Include and Lib subdirectories of the Dataaccess31 folder. Use the Lib file that matches the processor and platform for which you are compiling.
Note: Using ADOCE through Microsoft eMbedded Visual C++® is not a supported means for accessing SQL Server CE.
2.3.2 Setup for Visual Studio .NET
To develop SQL Server CE-based applications using Visual Studio .NET and the accompanying classes of the .NET Compact Framework, you must have the following installed:
On the development computer:
| • | Microsoft Windows 2000 or later |
| • | Microsoft Visual Studio .NET |
| • | Microsoft ActiveSync 3.5 or later |
On the device:
| • | Microsoft Windows CE, Pocket PC, or Pocket PC 2002 |
For more information, go to this Microsoft Web site.
2.4 Uninstalling SQL Server CE
To uninstall SQL Server CE 2.0:
1. | In Control Panel, double-click Add/Remove Programs. |
2. | Select Microsoft SQL Server CE 2.0 Development Tools and Microsoft SQL Server CE 2.0 Server Tools from the list of installed programs. |
3. | Click Remove. |
Note: The preceding steps can also be used to uninstall a beta version of SQL Server CE 2.0. However, 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.
3.0 General SQL Server CE Issues
This section describes issues related to security, connectivity, the database engine, SQL Server CE Query Analyzer, and error messages.
3.1 Encryption
Encryption is supported on Pocket PC-based devices.
To enable encryption on Pocket PC 2000 devices, you must install the Microsoft High Encryption Pack available at this Microsoft Web site.
To enable Secure Sockets Layer (SSL) support in Pocket PC 2002, use the rsaenh.PPC2002ARM.CAB file. By default, it is installed in C:\Windows CE Tools\wce300\Pocket PC 2002\support\EnhancedCrypto folder.
For more information, refer to the "Advanced Cryptographic Support for Your Pocket PC 2002 Applications" topic in Pocket PC 2002 SDK Books Online.
3.2 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 returned should be 0. However, on the MIPS Pocket PC-based device, the result returned is -1024.
3.3 CONSTRAINT Keyword Must Be Preceded by a Comma
When you create a constraint programmatically using SQL, 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.
4.0 Visual Studio .NET Issues
This section describes issues with SQL Server CE 2.0 related to Visual Studio .NET and the .NET Compact Framework.
Note This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.
4.1 Changes in System.Data.SqlServerCe
Since the previous release of the .NET Compact Framework, there have been several changes of class names in the System.Data.SqlServerCe namespace, as shown in the following table.
| Previous release | Current release |
Engine | SqlCeEngine |
Replication | SqlCeReplication |
RemoteDataAccess | SqlCeRemoteDataAccess |
4.2 IBuySpy Delivery Sample Application
This section contains additional information about the IBuySpy Delivery sample application that ships with SQL Server CE 2.0.
4.2.1 Install 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.
4.2.2 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. You can download a C# version of this sample at this Microsoft Web site.