Step 4: 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 12 Demo is created in the repository file. If you do not want to create one or more connection profiles, then you can skip this step.

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

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

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

Here is a portion of the repository 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: 6.1.0.1154
#  Fri Feb 23 13:09:14 EST 2007
#
ConnectionProfiles/SQL Anywhere 12 Demo/Name=SQL Anywhere 12 Demo
ConnectionProfiles/SQL Anywhere 12 Demo/FirstTimeStart=false
ConnectionProfiles/SQL Anywhere 12 Demo/Description=Suitable Description
ConnectionProfiles/SQL Anywhere 12 Demo/ProviderId=sqlanywhere1200
ConnectionProfiles/SQL Anywhere 12 Demo/Provider=SQL Anywhere 12
ConnectionProfiles/SQL Anywhere 12 Demo/Data/ConnectionProfileSettings=
    DSN\eSQL^0020Anywhere^002012^0020Demo;
    UID\eDBA;
    PWD\e35c624d517fb
ConnectionProfiles/SQL Anywhere 12 Demo/Data/ConnectionProfileName=
    SQL Anywhere 12 Demo
ConnectionProfiles/SQL Anywhere 12 Demo/Data/ConnectionProfileType=
     SQL Anywhere

Discuss this page in DocCommentXchange.