Export (0) Print
Expand All

Setup Instructions for eMbedded Visual Tools Applications

SQL Server 2000

Before you can run and examine the code for any of the Microsoft® eMbedded Visual Tools sample applications for Microsoft SQL Server™ 2000 Windows® CE Edition (SQL Server CE), you must have several components and tools installed. All of the samples require Microsoft Internet Information Services (IIS) and Microsoft SQL Server with the exception of the OLE DB sample application (OLEDBSeek). For the samples that require IIS and SQL Server, the simplest configuration is to run instances of SQL Server and IIS on the same computer.

Important  Sample applications should not be connected to or used with your production SQL Server database without the permission of the system administrator. In fact, system administrator privileges are required for parts of this application installation.

Following the installation and configuration of the items listed below, you can view the sample applications on any Microsoft Windows Powered Pocket PC 2002-based device or by using an emulator with Microsoft eMbedded Visual Basic®. The Pocket PC 2002 emulator comes with the installation of the Microsoft Windows Powered Pocket PC 2002 SDK. The emulator simulates screens and behavior of a Pocket PC 2002-based device.

Prerequisites for Using the Sample Applications

Install or verify the installation of the following items on the development system:

Setup Tips for eMbedded Visual Tools

To install Microsoft eMbedded Visual Tools 3.0, the Pocket PC 2002 SDK, and then Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE), follow the directions in Installing SQL Server CE. The Pocket PC 2002 emulator for Microsoft eMbedded Visual Basic is included with the Pocket PC 2002 SDK, available at this Microsoft Web site.

Setup Tips for SQL Server CE

During the setup of Microsoft SQL Server™ 2000 Windows CE (SQL Server CE), select Development Tools and Server Tools. Microsoft ActiveX® Data Objects for Windows CE 3.1 (ADOCE) is installed with Development Tools. Installing Server Tools makes the SQL Server CE Server Agent (Sscesa20.dll), Sscerp20.dll, and MDAC 2.6 available for connectivity.

Setup Tips for IIS and the SQL Server CE Server Agent (Sscesa20.dll)

Pulling data from a Microsoft SQL Server database to a SQL Server CE database with replication or remote data access (RDA) requires:

  • Configuration of Microsoft Internet Information Services (IIS).
  • Creation of a virtual directory.
  • Configuration of NTFS access permissions for the SQL Server CE Server Agent (Sscesa20.dll) and IIS content folder.

You can perform these steps manually; however, it is strongly recommended that you use the SQL Server CE Connectivity Management utility to configure the computer running IIS, including NTFS access permissions.

You must install SQL Server CE Server Tools on the computer running IIS. After SQL Server CE Server Tools is installed, you are prompted to start the SQL Server CE Virtual Directory Creation Wizard. After you have successfully completed the wizard, the system is properly configured.

If you have installed SQL Server CE Server Tools but chose not to start the wizard, you can start the wizard manually.

To start the SQL Server CE Virtual Directory Creation Wizard

  1. On the Start menu, point to Programs/Microsoft SQL Server CE 2.0, and then click Configure Connectivity Support in IIS.
  2. In the right pane, double-click Create a Virtual Directory.

For more information about the SQL Server CE Virtual Directory Creation Wizard and the SQL Server CE Connectivity Management utility, see Using Connectivity Tools.

Note  For applications using replication or RDA, the name of the server running IIS, the virtual directory, and the SQL Server CE Server Agent (Sscesa20.dll) must be specified as part of the InternetURL property for connectivity (for example, http://www.northwindtraders.com/sqlce20/sscesa20.dll). The Northwind Remote Salesforce sample applications include a text box on the first screen of each application in which to enter this information.

Setup Tips for Replication: SQL Server 2000 Configuration

After Microsoft® Internet Information Services (IIS) is properly configured, you can enable Microsoft SQL Server™ 2000 for replication. The replication sample application uses a duplicated Northwind database called Nwind_SQLCE. Running the setup script SetupRepl.bat on the computer running SQL Server 2000 creates the Nwind_SQLCE database, enables SQL Server for replication, and creates a publication named SQLCEReplDemo.

To configure the computer running SQL Server 2000

Note  If the computer running SQL Server is already configured as a Publisher/Distributor for replication and has a snapshot folder defined with the appropriate permissions, skip Step 1 and Step 2.

  1. Create a shared directory on the computer running SQL Server 2000 that will become the Publisher/Distributor. Replication snapshot files are created in this directory by the replication process and are read by the SQL Server CE Subscriber.
  2. Ensure that the IIS user specified during synchronization has read access to the shared directory. By default, the virtual directory is configured with anonymous access; therefore, grant computername\IUSR_computername read access to the shared directory created in Step 1.
  3. Run SetupRepl.bat, located with the SQL Server CE files (C:\Program Files\Microsoft SQL Server CE 2.0\Samples\eVB\Northwind_REPL), according to the following usage specifications:
    Usage: SetupRepl {required parms} {optional parms}
    
    Required Arguments:
    {snapshot share} - a share available for the storage of snapshot files. All subscribers (IIS user) must be able to read from this share.
    {publisher login} - Publisher user ID.
    {publisher password} - Publisher password.
    
    Optional Arguments:
    {publisher} - Publisher name. Defaults to local computer.
    {snapshot server name} - Defaults to Publisher name (Must be set to support named instances).
    
    Examples:
    SetupRepl ReplSnapshot sa <password>
    SetupRepl ReplSnapshot sa <password> Publisher 
    SetupRepl ReplSnapshot sa <password> Publisher\instance ServerName
    
    

    This step installs a Publisher with a local Distributor, creates a database named Nwind_SQLCE, and populates it with initial data that matches data in the Northwind database that ships with SQL Server. It also creates a merge publication named SQLCEReplDemo from the Nwind_SQLCE database.

    The Distributor is installed using the shared directory specified when the Setuprepl.bat file is run. This shared directory is used as the replication snapshot folder. For example, if you call Setuprepl.bat and specify ReplSnapshot as the snapshot shared directory, the directory for all snapshot files is \\computername\ReplSnapshot.

  4. Grant the IIS user (NT_Authentication) or the SQL Server user (DB_Authentication) access to the publication access list. For more information, see Securing the Publication.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft