About the ASA Demo DB and the Database painter  Lesson 5: Connecting to the Database


Create a database profile for the ASA Demo DB database

Note

  1. Click the Database Profile button in the PowerBar

    or

    Select Tools>Database Profile from the menu bar.

    PocketBuilder displays the Database Profiles dialog box, which includes a tree view of the installed database interfaces and defined database profiles for each interface. You can click the + signs or double-click the icons next to items in the tree view to expand or contract tree view nodes.

    Shown is the tree view of the Database Profile painter with E A S Demo D B v 10 highlighted under the entry O D B O D B C
  2. Select the ODB ODBC node by clicking on it.

    Shown is the tree view of the Database Profile painter with E A S Demo D B v 10 highlighted under the entry O D B O D B C
  3. Click the New button.

    The Database Profile Setup dialog box displays.

    Shown is the tree view of the Database Profile painter with E A S Demo D B v 10 highlighted under the entry O D B O D B C
  4. Type or select the required profile information.

    Profile setup

    Value

    Profile Name

    ASA Demo

    Data Source

    ASA 9.0 Sample

    User ID

    dba

    Password

    sql

    Here is what the profile setup should look like when you are done:

    Shown is the tree view of the Database Profile painter with E A S Demo D B v 10 highlighted under the entry O D B O D B C
  5. Select the Preview tab.

    The PowerScript connection syntax for the new profile is shown on the Preview tab. If you change the profile connection options, the syntax changes accordingly.

    Shown is the Preview tab of the Database Profile Setup dialog box. It displays the Database Connection Syntax in a scrollable area. Below this are buttons for Copy and Test Connection.
  6. Click the Test Connection button.

    A message box tells you that the connection is successful.

    NoteIf the message box tells you the connection is not successful Close the message box and verify that the information on the Connection page of the Database Profile Setup dialog box is correct. Then check the configuration of the data source in the ODBC Administrator. You can run the ODBC Administrator by expanding the Utilities folder under the ODB ODBC node of the Database Profile painter and double-clicking the ODBC Administrator item.

  7. Click OK to close the message box.

    Click OK to close the Database Profile Setup dialog box.

    Click Close to close the Database Profiles dialog box.





Copyright © 2004. Sybase Inc. All rights reserved. Lesson 5: Connecting to the Database

View this book as PDF