To supply the runtime connection information for a Sybase Adaptive Server IQ (ASIQ) database server endpoint, create a Sybase ASIQ connection profile. You can also use the fully-configured default Sybase ASIQ connection profile installed with Sybase WorkSpace.
In the Enterprise Explorer, right-click Databases and select New.
In the Wizard Selection page, select Sybase ASIQ Connection Profile and click Next.
Complete the following information on the wizard pages (provided by the ASIQ administrator):
Name and Description page
| Field | Description |
|---|---|
| Name | For example, ASIQServerName. |
| Description | For example, YourCorp ASIQ. |
| Auto-Connect | Select the check box to automatically connect to the server and display its contents in the Enterprise Explorer. This happens whenever the Enterprise Explorer is opened. |
Specify a Driver and Connection Details page
| Field | Description |
|---|---|
| Select Driver | Select the Sybase ASIQ driver for your database, overwriting the fields on this page. For example, Sybase ASIQ Default. NoteSelecting a driver template from the Select Driver menu overwrites all the other fields in this dialog. If no compatible driver exists, click [...] to open the Driver Definitions dialog and define one. |
| Host Name | For example, localhost. |
| Database Name | For example, asiqdemo. |
| Port Number | For example, 2638. |
| User Name | For example, dba. |
| Password | Enter the password for the database server login, if required. |
| Filter Properties | |
| Catalog | If your catalog has the same name as the Database Name, accept this as the default, for example, asiqdemo. 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 %. |
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 Optional Properties, specify any connection properties by entering a line in the format KEY=value, for example, DYNAMIC_PREPARE=true and clicking Add
Added connection properties appear in the list.
For complete information on connection properties in Sybase ASIQ, contact the database administrator.
Use the Up, Down, Remove, and Clear All buttons to delete or reorder the connection properties.
Click Next.
In the Summary page, click Back to make changes or Finish to confirm.
The connection profile icon appears in the Enterprise Explorer under the Databases folder. If you selected Auto-Connect in the Name and Description page, the connection profile is connected.
If you change the connection properties of a connection profile that is already connected, the connection profile will immediately disconnect from the resources and automatically attempt to reconnect using the updated information.
Setting Up Connection Profiles for Service Development
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com