Before you can start developing procedural objects or SQL files, you must create a database connection profile. You can also use the fully-configured default ASE connection profile installed with Sybase WorkSpace.
Verify that the database is running before trying to create a connection profile.
Follow the instructions below to establish a connection profile for Adaptive Server Enterprise (ASE):
In Database Explorer view, right-click Databases and select New Connection Profile.
On the Wizard Selection page, select Sybase ASE Connection Profile and click Next to invoke the wizard.
On the Create Connection Profile page, enter a name for the connection profile (for example, ASE-test). Optionally, add any description. Select the check box if you want to connect immediately upon finishing the wizard or whenever you are in Enterprise Browser. Click Next.
The Specify a Driver and Connection Details page appears, with the default values for the database to which you want to connect.
Modify the following input fields.
Specify a Driver and Connection Details
| Field | Example |
|---|---|
| Select a driver from the drop-down | Select the Sybase ASE driver for your database. For example: Sybase ASE Default. If no compatible driver exists, click ... to define one. Click Add and select a driver template. Click OK to return to the Specify a Driver and Connection Details page. NoteSelecting a driver template from the Select Driver menu overwrites all the other fields in this dialog. |
| Host name | For example: Name of your machine |
| Database name | For example: master is the default. |
| Port number | For example: 5000 is the default. |
| Login name | For example: sa |
| Password | Enter the password for the database server login, if required. The default is no password. |
| Catalog | If your catalog has the same name as the Database Name, accept this as the default. For example: master. If you have multiple catalogs on your database, enter the appropriate catalog name. |
| Schema | Specify a schema or filter by schema name, using % as the wild card. For example, TABL%. To specify all schemas on 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 on the schema, enter %. |
Default values are automatically entered once you select Sybase ASA Connection on the Wizard Selection page.
Ping the database server by pressing the Test Connection button. If the ping fails, check whether you correctl completed the fields appropriate for your database.
In the Optional Properties frame, specify one or more connection properties, if necessary, by entering the text in the format KEY=value. For example: DYNAMIC_PREPARE=true. After entering each connection property, click Add to add it to the list.
Click Next.
The Summary Page appears. Click Back to modify any of the information.
Click Finish.
In Database Explorer, a new profile with the name you specified appears.
If you did not select the Auto-connect check box on the Create Connection Profile page, right-click the profile and select Connect.
Expand the database connection profile to see the folder list showing the types of database objects you can create, edit, save, run, and debug.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com