Establishing Connectivity for SQL Server CE

Team-Fly    

 
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.


Team-Fly    
Top
 


eMbedded Visual BasicR. WindowsR CE and Pocket PC Mobile Applications
eMbedded Visual BasicR. WindowsR CE and Pocket PC Mobile Applications
ISBN: N/A
EAN: N/A
Year: 2001
Pages: 108

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net