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.
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]11.map | 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\dbisql.com | 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.
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.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |