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 ASA connection profile installed with Sybase WorkSpace.
Verify that the database is running before creating a connection profile.
Follow the instructions below to establish a connection profile for Adaptive Server Anywhere (ASA):
In the Database Explorer view, right-click Databases and select New Connection Profile. .
On the Wizard Selection page, select Sybase ASA Connection Profile and click Next to invoke the wizard.
On the Create Connection Profile page, enter a name for the connection profile (for example, ASA-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 ASA driver for your database. For example: Sybase ASA 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: localhost is the default. |
| Database name | For example: asademo is the default. |
| Port number | You can find the port number from the ASA data server console. Default is 2638. |
| Login name | For example: dba |
| Password | For example: sql |
| Catalog | If your catalog has the same name as the Database Name, accept this as the default. For example: asademo is the default. 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 the user has selected 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 correctly filled in 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 on 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.
Related Tasks
Configuring Adaptive Server Anywhere
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com