File locations and installation settings

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 SQLANY12 environment variable specifies the location of the installation directory. See SQLANY12 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

Unix file locations

Samples directory

When you install SQL Anywhere, you can choose the directory where the samples are installed. The documentation refers to this location as samples-dir. The %SQLANYSAMP12% environment variable specifies the location of samples-dir. See SQLANYSAMP12 environment variable.

To access the samples on Windows, click Start » Programs » SQL Anywhere 12 » Sample Applications And Projects.

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

Operating system	Default installation location	Typical installation location
Windows XP/2003	%ALLUSERSPROFILE%\Documents\SQL Anywhere 12\Samples	C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples ¹
Windows Vista, Windows 7, Windows Server 2008, Windows Server 2008 R2	%PUBLIC%\Documents\SQL Anywhere 12\Samples	C:\Users\Public\Documents\SQL Anywhere 12\Samples
Windows Mobile	\Program Files\SQLAny12
Mac OS X	/Applications/SQLAnywhere12/Samples
IBM AIX	/usr/lpp/sqlanywhere12/samples
Other Unix operating systems	/opt/sqlanywhere12/samples

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

How SQL Anywhere locates files
Registry and INI files

Discuss this page in DocCommentXchange.