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.

¹ Required only if using system extended stored procedures and functions (xp_*).

² Required only if the database character set is multi-byte or if the UCA collation sequence is used.

³ On Windows Mobile, the file name to deploy is called dbicudt11.dat.

⁴ Required only if using Java in the database.

⁵ Required only if using Java in the database and remote data access.

Notes

Windows Registry entries

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 Admin 11.0.

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