When you first connect to a database server or database, you typically enter a user ID, password, and other connection parameters. See Connecting from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility.
To make subsequent connections from Sybase Central easier, you can create a connection profile that saves a group of parameters under a name that you supply. From then on, you can use that profile to connect to the object in one step.
To use and manage connection profiles, choose Connections » Connection Profiles. This command opens the Connection Profiles window, where you can:
Connection profiles are specific to Sybase Central. If you are building an ODBC application, you can achieve functionality similar to connection profiles using ODBC data sources. See Saving connection parameters in ODBC data sources.
To create a new connection profile
In Sybase Central, choose Connections » Connection Profiles.
The Connection Profiles window appears.
Click New.
In the New Connection Profile window, enter a name for the new profile, a description.
Select New Connection Profile and choose the appropriate plug-in from the list. The plug-in is the product, such as SQL Anywhere 11 or MobiLink 11.
Alternatively, you can base your new connection profile on an existing profile by selecting Copy Connection Profile and choosing the appropriate profile from the Existing Connection Profiles list.
You can allow other users to access the profile by selecting Share This Connection Profile With Other Users. This is useful on multi-user platforms such as Unix.
Click OK.
The Edit Connection Profile window appears.
In the Edit Connection Profile window, enter the required values, and then click OK to close the window.
To connect automatically when Sybase Central starts
In Sybase Central, choose Connections » Connection Profiles.
The Connection Profiles window appears.
Select a connection profile.
Click Set Startup until the setting in the Use On Startup column changes to Yes.
To edit the parameters of an existing connection profile
In Sybase Central, choose Connections » Connection Profiles.
The Connection Profiles window appears.
Select a connection profile.
Click Edit.
The Edit Connection Profile window appears.
In the Edit Connection Profile window, edit the values.
To import a connection profile
In Sybase Central, choose Connections » Connection Profiles.
The Connection Profiles window appears.
Click Import.
The Import Connection Profile File window appears.
Specify the name of the file containing the connection profile you want to import.
Click OK.
To export a connection profile
In Sybase Central, choose Connections » Connection Profiles.
The Connection Profiles window appears.
Select the connection profile you want to export.
Click Export.
The Save As window appears.
Enter a name for the file to which you want to save the connection profile.
Click Save.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |