Northwind Remote Salesforce RDA Sample Application
This sample Microsoft® eMbedded Visual Basic® application helps you understand how Microsoft SQL Server™ 2000 Windows® CE Edition (SQL Server CE) can be combined with Microsoft SQL Server 7.0 or SQL Server 2000 and remote data access (RDA) to form a useful mobile sales route application. The code for the application is commented so you can easily and freely extrapolate it. When you select Development Tools during setup, the sample application is installed in C:\Program Files\Microsoft SQL Server CE 2.0\Samples\eVB\Northwind_RDA. Before you use the sample application, see Setup Instructions for eMbedded Visual Tools Applications.
The Northwind Remote Salesforce RDA sample application simulates a sales representative of the Northwind Trading Company using a Pocket PC to take orders from customers and push the new orders back to the SQL Server database. The application demonstrates a limited set of features and functionality because the objective is to highlight the replication connectivity model and show some of the advanced storage engine features, such as: referential integrity with cascading deletes, robust SQL DML support, and cursors.
In a typical scenario, the sales representative uses RDA to pull customer and order information from the Northwind sample database in either SQL Server 7.0 or SQL Server 2000 to the Pocket PC. Customer and order data is stored on the Pocket PC in a SQL Server CE database. New order information can be entered, and order history reviewed on the copy of the Northwind database on the Pocket PC. When connectivity becomes available, data on the SQL Server CE database can be pushed to the SQL Server database by using the RDA Object. Because RDA uses HTTP as the transport protocol, connectivity can take the form of a network connection between the Pocket PC and SQL Server through Microsoft Internet Information Services (IIS).