Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - M-Business Anywhere Programming » 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 6.0 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

  1. Copy the UltraLite for M-Business Anywhere sample files to your installation directory for deployment.

    1. Open a command prompt and change the directory to the samples-dir\UltraLiteForMBusinessAnywhere\CustDB subdirectory of your SQL Anywhere installation.
    2. Run the following command:
      build.bat deploy-dir

      where deploy-dir is the directory where the CustDB and UltraLite files are to be deployed. For example, you may choose C:\tutorial\mba

      The batch file copies the required files to the location you specify. To see what files are being copied, examine the file samples-dir\UltraLiteForMBusinessAnywhere\CustDB\build.bat using a text editor.

  2. Create a virtual directory in your web server that points to the directory deploy-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 specify your deployment directory deploy-dir as the content directory. 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:
      • For Windows and Windows Mobile: cab, dll
      • For Palm OS: pdb, prc
      • udb
    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.
  3. 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. In the left panel, click Users.
    3. Click Create User.
    4. In the User Name field, type a unique user name .
    5. In the Password and Confirm Password fields, type the password.
    6. Click Save.
  4. 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. Run the installation to install the client.
    2. On the handheld device or PC, configure M-Business 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.

      If you have connection problems at this stage, specify the host using an IP number rather than a host name (to avoid name resolution issues with some versions of ActiveSync).

    For more information, see your M-Business Anywhere documentation.

  5. 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:8091.

    2. Log in using the administrator account.
    3. In the left navigation panel, click Groups and then click Create Group.
    4. Name your group UltraLite Samples.
  6. Configure the M-Business Anywhere channel settings.

    1. In the left panel under Edit Group, add the user you created in step 3 to the group UltraLite Samples using the Users option .
    2. Use the group's "Channels" option in the left navigation panel to 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.

  7. Synchronize your client.

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

To verify your setup

  1. Check that the required files are present.

    • On Windows Mobile, after you have synchronized the device, check that the following files are in the \Program Files\AvantGo\Pods folder:
      • ulpod11.dll
      • custdb.udb

      If any of these files is 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
      • 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 files to the device.

    • On Windows desktops, after you have synchronized your device, check that the following files are in the AvantGo\Pods subdirectory of your AvantGo Connect folder:
      • ulpod11.dll
      • custdb.udb

      If any of these files are missing, you may have to manually copy them over to the device.

  2. 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.

  3. Run the CustDB sample application.

    1. Start the MobiLink server on your desktop.

      From the Start menu, choose Programs » SQL Anywhere 11 » MobiLink » Synchronization Server Sample.

    2. Start the CustDB application on your M-Business Client.

      The CustDB application is a link on your M-Business home page.

    3. Enter your user ID.

      The default value is 50.

    4. Synchronize.

      At the prompt "Do you have a network connection now?" answer Yes, 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.

    See Exploring the CustDB sample for MobiLink.

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 more information about configuring the conduit, see HotSync synchronization overview.

All UltraLite for M-Business Anywhere applications inherit the creator ID of the M-Business 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 more information about resolving this problem, see Registering the Palm creator ID.