Step 2: Copying the required files

Your installer should copy a subset of the files that are installed by the SQL Anywhere installer. You must keep the same directory structure. All files must be installed below the /opt/sqlanywhere11/ directory.

You should preserve the permissions on the files when you copy them from your reference SQL Anywhere installation. In general, all users and groups are allowed to read and execute all files.

The following table lists the files required for each of the software bundles on Linux and Sun Solaris. 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 [1] SQL Anywhere Console
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
lib32/libjsyblib600_r.so.1 X X X X X X
sun/javahelp-2_0/jh.jar X X X X X X
jre_1.6.0_linux_sun_i586/... (Linux only) X X X X X X
jre_1.6.0_solaris_sun_sparc/... (Solaris only) X X X X X X
lib32/libdblib11_r.so.1 X X X X X X
lib32/libdbjodbc11.so.1 X X X X X X
lib32/libdbodbc11_r.so.1 X X X X X X
lib32/libdbodm11.so.1 X X X X X X
lib32/libdbtasks11_r.so.1 X X X X X
res/dblg[xx]11.res X X X X X X
lib32/libdbtool11_r.so.1 X X X
bin32/dbisql X X X
java/isql.jar X X X X
bin32/scjview 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 X
java/debugger.jar X
lib32/libdbput11_r.so.1 X
lib32/libmljodbc11.so.1 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
lib32/libdbicu11_r.so X
lib32/libdbicudt11.so X
bin32/dbinit X
java/ulplugin.jar X
lib32/libulscp11_r.so.1 X
lib32/libulhltool11_r.so.1 X
res/ulg[xx]11.res X
bin32/uleng11 X
bin32/ulcreate X
bin32/ulload X
bin32/ulunload X
bin32/ulsync X
bin32/ulinit X
bin32/ulvalid X
bin32/ulerase X
bin32/dbconsole X
java/DBConsole.jar X

[1] UltraLite is only supported on Linux.

The table above shows files with the designation [xx]. For Linux only, 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.

The following table lists the files required for each of the software bundles on Mac OS X. 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 SQL Anywhere Console
java/jodbc.jar X X X X X
java/JComponents1101.jar X X X X X
java/jlogon.jar X X X X X
java/SCEditor600.jar X X X X X
java/jsyblib600.jar X X X X X
lib64/libjsyblib600_r.dylib X X X X X
sun/javahelp-2_0/jh.jar X X X X X
lib64/libdblib11_r.dylib X X X X X
lib64/libdbjodbc11.dylib X X X X X
lib64/libdbodbc11_r.dylib X X X X X
lib64/libdbodm11.dylib X X X X X
lib64/libdbtasks11_r.dylib X X X X X
res/dblgen11.res X X X X X
lib64/libdbtool11_r.dylib X X X
bin64/dbisql X X
java/isql.jar X X X
bin64/scjview X X X
bin64/scvwen600.jar X X X
java/sybasecentral600.jar X X X
java/salib.jar X X X
java/saplugin.jar X
java/debugger.jar X
lib64/libdbput11_r.dylib X
libmljodbc11.dylib 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
lib64/libdbicu11_r.dylib X
lib64/libdbicudt11.dylib X
bin32/dbinit X
bin64/dbconsole X
java/DBConsole.jar X

For Linux/Solaris, the administration tools require the 32-bit version of JRE 1.6.0. The Mobilink server requires the 64-bit version of JRE 1.6.0. For Mac OS X, the administration tools require the 64-bit version. You should not substitute a later patch version of the JRE unless you have a specific need to do so. Not all platform versions of the JRE are bundled with SQL Anywhere. The platforms that are included with SQL Anywhere support Linux on x86/x64 and Solaris SPARC. Other platforms versions must be obtained from the appropriate vendor. For example, if you are working with a Linux install, copy the entire jre_1.6.0_linux_sun_i586 tree, including subdirectories.

If the platform that you require is included with SQL Anywhere, copy the JRE files from an installed copy of SQL Anywhere 11. Copy the entire tree, including subdirectories.

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.

The creation of several links is required for the bundles in the tables above. The following sections provide details.

Mac OS X

Note that on Mac OS X, shared objects have a .dylib extension. Symlink (symbolic link) creation is necessary for the following dylibs:

libdbjodbc11.jnilib -> libdbjodbc11.dylib
libdblib11_r.jnilib -> libdblib11_r.dylib
libdbput11_r.jnilib -> libdbput11_r.dylib
libmljodbc11.jnilib -> libmljodbc11.dylib
Linux/Solaris Base component files

All bundles require the links listed in this section.

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdbicu11_r.so -> libdbicu11_r.so.1
libdbicudt11.so -> libdbicudt11.so.1
libdbjodbc11.so -> libdbjodbc11.so.1
libjsyblib600_r.so -> libjsyblib600_r.so.1
libdbodbc11_r.so -> libdbodbc11_r.so.1
libdbodm11.so -> libdbodm11.so.1
libdbtasks11_r.so -> libdbtasks11_r.so.1

Create a symbolic link in /opt/sqlanywhere11/sun. The symbolic link for Linux is jre160_x86 for the 32-bit JRE. The symbolic link for other systems is jre_160.

jre160_x86 -> /opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_i586 (Linux)
jre160 -> /opt/sqlanywhere11/sun/jre_1.6.0_solaris_sun_sparc (Solaris)
Linux/Solaris Interactive SQL files

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1
Linux/Solaris Sybase Central with the SQL Anywhere plug-in

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbput11_r.so -> libdbput11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1
Linux/Solaris Sybase Central with the MobiLink plug-in

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbmlput11_r.so -> libdbmlput11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1

Create an additional symbolic link in /opt/sqlanywhere11/sun for 64-bit Linux. The symbolic link for Linux is jre160_x64 for the 64-bit JRE.

jre160_x64 -> /opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_x64 (Linux)
Linux/Solaris Sybase Central with the QAnywhere plug-in

Create the following symbolic link in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
Linux/Solaris The SQL Anywhere Console

Create the following symbolic link in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
International message and context-sensitive help files

For Linux systems only, all displayed text and context-sensitive help for the administration tools have been translated from English into German, French, Japanese, and Simplified Chinese. The resources for each language are in separate files. The English files contain en in the file names. German file names contain de, French file names contain fr,Japanese file names contain ja, and Chinese files 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.res English
dblgde11_iso_1.res, dblgde11_utf8.res German (Linux only)
dblgja11_eucjis.res, dblgja11_sjis.res , dblgja11_utf8.res Japanese (Linux only)
dblgzh11_cp936.res, dblgzh11_eucgb.res, dblgzh11_utf8.res Simplified Chinese (Linux only)

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.