This section demonstrates how to create a connection profile for an Adaptive Server Enterprise server in Sybase WorkSpace. A connection profile enables connection to servers, message transports, and databases.
Launch Sybase WorkSpace.
You create the connection profile in the Database Development perspective.
To open the Database Development perspective, select Window|Open Perspective|Database Development from the Sybase WorkSpace main menu bar.
In the Database Explorer view, right-click Database Connection Profiles and select New Connection Profile.
The New Connection Profile wizard displays. �
Select Sybase ASE and click Next.
In the Name field,
enter ASE_Tutorials and
click Next.
In the Connection tab, in the Host and Port fields, enter the proper host (server name) and its associated port number.
If you do not know the host name or port number, check the sql.ini file (located
in C:\Sybase\ini by
default), which lists network servers and their associated port
numbers, or see your system administrator.
Enter your database user name and password.
Your user account must have privileges to access the sample pubs database. If you do not know your user name and/or password, see your system administrator.
Click Test connection to verify you entered the proper server information.
Do not proceed until the ping succeeds. If the ping does not succeed, your user account might not have privileges to access the sample pubs database. See your system administrator for assistance.
Click OK to close the Success dialog box and then click Finish.
If you have not installed a samples database, continue to “Installing the interpubs database”.
If you already installed a samples database, in the Database Explorer view, right-click the ASE_Tutorials connection profile you just created and select Connect.
You have successfully created a connection profile for an Adaptive Server Enterprise server and are connected to the server from Sybase WorkSpace.
