You can deploy a database server by making the SQL Anywhere installer available to your end users. By selecting the proper option, each end user is guaranteed of getting the files they need.
The simplest way to deploy a personal database server or a network database server is to use the Deployment Wizard. For more information, see Using the Deployment Wizard.
To run a database server, you need to install a set of files. The files are listed in the following table. All redistribution of these files is governed by the terms of your license agreement. You must confirm whether you have the right to redistribute the database server files before doing so.
Windows | Linux / Unix | Mac OS X |
---|---|---|
dbeng11.exe | dbeng11 | dbeng11 |
dbeng11.lic | dbeng11.lic | dbeng11.lic |
dbsrv11.exe | dbsrv11 | dbsrv11 |
dbsrv11.lic | dbsrv11.lic | dbsrv11.lic |
dbserv11.dll | libdbserv11_r.so, libdbtasks11_r.so | libdbserv11_r.dylib, libdbtasks11_r.dylib |
dbscript11.dll | libdbscript11_r.so | libdbscript11_r.dylib |
dblg[xx]11.dll | dblg[xx]11.res | dblgen11.res |
dbghelp.dll | N/A | N/A |
dbctrs11.dll | N/A | N/A |
dbextf.dll 1 | libdbextf.so 1 | libdbextf.dylib 1 |
dbicu11.dll2 | libdbicu11_r.so2 | libdbicu11_r.dylib2 |
dbicudt11.dll2 3 | libdbicudt11.so2 | libdbicudt11.dylib2 |
sqlany.cvf | sqlany.cvf | sqlany.cvf |
dbrsakp11.dll4 | libdbrsakp11_r.so4 | libdbrsakp11_r.dylib4 |
dbodbc11.dll 5 | libdbodbc11.so 5 | libdbodbc11.dylib 5 |
N/A | libdbodbc11_n.so 5 | libdbodbc11_n.dylib 5 |
N/A | libdbodbc11_r.so 5 | libdbodbc11_r.dylib 5 |
dbjodbc11.dll 5 | libdbjodbc11.so 5 | libdbjodbc11.dylib 5 |
java\jconn3.jar 5 | java/jconn3.jar 5 | java/jconn3.jar 5 |
java\jodbc.jar 5 | java/jodbc.jar 5 | java/jodbc.jar 5 |
java\sajvm.jar 5 | java/sajvm.jar 5 | java/sajvm.jar 5 |
java\cis.zip 6 | java/cis.zip 6 | java/cis.zip 6 |
dbcis11.dll7 | libdbcis11.so7 | libdbcis11.dylib7 |
libsybbr.dll8 | libsybbr.so8 | libsybbr.dylib8 |
1 Required only if using system extended stored procedures and functions (xp_*).
2 Required only if the database character set is multi-byte or if the UCA collation sequence is used.
3 On Windows Mobile, the file name to deploy is called dbicudt11.dat.
4 Required only for encrypted TDS connections.
5 Required only if using Java in the database.
6 Required only if using Java in the database and remote data access.
7 Required only if using remote data access.
8 Required only for archive backups.
Depending on your situation, you should choose whether to deploy the personal database server (dbeng11) or the network database server (dbsrv11).
You must include the separate corresponding license file (dbeng11.lic or dbsrv11.lic) when deploying a database server. The license files are located in the same directory as the server executables.
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.
The Java VM jar file (sajvm.jar) is required only if the database server is to use the Java in the Database functionality.
The table does not include files needed to run utilities such as dbbackup.
For information about deploying utilities, see Deploying administration tools.
To ensure that messages written by the server to the Event Log on Windows are formatted correctly, create the following registry key.
HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services\ Eventlog\ Application\ SQLANY 11.0 |
Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen11.dll, for example, C:\Program Files\SQL Anywhere 11\bin32\dblgen11.dll. The English language DLL, dblgen11.dll, can be specified regardless of the deployment language. Here is a sample registry change file.
REGEDIT4 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 11.0] "EventMessageFile"="c:\\sa11\\bin32\\dblgen11.dll" |
For the 64-bit version of the server, the registry key is SQLANY64 11.0
.
To ensure that messages written by MESSAGE ... TO EVENT LOG statements to the Event Log on Windows are formatted correctly, create the following registry key.
HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services\ Eventlog\ Application\ SQLANY 11.0 Admin |
Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen11.dll, for example, C:\Program Files\SQL Anywhere 11\bin32\dblgen11.dll. The English language DLL, dblgen11.dll, can be specified regardless of the deployment language. Here is a sample registry change file.
REGEDIT4 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 11.0 Admin] "EventMessageFile"="c:\\sa11\\bin32\\dblgen11.dll" |
For the 64-bit version of the server, the registry key is SQLANY64 11.0 Admin
.
You can suppress Windows event log entries by setting up a registry key. The registry key is:
Software\Sybase\SQL Anywhere\11.0\EventLogMask |
and it can be placed in either the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE hive. To control event log entries, create a REG_DWORD value named EventLogMask and assign it a bit mask containing the internal bit values for the different Windows event types. The three types supported by the SQL Anywhere database server are:
EVENTLOG_ERROR_TYPE 0x0001 EVENTLOG_WARNING_TYPE 0x0002 EVENTLOG_INFORMATION_TYPE 0x0004 |
For example, if the EventLogMask key is set to zero, no messages appear at all. A better setting would be 1, so that informational and warning messages don't appear, but errors do. The default setting (no entry present) is for all message types to appear. Here is a sample registry change file.
REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere\11.0] "EventLogMask"=dword:00000007 |
Registering DLLs on Windows
Deploying databases
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |