Creating an ASE Connection Profile

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

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

To create an ASE 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 ASE 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: ASEServerName.

    Description

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

    For example: YourCorp ASE

    Auto-Connect

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

    Specify a Driver and Connection Details page

    FieldDescription

    Select Driver

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

    Note

    To create a connection profile for a transactional database service, select Sybase ASE XA Default from the drop-down list.

    Host

    For example: YourASEServer

    Port

    For example: 2638

    User Name

    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.

    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 ASE, contact the database administrator.

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

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

Developing a Database Service

Related Concept

Connection Profiles

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