Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » Deploying Databases and Applications » Deploying administration tools » Deploying administration tools on Linux/Unix/Mac OS X

Step 4: Registering the Sybase Central plug-ins Next Page

Step 5: Creating Connection Profiles for Sybase Central

This step involves the configuration of Sybase Central. If you are not installing Sybase Central, you can skip it.

When Sybase Central is installed on your system, a connection profile for SQL Anywhere 10 Demo is created in the .scRepository file. If you do not wish to create one or more connection profiles, then you can skip this step.

The following commands were used to create the SQL Anywhere 10 Demo connection profile. Use this as a model for creating your own connection profiles.

scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/Name" "SQL Anywhere 10 Demo"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/FirstTimeStart" "false"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/Description" "Suitable Description"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/ProviderId" "sqlanywhere1000"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/Provider" "SQL Anywhere 10"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/Data/ConnectionProfileSettings" "DSN\eSQL^0020Anywhere^002010^0020Demo;UID\eDBA;PWD\e35c624d517fb"
scjview -write "ConnectionProfiles/SQL Anywhere 10 Demo/Data/ConnectionProfileName" "SQL Anywhere 10 Demo"

The connection profile strings and values can be extracted from the .scRepository file. Define a connection profile using Sybase Central and then look at the .scRepository file for the corresponding lines.

Here is a portion of the .scRepository file that was created using the process described above. Some entries have been split across multiple lines for display purposes. In the file, each entry appears on a single line:

#  Version: 5.0.0.3245
#  Fri Feb 23 13:09:14 EST 2007
#
ConnectionProfiles/SQL Anywhere 10 Demo/Name=SQL Anywhere 10 Demo
ConnectionProfiles/SQL Anywhere 10 Demo/FirstTimeStart=false
ConnectionProfiles/SQL Anywhere 10 Demo/Description=Suitable Description
ConnectionProfiles/SQL Anywhere 10 Demo/ProviderId=sqlanywhere1000
ConnectionProfiles/SQL Anywhere 10 Demo/Provider=SQL Anywhere 10
ConnectionProfiles/SQL Anywhere 10 Demo/Data/ConnectionProfileSettings=
    DSN\eSQL^0020Anywhere^002010^0020Demo;UID\eDBA;PWD\e35c624d517fb;
    UID\eDBA;
    PWD\e35c624d517fb;
ConnectionProfiles/SQL Anywhere 10 Demo/Data/ConnectionProfileName=
    SQL Anywhere 10 Demo