此步骤涉及 Sybase Central 的配置。如果不安装 Sybase Central,则可以跳过此步骤。
将 Sybase Central 安装到系统时,会在 .scRepository600 文件中创建 SQL Anywhere 11 Demo 的连接配置文件。如果您不想创建一个或多个连接配置文件,则可以跳过此步骤。
以下命令用于创建 SQL Anywhere 11 Demo 连接配置文件。将此作为您创建自己的连接配置文件的模型。
scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Name" "SQL Anywhere 11 Demo" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/FirstTimeStart" "false" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Description" "Suitable Description" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/ProviderId" "sqlanywhere1100" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Provider" "SQL Anywhere 11" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileSettings" "DSN\eSQL^0020Anywhere^002011^0020Demo;UID\eDBA;PWD\e35c624d517fb" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileName" "SQL Anywhere 11 Demo" scjview -write "ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileType" "SQL Anywhere" |
连接配置文件字符串和值可从 .scRepository600 文件中抽取。使用 Sybase Central 定义连接配置文件,然后在 .scRepository600 文件中查找相对应的行。
下面是按照上述过程创建的 .scRepository600 文件的一部分。为便于显示,一些条目已拆分为多行。在此文件中,每个条目出现在一行中:
# Version: 6.0.0.1154 # Fri Feb 23 13:09:14 EST 2007 # ConnectionProfiles/SQL Anywhere 11 Demo/Name=SQL Anywhere 11 Demo ConnectionProfiles/SQL Anywhere 11 Demo/FirstTimeStart=false ConnectionProfiles/SQL Anywhere 11 Demo/Description=Suitable Description ConnectionProfiles/SQL Anywhere 11 Demo/ProviderId=sqlanywhere1100 ConnectionProfiles/SQL Anywhere 11 Demo/Provider=SQL Anywhere 11 ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileSettings= DSN\eSQL^0020Anywhere^002011^0020Demo; UID\eDBA; PWD\e35c624d517fb ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileName= SQL Anywhere 11 Demo ConnectionProfiles/SQL Anywhere 11 Demo/Data/ConnectionProfileType= SQL Anywhere |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |