Creating the sampledb Connection Profile

Goal: Create a database connection profile and test the sample database connection.

Installing Sybase Unwired Platform also installs a sample database sampledb, which you can use to create and test mobile business objects (MBOs). Starting Sybase Unwired Platform Services automatically starts the database, depending on your license type. A default connection profile (My Sample Database) is included with the installation, and provides access to the sampledb database. This tutorial shows you how to create and use a new connection profile named sampledb.

This task is required for all tutorials, but you need to perform it only once. If the sampledb connection profile already exists, you do need not perform this task.

  1. From the Enterprise Explorer, right-click the Database Connections folder and select New to open the Wizard Selection Page.
  2. Select Sybase ASA, enter sampledb as the name, and click Next.
  3. Select Sybase ASA v11.x for Unwired Server Default as the driver and keep the default settings, including dba as the User name and SQL as the Password. Select Save Password.


    new_asa_connection_profile

  4. Click Test Connection.
    If Test Connection fails, verify Unwired Platform Services, including the sampledb database, are running.
    1. Select the Windows Start > Settings > Control Panel menu.
    2. Select Administrative Tools, then select Services.
    3. Depending on your installation options (for example, license type, whether or not you installed a cluster, and so on) determines which Sybase services are running.
    Note: If the sampledb database is not running, you can install and start it from the command line. To install it, use the command sampledb install auto/manual. For example:
    C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\bin> sampledb install auto
    To start it from the command line, run the command sampledb start. For example:
    C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\bin> sampledb start
  5. In the Ping Succeeded message, click OK.
  6. Click Finish.
View the sampledb connection profile from Enterprise Explorer by expanding the Database Connections folder.