iAnywhere.com - UltraLite for M-Business Anywhere Quick Start

UltraLite for M-Business Anywhere User's Guide

Understanding UltraLite for M-Business Anywhere Development

UltraLite for M-Business Anywhere Quick Start

The following procedures describe how to run the supplied CustDB and Simple sample applications.

Before you start, ensure that you have M-Business Anywhere 5.3 or later installed and running, and that you have administrative privileges on the server. You must also have a supported handheld device.

To install and run M-Business Anywhere samples

Copy the UltraLite for M-Business Anywhere sample files to your installation directory for deployment.
1. Open a command prompt and change directory to the Samples\UltraLiteForMBusinessAnywhere\custdb subdirectory of your SQL Anywhere installation.
2. Run the following command:
```
build.bat install-dir
```
  where install-dir is the directory to which the CustDB and UltraLite files should be deployed.
  
  The batch file copies the required files into the location you specify. To see what files are being copied, open Samples\UltraLiteForMBusinessAnywhere\custdb\build.bat in a text editor.
Create a virtual directory in your web server that points to the install directory install-dir specified in step 1. The following instructions are for Microsoft IIS:
1. Open the IIS management tool.
2. Right-click your web site and choose New Virtual Directory. Name this virtual directory CustDB and point it at your install directory install-dir. Leave the other settings at their default values.
3. Right-click the new virtual directory and choose Properties. In the HTTP Headers tab, click File Types and register the following file extensions as the type application/octet-stream:
  - dll
  - usm
  - cab
  - pdb
  - prc
4. Make a note of the URL that accesses the file main.htm in this virtual directory. In a default installation this would be http://localhost/CustDB/main.htm.
Add users to M-Business Anywhere.

There are three ways to add new users to M-Business Anywhere: by creating new user profiles, by allowing users to self-register, and by importing a CSV file. These instructions describe how to create a new user profile. For more information, see the M-Business Anywhere documentation.
1. Log in to M-Business Anywhere as an administrator.
  
  The default administrator account settings are a user ID of Admin and an empty password.
2. Click the Users button.
3. Click the New User link. The Create New User page appears.
4. Type a unique user name in the User Name field.
5. Type the same password in the Password and the Confirm Password fields.
6. Click Create to add the user, or click Create and Edit to create the user and edit the user's details.
Deploy the M-Business Anywhere Client to a handheld device or PC.
1. Click the Download Client Software Only link on the M-Business Anywhere login page.
2. On the handheld device or PC, configure AvantGo Connect to synchronize with the M-Business Anywhere server.
  
  Enter the user ID and password of the new M-Business user account you created.
3. Synchronize to the M-Business Anywhere server at least once to install the client onto the device.
  
  If you have connection problems at this stage, specify the IP number rather than the host name as the host to avoid name resolution issues with some versions of ActiveSync.
For more information, see your M-Business Anywhere documentation.
Add a group to M-Business Anywhere.

The group will be used to test UltraLite for M-Business Anywhere.
1. From a web browser, connect to M-Business Anywhere.
  
  The default URL is http://localhost or http://localhost:8092.
2. Log in using the administrator account.
3. Click the Groups tab, and click New Group.
4. Name your group UltraLite Samples.
Configure the M-Business Anywhere channel settings.
1. Add the user you created in step 3 to the new group UltraLite Samples.
2. User the group's "web" tab, create the following channel.
  
  Setting Value
  Channel Name CustDB
  Location http://localhost/CustDB/main.htm or the URL from step 2.
  Size 1000
  Link depth 3
  Allow binary distribution Yes (checked)
  Hidden No (unchecked)
  
  After setting the Location value, click View to confirm that you have entered the value correctly.
Synchronize your client.

The initial synchronization downloads the UltraLite for M-Business Anywhere files onto your handheld device.

Setting	Value
Channel Name	CustDB
Location	http://localhost/CustDB/main.htm or the URL from step 2.
Size	1000
Link depth	3
Allow binary distribution	Yes (checked)
Hidden	No (unchecked)

To verify your setup

Check that the required files are present.
- On Pocket PC, after you have synchronized the device, check that the following files are in the \Program Files\AvantGo\Pods folder:
  - ulpod9.dll
  - ul_custdb.usm
  If any of these files are missing, you may have to manually copy them over to the device.
- On Palm OS, after you have synchronized your device, check Palm OS App Info for the presence of the following:
  - ulpod
  - ul_custdb
  If any of these are missing, you may have to use the Palm install utility to install the UltraLite for M-Business Anywhere runtime .prc and sample schemas .pdb to the device.
- On Windows, after you have synchronized your device, check that the following files are in the AvantGo\Pods subdirectory of your AvantGo Connect folder:
  - ulpod9.dll
  - ul_custdb.usm
  If any of these files are missing, you may have to manually copy them over to the device.
Launch M-Business Client.

On your handheld device or PC, check that the About screen displays the UltraLite for M-Business Anywhere version number. This confirms that UltraLite for M-Business Anywhere is successfully installed.
Run the CustDB sample application.
1. Start the MobiLink synchronization server on your desktop.
  
  From the Start menu, choose Programs > SQL Anywhere 9 > MobiLink > Synchronization Server Sample.
2. Start the CustDB application on your AvantGo Client.
  
  The CustDB application is a link on your AvantGo home page.
3. Enter your user ID.
  
  The default value is 50.
4. Synchronize.
  
  Either answer Yes to the prompt "Do you have a network connection now?" or, in the CustDB application, click Synchronize. This synchronizes data with MobiLink, and is a separate operation from synchronizing with M-Business Anywhere.
  
  You should now see data in the CustDB fields. You can now explore the CustDB application.
For information about the CustDB sample application, see CustDB 示例应用程序.

HotSync with multiple databases

Each UltraLite database on a Palm OS device must have a distinct creator ID to work properly with HotSync. In addition, an application with that creator ID must exist on the Palm OS device.

The HotSync Manager uses each application's creator ID as an identifier to handle synchronization. It hands each properly configured UltraLite application to the MobiLink conduit for synchronization. The conduit searches for and synchronizes a database with the same creator ID as the application.

For information about configuring the conduit, see 了解 HotSync 同步.

All UltraLite for M-Business Anywhere applications inherit the creator ID of the AvantGo client, which is AvGo. This inheritance means that only one UltraLite database with creator ID AvGo can be synchronized, and that if you assign a distinct creator ID to your database, HotSync will not find it because there is no application with a corresponding creator ID.

This limitation is not an issue for the two sample applications (CustDB and Simple), as they share a common database schema. The only side effect is that when you synchronize the CustDB database, the Simple sample is also synchronized.

For information on resolving this problem, see 理解 Palm 创建者 ID.