Creating an ASE Connection Profile

Create a Sybase ASE connection profile to supply the runtime connection information for a Sybase Adaptive Server Enterprise (ASE) database server endpoint.

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.

Note: If you change the connection properties of a connection profile that is already connected, the profile immediately disconnects from the resources and automatically attempts to reconnect using the updated information.

In Enterprise Explorer, right-click the server type or enterprise resource for which you want to create a connection profile and select New.
On the Wizard Selection page, select the appropriate connection profile type and click Next.

Enter a name and description for the connection profile, and click Next.

Table 1. Create Connection Profile page
Field	Description
Name	Enter a unique and descriptive name for the connection profile.
Description	(Optional) Enter a profile description that helps you distinguish it from others.
Auto-Connect at Startup	(Optional) Connect automatically to the server and display its contents in Enterprise Explorer when Sybase WorkSpace starts.

In the Specify a Driver and Connection Details page, enter the rest of the connection profile details.

Table 2. Connection tab
Field	Description
Select a driver from the drop-down	Select the appropriate version from the drop-down list. Select Sybase ASE for a nontransactional database service. Select Sybase ASE XA for a transactional database service. The other fields populate with system defaults.
Discovered servers	Select an ASE server on the network that the Sybase Unified Agent engine controls.Select Refresh to update the list. Click [...] to filter the list of discovered servers.
Host	Enter the host name.
Port	Enter the port number.
Database Name	Enter the database name.
User Name	Enter the name of the authorized user.
Password	Enter the password for the database server login, if required.
Save Password	Select this checkbox to save the password for this connection profile. Passwords persist for the current WorkSpace session. If you do not save your password and exit WorkSpace, you have to enter it when trying to connect to the database server via the connection profile for the new WorkSpace session. Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved into the ServerProfiles.dat file with minimal encryption.

Table 3. Other Properties tab
Field	Description
Other Properties text box	In the text box, specify connection properties using the KEY=value format, or choose from the drop-down list, and click Add. For example: `DYNAMIC_PREPARE=true` Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.

Click Test Connection to ping the server and to verify that the connection profile is working.
Click Finish to create the connection profile.
The connection profile displays under the appropriate category in the Enterprise Explorer.