SQL Server 2000 Windows CE Edition 2.0 OS Design Development (Windows CE 5.0)
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:
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:
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. |
Operating System Development Topics
SQL Reference for SQL Server CE
Application Development Topics
See Also
SQL Server 2000 Windows CE Edition 2.0
Send Feedback on this topic to the authors