Installing and Configuring SQL Server CE on Your Server

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 uses Internet Information Services (IIS) to communicate with the enterprise SQL Server. Because Windows CE devices are predominantly mobile, this allows secured access to the SQL Server using any TCP/IP connection to the IIS server. SQL Server CE allows even more secure access to the server by using HTTPS as the protocol.

To install SQL Server CE on the server, use the SQL Server CE installation package, which you can obtain from Microsoft's Web site at www.microsoft.com/sql/downloads.Once downloaded, run the installation package on the server that will provide the SQL Server CE services. You will also need to run the installation on the development machine and choose the Development Tools option during the install.

Note

The SQL Server CE development tools will install only on a machine having SQL Server 2000 Developer Edition installed on it or within its intranet. Or, you can use the 120-day trial version of SQL Server CE.


When installation is complete, you need to register the two server-side DLLs, sscerp10.dll and sscesa10.dll, by using RegSvr32.exe. In a typical install, these DLLs are installed to C:\Program Files\Microsoft SQL Server CE\Server, but can be moved or copied before registering. RegSvr32.exe is located in the System32 directory.

After these DLLs are registered, start the IIS administration tool. Create a new virtual directory by using the folder where the DLLs reside. Be sure to set Execute Permissions to Scripts and Executables. Your Virtual Directory properties should be similar to those in Figure 8.1.

Figure 8.1. Properties for the virtual directory where the SQL Server CE DLLs are registered. In this example, the DLLs were relocated to C:\Inetpub\ wwwroot \ssce.

graphics/08fig01.gif

As soon as your Virtual Directory is created, you can change the security settings to meet your needs; SQL Server CE allows the device to pass authentication credentials to IIS. So, if necessary in your environment, you can configure Basic Authentication and/or Integrated Windows Authentication.

To test the installation, you can navigate an Internet browser to the URL for the DLL sscesa10.dll (for example, http://localhost/ssce/sscesa10.dll). If the DLL is configured and working properly, the browser should display the text Body. If it doesn't seem to work properly, check the permission in both the virtual directory and the NTFS permissions on the folder and DLL files.


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