The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Synch mobile apps with DB2 Everyplace and .NET

Martin Oberhofer (martino@de.ibm.com), DB2 Everyplace Consultant, EMC

Martin Oberhofer worked for the DB2 Everyplace performance team in the Silicon Valley Laboratories of IBM. In 2003 he joined IBM Germany and is currently working as a DB2 Everyplace consultant at SAP. He is interested in mobile and database technology, Java, and Linux. He holds a master's degree in mathematics.

Summary: This tutorial is the first in a series of three describing the development of a service technician sample application for DB2 Everyplace using Visual Studio 2003 .NET and the .NET Standard framework.

Date: 30 Sep 2004
Level: Introductory
PDF: A4 and Letter (276 KB | 32 pages)Get Adobe® Reader®

Activity: 6750 views
Comments:

Before you start

About this tutorial

This is the first tutorial in a series of three covering the development of a mobile service technician sample application for DB2 Everyplace using Visual Studio .NET 2003 and the .NET framework. The first tutorial introduces developers to the DB2 Everyplace Synchronization client API for .NET to implement the synchronization functionality, which is the foundation of any mobile synchronization solution. The second tutorial will show how to develop for DB2 Everyplace mobile database using DB2 Everyplace .NET Managed Providers for ADO.NET. The third tutorial will show how to develop stored procedures using DB2 tools and the configuration of Sync Server to make the stored procedure available as a remote stored procedure to a mobile application.

Part 1 discusses the following tasks:

How to implement a synchronization
How to implement a synchronization progress bar
How to implement a refresh triggered by the client
How to implement disabling/enabling subscription sets
How to implement the cancellation of a sync
How to use the Sync Client properties

In addition, you will learn about Sync Client properties, including hints for optimizing synchronization time by using them for performance tuning. The final section provides troubleshooting help that you might need during the implementation.

Note: I provide the code of the service technician sample application provided in the C# language.

Prerequisites

In order to use this tutorial, you will need a basic understanding of DB2 Everyplace and the mobile device functionalities provided with Visual Studio .NET 2003. If you are familiar with DB2 Everyplace, Visual Studio .NET 2003, and the .NET Framework, skip the Overview and go to the "service technician sample application" section.

Software requirements are (the development and testing was done on configuration):