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

SQL Anywhere 12.0.1 » UltraLite - M-Business Anywhere Programming (deprecated) » UltraLite development for M-Business Anywhere


Quick Start to UltraLite for M-Business Anywhere

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

 Install and run M-Business Anywhere samples

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.

  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 C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\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 C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\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 click 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 click 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
      • 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.

 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:

      • ulpod12.dll
      • custdb.udb

      If any of these files is missing, you may have to manually copy them over 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:

      • ulpod12.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.

      Click Start » Programs » SQL Anywhere 12 » 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 CustDB sample for MobiLink.