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 Windows without InstallShield

Step 4: Updating the system path Next Page

Step 5: Registering the Sybase Central plug-ins


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

Sybase Central requires a configuration file that lists the installed plug-ins. Your installer must create this file. Note that it contains full paths to a number of JAR files that may change depending on where the software is installed.

The file is called .scRepository. On Windows XP/200x, it resides in the %allusersprofile%\Sybase Central 5.0.0 folder. On Windows Vista, it resides in the %ProgramData%\Sybase Central 5.0.0 folder. It is a plain text file that contains some basic information about the plug-ins that Sybase Central should load.

On Windows Vista, all users should have read access to the directory that contains the .scRepository file. This can be done using the following command. To do this manually, open an administrator command prompt window (right-click Command Prompt and click Run As Administrator).

icacls "%ProgramData%\Sybase Central 5.0.0" /grant everyone:F

The provider information for SQL Anywhere is created in the repository file using the following commands.

scjview.exe -register "C:\Program Files\SQL Anywhere 10\java\SQLAnywhere.jpr"

The contents of the SQLAnywhere.jpr file looks like this (some entries have been split across multiple lines for display purposes). The AdditionalClasspath lines must be entered on a single line in the .jpr file.

PluginName=SQL Anywhere 10
PluginId=sqlanywhere1000
PluginClass=com.sybase.asa.plugin.SAPlugin
PluginFile=C:\Program Files\SQL Anywhere 10\java\saplugin.jar
AdditionalClasspath=
    C:\Program Files\SQL Anywhere 10\java\isql.jar;
    C:\Program Files\SQL Anywhere 10\java\salib.jar;
    C:\Program Files\SQL Anywhere 10\java\JComponents1001.jar;
    C:\Program Files\SQL Anywhere 10\java\jlogon.jar;
    C:\Program Files\SQL Anywhere 10\java\debugger.jar;
    C:\Program Files\SQL Anywhere 10\java\jodbc.jar
ClassloaderId=SA1000
InitialLoadOrder=0

The SQLAnywhere.jpr file was created in the java folder of the SQL Anywhere installation when you originally installed SQL Anywhere. Use it as the model for the .jpr file that you must create as part of the install process. There are also versions of this file for MobiLink, QAnywhere, and UltraLite called MobiLink.jpr, QAnywhere.jpr, and UltraLite.jpr respectively. They are also located in the java folder.

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
#
SCRepositoryInfo/Version=4
#
Providers/sqlanywhere1000/Version=10.0.1.3390
Providers/sqlanywhere1000/UseClassloader=true
Providers/sqlanywhere1000/ClassloaderId=SA1000
Providers/sqlanywhere1000/Classpath=
    C:\\Program Files\\SQL Anywhere 10\\java\\saplugin.jar
Providers/sqlanywhere1000/Name=SQL Anywhere 10
Providers/sqlanywhere1000/AdditionalClasspath=
    C:\\Program Files\\SQL Anywhere 10\\java\\isql.jar;
    C:\\Program Files\\SQL Anywhere 10\\java\\salib.jar;
    C:\\Program Files\\SQL Anywhere 10\\java\\JComponents1001.jar;
    C:\\Program Files\\SQL Anywhere 10\\java\\jlogon.jar;
    C:\\Program Files\\SQL Anywhere 10\\java\\debugger.jar;
    C:\\Program Files\\SQL Anywhere 10\\java\\jodbc.jar
Providers/sqlanywhere1000/Provider=com.sybase.asa.plugin.SAPlugin
Providers/sqlanywhere1000/ProviderId=sqlanywhere1000
Providers/sqlanywhere1000/InitialLoadOrder=0
#
Notes