The SybStore sample database must have a connection profile, which allows WorkSpace to connect to the database.
The first time you execute a SQL file, you must specify
the connection profile. Subsequently, you do not have to specify
the connection profile unless you want to change it. You can assign
different connection profiles to different files, which allows you
to use different ports or user names and passwords.
A connection profile contains the connection information (for example, host name and port) that WorkSpace uses to connect to a server resource. Use the Enterprise Explorer to create and configure connection profiles.
In the WorkSpace main window, select the Enterprise Explorer if that view is open. If that view is not open, select Window|Show View|Enterprise Explorer to open the view.
In the Enterprise Explorer view, right-click the Databases folder and select New from the context menu.
When the New Connection Profile wizard appears, select Sybase ASA from the connection profile type list and click Next.
Enter SybStore in
the Name field, and SybStore
Sample Connection Profile in the Description field.
Click Next.
On the Driver and Connection Details page of the wizard:
Verify that Port is
set to 2648.
Change Password to SQL.
Select Test Connection to ensure the values you entered are correct.
When a prompt indicates that the Ping
Succeeded, click OK.
If the ping fails, verify that the SybStore database is running (see “Starting the sample database”), and that the values entered for the connection are correct.
Click Finish to complete the connection profile.
In the Enterprise Explorer, right-click the SybStore connection profile in the Databases folder and select Connect from the context menu.
A successful connection is indicated when the database version appears beside the database name in the Enterprise Explorer view and a database icon displays below the SybStore connection profile.
