Creating an ASA Connection Profile

To supply the runtime connection information for a Sybase Adaptive Server Anywhere (ASA) database server endpoint, create a Sybase ASA connection profile. You have the following options:

Prerequisites: If you plan to use a JDBC driver other than the default ASA driver provided by Sybase WorkSpace, verify that you have defined your driver before creating a connection profile.

To create an ASA connection profile:

  1. Open the New Connection Profile wizard. Choose from the following:

    • In the Service Development perspective, select File|New|Other from the main menu bar. Then Select Connection Profiles|Connection Profile and click Next.

    • In the Enterprise Explorer, right-click Databases and select New from the context menu.

    • In the Database Explorer, right-click Database Connection Profiles and select New Connection Profile from the context menu.

  2. In the Wizard Selection Page, select Sybase ASA and click Next.

  3. Complete the following information on the wizard pages and click Next:

    Name and Description page

    FieldDescription

    Name

    Enter a unique and descriptive name for the profile.

    For example: ASAServerName.

    Description

    Enter a profile description that helps you distinguish it from others.

    For example: YourCorp ASA.

    Auto-Connect

    (Optional) Select the check box to automatically connect to the server and display its contents in the Enterprise Explorer. A connection is established whenever the Enterprise Explorer is opened.

    Specify a Driver and Connection Details page

    FieldDescription

    Connection Properties

    Select Driver

    Sybase ASA Default is automatically populated based on the default driver selection.

    Host

    Enter the host name. For example: YourASAServer

    Database Name

    Choose from the following:

    • If exposing a single database, enter the database name. For example: ASA_ONE

    • If exposing multiple databases, leave blank.

    Port Number

    Enter the port number. For example: 7200

    User Name

    Enter the name of the authorized user. For example: dbadmin

    Password

    1. Enter the password for the database server login, if required.

    2. Ping the database server. Click Test Connection.

      If the ping fails, verify the connection property values.

     

    Filter Properties

    Catalog

    Expose a single database, using % as the wild card, for example, DATABASE%. To expose all databases in the catalog, enter % or leave blank.

    Note

    Catalog filter property does not apply to Sybase ASA or Sybase ASIQ.

    Schema

    Specify a schema or filter by schema name, using % as the wild card. For example, TABL%. To specify all schemas in the catalog, enter %

    Procedure Name

    Specify a procedure or filter by procedure name, using % as the wild card, for example: ADDR%. To specify all procedures in the schema, enter %.

     

    Other Properties

    1. In the text box, specify connection properties using the KEY=value format, or choose from the drop-down list. Then click Add.

      For example: DYNAMIC_PREPARE=true and click Add

    2. Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.

      Note

      For more information on connection properties for Sybase ASA, contact the database administrator.

  4. Test the connection. Click Test connection to ping the database server.

  5. (Optional) If your database server exposes multiple databases, specify the databases you want to create connection profiles for. Do the following:

    1. On the Check for Multiple Database ASA Server page, click Check for multiple databases to display a list of available databases.

    2. Select the databases you want to create a connection profile for, then click Next.

  6. Review the Summary page. Click Back to make changes or Finish to create the connection profile.

    The profile appears in the Enterprise Explorer under Databases and in the Database Explorer under Database Connection Profiles.

    • If you opted to access multiple databases, a connection profile appears for each database.

    • If you selected Auto-Connect in the Name and Description page, the connection profile is also connected.

    Note

    If you change the connection properties of a connection profile that is already connected, the connection profile will immediately disconnect from the resources and automatically attempt to reconnect using the updated information.

Related Tasks

Using the Default Connection Profiles

Deriving Multiple ASA Connection Profiles

Developing a Database Service

Related Concept

Connection Profiles

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com