Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » Deploying SQL Anywhere » Deploying databases and applications » Deploying administration tools » Deploying administration tools on Windows without InstallShield


Step 2: Copying the required files

The administration tools require a specific directory structure. You are free to put the directory tree in any directory, on any drive. Throughout the following discussion, c:\sa11 is used as the example installation folder. The software must be installed into a directory tree structure having the following layout:

Directory Description
sa11 The root folder. While the following steps assume you are installing into c:\sa11, you are free to put the directory anywhere (for example, C:\Program Files\SQLAny11).
sa11\java Holds Java program JAR files.
sa11\bin32 Holds the native 32-bit Windows components used by the program, including the programs that launch the applications.
sa11\Sun\JavaHelp-2_0 The JavaHelp runtime library.
sa11\Sun\jre160_x86 The 32-bit Java Runtime Environment.

On most platforms, the Java-based administration tools are 32-bit applications. Except for Mac OS X, there are no 64-bit versions. The 32-bit administration tools can be deployed on x64-based platforms where the 32-bit JRE is available.

Itanium 64

There are no Java-based administration tools available for deployment on the Itanium (ia64) platform. However, there is a native version of Interactive SQL that is not as feature-rich as the Java version. See Deploying dbisqlc.

The following table lists the files required for each of the software bundles. Make a list of the files you need, and then copy them into the directory structure outlined above. In general, you should take the files from an already-installed copy of SQL Anywhere.

File Interactive SQL Sybase Central with the SQL Anywhere plug-in Sybase Central with the MobiLink plug-in Sybase Central with the QAnywhere plug-in Sybase Central with the UltraLite plug-in SQL Anywhere Console
documentation\[xx]\htmlhelp\sqlanywhere_[xx]11.chm X X X X X X
documentation\sqlanywhere_[xx] X X X X X X
c:\windows\system32\keyHH.exe1 X X X X X X
java\jodbc.jar X X X X X X
java\JComponents1101.jar X X X X X X
java\jlogon.jar X X X X X X
java\SCEditor600.jar X X X X X X
java\jsyblib600.jar X X X X X X
Sun\JavaHelp-2_0\jh.jar X X X X X X
Sun\jre160_x86\... X X X X X X
bin32\jsyblib600.dll X X X X X X
bin32\dblib11.dll X X X X X X
bin32\dbjodbc11.dll X X X X X X
bin32\dbodbc11.dll X X X X X X
bin32\dbcon11.dll X X X X X X
bin32\dblg[xx]11.dll X X X X X X
bin32\dbtool11.dll X X X
bin32\dbelevate11.exe (Vista and later) X X X
bin32\ X
bin32\dbisql.exe X
java\isql.jar X X X X
java\saip11.jar X X X X
bin32\scjview.exe X X X X
bin32\scvw[xx]600.jar X X X X
java\sybasecentral600.jar X X X X
java\salib.jar X X X X
java\saplugin.jar X
java\debugger.jar X
bin32\dbput11.dll X X
java\apache_files.txt X X
java\apache_license_1.1.txt X X
java\apache_license_2.0.txt X X
java\log4j.jar X X
java\mlplugin.jar X
java\mldesign.jar X X
java\stax-api-1.0.jar X
java\wstx-asl-3.2.6.jar X
java\velocity.jar X
java\velocity-dep.jar X
java\qaplugin.jar X
java\qaconnector.jar X
java\mlstream.jar X
bin32\qaagent.exe X
bin32\dbicu11.dll X
bin32\dbicudt11.dll X
bin32\dbghelp.dll X
bin32\dbinit.exe X
java\ulplugin.jar X
bin32\dbconsole.exe X
java\DBConsole.jar X

1 The exact name of the Windows system directory differs depending on which operating system you are using.

The table above shows files with the designation [xx]. There are several message files each supporting a different language. If you want to install support for different languages, you have to add the resource files for these languages. For more information, see the following section International message and context-sensitive help files.

Some file paths above end with "...". This indicates that the entire tree, including subdirectories, should be copied.

The administration tools require JRE 1.6.0. You should not substitute a later patch version of the JRE unless you have a specific need to do so. Copy the 32-bit version of the JRE files from the install-dir\Sun\jre160_x86 directory. Copy the entire jre160_x86 tree, including subdirectories.

For reference, the sqlanywhere.jpr file contains a list of the jar files for the SQL Anywhere plug-in of Sybase Central.

The mobilink.jpr file contains a list of the jar files for the MobiLink plug-in of Sybase Central.

The qanywhere.jpr file contains a list of the jar files for the QAnywhere plug-in of Sybase Central. When deploying the QAnywhere plug-in, dbinit is required. For information about deploying database tools, see Deploying database utilities.

The ultralite.jpr file contains a list of the jar files for the UltraLite plug-in of Sybase Central.

International message and context-sensitive help files

All displayed text and context-sensitive help for the administration tools is translated from English into French, German, Japanese, and Simplified Chinese. The resources for each language are held in separate files. The English files contain en in the file names. French files have similar names, but use fr instead of en. German file names contain de, Japanese file names contain ja, and Chinese file names contain zh.

If you want to install support for different languages, you have to add the message files for those other languages. The translated files are as follows:

dblgen11.dll English
dblgde11.dll German
dblgfr11.dll French
dblgja11.dll Japanese
dblgzh11.dll Simplified Chinese

You must also add the context-sensitive help files for those other languages. The available translated files are as follows:

scvwen600.jar English
scvwde600.jar German
scvwfr600.jar French
scvwja600.jar Japanese
scvwzh600.jar Simplified Chinese

These files are included with localized versions of SQL Anywhere.