SQL Server 2000 Windows CE Edition 2.0 OS Design Development (Windows CE 5.0)

Artículo
09/14/2012

Microsoft® SQL Server™ 2000 Windows® CE Edition 2.0 (SQL Server CE) extends Microsoft SQL Server to Microsoft Windows CE-based mobile devices. SQL Server CE delivers relational database functionality, including a data store, a query processor, and scalable connectivity capabilities, all in a small footprint.

The following list shows the two methods that SQL Server CE supports for connecting to, and exchanging data with, a data source:

Remote data access (RDA)
Merge replication

These connectivity solutions use the authentication, authorization, and encryption services of Microsoft Internet Information Services (IIS). The connectivity can be performed over wired and wireless LANs and WANs. To communicate with SQL Server using the network connection on a desktop computer, you can configure Microsoft ActiveSync® 3.1 or later with SQL Server CE Relay. SQL Server CE Relay plugs into ActiveSync versions 3.0 and earlier. It allows Pocket PC 2000 and lower to connect to remote resources by using the desktop IP. This eliminates the requirement for the Windows CE-based device to have a network card or modem.

When the Windows CE-based device does not contain network connectivity, ActiveSync can be used to connect to the server environment. When you use Microsoft ActiveSync 3.5 or later with a Pocket PC 2002 device, you can directly access SQL Server through the network connection of the desktop computer by using serial, infrared, or USB connections. Other device and ActiveSync combinations require SQL Server CE Relay to be configured on the desktop computer.

SQL Server CE Books Online is the online documentation provided with Microsoft® SQL Server™ 2000 Windows® CE Edition 2.0.

OS Design Information

The following table shows operating system design information for SQL Server CE.

Element	Information
Dependencies	Microsoft Internet Information Services (IIS). Ethernet, Wireless LAN, or Wireless WAN that are configured to support HTTPs.
Hardware considerations	None.

Modules and Components

SQL Server CE contains native and managed modules. The managed modules have a dependency on the native components and the .NET Compact Framework.

The following table shows the components and modules that implement SQL Server CE.

Item	Module	Component
Native SQL Server CE	ssceca20.dll (Client Agent), ssce20.dll (Engine), ssceerror20en.dll (English error strings), ssceerror20jp.dll (Japanese error strings)	None
Managed SQL Server CE	sscemw20.dll (Managed wrapper), dbnetlib.dll, system.data.sqlserverce.dll, system.data.sqlclient.dll, system.data.common.dll	None

SQL Server CE Implementation Considerations

You can include the SQL Server CE Catalog item in your OS design by choosing the item from the Catalog. Choosing this Catalog item sets the appropriate Sysgen variable for enabling SOL Server CE.

The following table shows the Sysgen variables that enables the SQL Server CE functionality listed.

Sysgen variable	Description
SYSGEN_SQL2000_DP	When this variable is set, the SQL Server 2000 .NET Data Provider is included in the run-time image. This Catalog item includes the Compact Framework, the files required to support it, and the Microsoft SQL Server™ 2000 data provider. The data provider connects to, executes commands in, and retrieves results from SQL Server version 7.0 and later databases. To enable this functionality, the following Catalog items must also be included in your OS design: C++ Exception Handling Cryptography Services (Crypto API 1.0) with High Encryption Provider Windows Internet Services This Catalog item is available only in display-based devices.
SYSGEN_SQLCE20_DP	When this variable is set, .NET Data Provider is included in the run-time image. This Catalog item includes the Compact Framework and the files required to support it, the SQL Server CE 2.0 data provider, and the native Microsoft SQL Server 2000 Windows® CE Edition 2.0. The data provider connects to, executes commands in, and retrieves results from SQL Server CE databases. To enable this functionality, the following Catalog items must also be included in your OS design: C++ Exception Handling Cryptography Services (Crypto API 1.0) with High Encryption Provider Windows Internet Services SQL Server CE 2.0 For more information about the Compact Framework, see .NET Compact Framework OS Design Development. This Catalog item is available only in display-based devices.
SYSGEN SQLCE20	When this variable is set, the SQL Server CE 2.0 is included in the run-time image. This Catalog item is available in both headless and display-based devices.

SYSGEN_SQL2000_DP

When this variable is set, the SQL Server 2000 .NET Data Provider is included in the run-time image.

This Catalog item includes the Compact Framework, the files required to support it, and the Microsoft SQL Server™ 2000 data provider. The data provider connects to, executes commands in, and retrieves results from SQL Server version 7.0 and later databases.

To enable this functionality, the following Catalog items must also be included in your OS design:

C++ Exception Handling
Cryptography Services (Crypto API 1.0) with High Encryption Provider
Windows Internet Services

This Catalog item is available only in display-based devices.

SYSGEN_SQLCE20_DP

When this variable is set, .NET Data Provider is included in the run-time image. This Catalog item includes the Compact Framework and the files required to support it, the SQL Server CE 2.0 data provider, and the native Microsoft SQL Server 2000 Windows® CE Edition 2.0. The data provider connects to, executes commands in, and retrieves results from SQL Server CE databases.

To enable this functionality, the following Catalog items must also be included in your OS design: