Installation directory structure

When you install SQL Anywhere, several directories are created. Some of the files in these directories are essential, and others are not. This section describes the directory structure.

SQL Anywhere software, whether you receive it as a product or bundled as part of another product, is installed under a single installation directory. The SQLANY11 environment variable specifies the location of the installation directory. See SQLANY11 environment variable.

SQL Anywhere installation directory

The SQL Anywhere installation directory itself holds several items, including the following:

  • Read Me First   A Read Me First file named readme.txt holds last minute information.

For platforms other than Windows Mobile, there are several directories under the installation directory:

  • Executable directories   There is a separate directory for each operating system platform, which holds configuration files and context-sensitive help files.

    On Windows, except Windows Mobile, these files are installed in the bin32 or bin64 directory. If you are using Unix, they are installed in the bin32 or bin64 and lib32 or lib64 directories.

    You only have the directories required for your operating system version.

  • java directory   JAR files are stored in this directory.

  • scripts directory   The scripts directory contains SQL scripts that are used by the database administration utilities and as examples.

  • \SDK\Include directory   The \SDK\Include directory contains header files for developing C/C++ applications for SQL Anywhere. On Unix, this directory is called include.

Windows Mobile file locations

On Windows Mobile devices, all files are installed in the installation directory \Program Files\SQLAny11, except for DLLs, which are installed in the \Windows directory. No subdirectories are created.

Unix file locations

The language resources are installed in the res directory, and the shared objects are installed in the lib32 or lib64 directory.

Samples directory

When you install SQL Anywhere 11, you can choose the directory where the samples are installed. The documentation refers to this location as samples-dir.

The SQLANYSAMP11 environment variable specifies the location of samples-dir. See SQLANYSAMP11 environment variable.

On Windows, you can access the samples from the Start menu by choosing Programs » SQL Anywhere 11 » Sample Applications And Projects.

The following table shows default and typical locations of samples-dir for each supported operating system:

Operating system Default installation location (samples-dir) Typical installation location
Windows XP/200x %ALLUSERSPROFILE%\Documents\SQL Anywhere 11\Samples C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples1
Windows Vista %PUBLIC%\Documents\SQL Anywhere 11\Samples C:\Users\Public\Documents\SQL Anywhere 11\Samples
Windows Mobile \Program Files\SQLAny11
Unix and Linux /opt/sqlanywhere11/samples Script provided to copy samples to user-specified directory.
Mac OS X /Applications/SQLAnywhere11/Samples Script provided to copy samples to user-specified directory.

1 When accessing the SQL Anywhere samples directory in Windows Explorer, the location is Documents and Settings > All Users > Shared Documents > SQL Anywhere 11 > Samples. However, if you are accessing the SQL Anywhere samples directory from a command prompt, the path is C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples.