eMbedded Visual Basic: Windows CE and Pocket PC Mobile Applications By Chris Tacke, Timothy Bassett
Table of Contents
Chapter 8. Using SQL Server in a Mobile Environment
SQL Server CE works over TCP/IP to communicate with the IIS server providing the SQL Server CE services. A device or emulator using SQL Server CE to communicate with the remote SQL Server, whether using replication or remote data access, must have some means to communicate with the server. This can be accomplished in a variety of ways:
Direct connection to the IIS server over ActiveSync, meaning the device is connected directly to the same machine providing the SQL Server CE services. This is only practical for development purposes as you would not want to run IIS and SQL Server CE on every user 's machine.
A device can use an Ethernet card or modem (wired or wireless) to establish a TCP/IP connection to the IIS Server providing the SQL Server CE services.
Using ActiveSync as a proxy, users can run SQL Server CE Relay on their desktop machines. When a Windows CE devices connects with ActiveSync, SQL Server CE Relay will intercept SQL Server CE transport communications and forward to the IIS Server providing the SQL Server CE services. For more information about SQL Server CE Relay, see the documentation that comes with SQL Server CE.