SYBASE(r) SQL ANYWHERE(tm) A SYSTEM 11 SERVER PRODUCT SQL Anywhere Release: 5.5.00 Last modified: September, 96 Contents ======== 1. Supplied Software and System Requirements 2. Installation CHAPTER 1: Supplied Software and System Requirements ==================================================== About this chapter ------------------ This chapter describes the software included on the CD-ROM, outlines the system requirements to install and run the software, and provides an overview of the license agreement. The license agreement defines your rights and obligations with respect to the software. You should read the license agreement itself before installing any software; the overview in this section is provided for convenience only. Last minute changes ------------------- For information about last-minute changes, see the README.1ST text file in the installation directory once you have installed the software. CD-ROM contents --------------- The CD-ROM contains some or all of the following separately installable software components: * Professional Server software (includes Standalone Engine with SQL Remote) * Professional Standalone software (includes Standalone Engine with SQL Remote) * Standard Server software (includes Standalone Engine with SQL Remote) * Client software * Standard Standalone Engine software * Standard Standalone Engine with SQL Remote software SQL Remote is a message-based system for data replication between SQL Anywhere databases. Professional Edition -------------------- The Professional options are available only with the Professional version of the software. The Professional options allow you to install the following additional components: * Powersoft InfoMaker a powerful reporting tool. * NetImpact Dynamo a package to enable your database for the Internet. Operating Systems ----------------- Each of the Standard installation components is provided for each of the following operating systems: * Windows NT * Windows 95 * Windows 3.x * OS/2 * DOS * NetWare (server only) * QNX (availability uncertain) The Professional installation components are provided for Windows NT and Windows 95 only. License agreement summary ------------------------- The Sybase SQL Anywhere License Agreement included in the package gives a full description of your rights and obligations regarding installation and use of this product. This section provides a summary of those rights. The license agreement itself is the definitive statement of your rights and obligations; this section is for your convenience only. Read the license agreement before installing any software. If there is any discrepancy between this section and the license agreement, the license agreement prevails. SQL Anywhere base package If you purchased the SQL Anywhere base package, you are licensed to have a single copy of the Server software installed, for a single operating system on a single machine, at any one time. The Server software includes the standalone engine software with SQL Remote. For example, you may have one (and only one) copy of the Netork Server for NT installed at one time. You may not have any other Server or Standalone Engine installed at the same time without purchasing additional licenses. All programs must be installed on the same computer. You are also licensed to install one Client for a single operating system on a single machine, for use with a properly licensed SQL Anywhere Network Server. Installation of further clients requires the purchase of additional Client licenses. You are licensed to replace an installation of one installation choice with a different installation for the same or a different operating system. You must purchase a Client license for each accessor to the SQL Anywhere Network Server whether such accessor is a SQL Anywhere client or not. SQL Anywhere Concurrent Server package If you purchased the SQL Anywhere Concurrent Server package, you are licensed to have a single copy of the Server software installed, for a single operating system on a single machine, at any one time. You are also licensed to install an unlimited number of SQL Anywhere Clients, provided that the total number of accessors to the SQL Anywhere Server does not exceed the total number of concurrent devices licensed. Additional SQL Anywhere licenses Additional Client, Server, Standalone Engine, and Standalone Engine with SQL Remote licenses are also available. Special licensing is also available permitting use of SQL Anywhere as an Internet Web Server supporting an unlimited number of connections. Please contact Sybase for more information. Use of multiplexes Use of software or hardware that reduces the number of accessors to the server (sometimes called "multiplexing", "pooling", or "application servers") does not reduce the number of licensed clients, but rather the number of licensed clients required includes the number of distinct inputs to the multiplexing software or hardware System requirements ------------------- SQL Anywhere requires an Intel-based PC running the operating system for the version you install. Processor requirements SQL Anywhere requires an Intel i386 or higher processor. The Client software and the Windows 3.x 16-bit engine run on Intel 286 or higher processors. Disk space requirements Disk space requirements for each installation component are described in the following sections. SQL Anywhere Server The database server software and development components together require approximately the following amounts of space on your hard disk: Operating system Disk space ------------------------------------------------ DOS 14 Megabytes NetWare 6 Megabytes (NetWare server) 20 Megabytes (local machine) OS/2 12 Megabytes Windows NT 14 Megabytes Windows 95 14 Megabytes Windows 3.x 12 Megabytes QNX 6 Megabytes If you install the Open Client components or the Professional features, additional disk space is required. SQL Anywhere Standalone Engine The Standalone Engine software and development components together require approximately the following amounts of space on your hard disk: Operating system Disk space ----------------------------------------------- DOS 12 Megabytes OS/2 10 Megabytes Windows NT 13 Megabytes Windows 95 13 Megabytes Windows 3.x 10 Megabytes Installation with SQL Remote requires an additional 0.5Mb of disk space. If you install the Open Client components or the Professional features, additional disk space is required. SQL Anywhere Client software The Client software requires approximately the following amounts of space on your hard disk: Operating system Disk space ----------------------------------------------- DOS 12 Megabytes OS/2 6 Megabytes Windows NT 9 Megabytes Windows 95 9 Megabytes Windows 3.x 5 Megabytes QNX 9 Megabytes Operating system and memory requirements The database engine uses a minimum of 1 Megabyte of memory. The database engine also requests memory for a cache as specified on the command line; if this memory is not available the database engine does run, but performance suffers. The operating system version and minimum total memory requirements are as follows: Operating system Earliest version Minimum total machine memory ---------------------------------------------------------------------- DOS 5.0 4 Megabytes NetWare 3.11 16 Megabytes OS/2 2.0 8 Megabytes Windows 95 Windows 95 8 Megabytes Windows NT 3.5 16 Megabytes Windows 3.x 3.1 4 Megabytes QNX 4.1 OS requirements + 1Mb Network software requirements If you are running a database server on a network, you must have appropriate networking software installed and running. SQL Anywhere clients and database servers support the following network protocols: Operating system Supported protocols ----------------------------------------------------- DOS NetBIOS and IPX NetWare IPX and TCP/IP OS/2 NetBIOS, IPX, TCP/IP Windows NT/95/3.x NetBIOS, IPX, TCP/IP QNX TCP/IP and QNX message link CHAPTER 2: Installation ======================== About this chapter ------------------ This chapter leads you through the installation process. The CD-ROM contains complete installations, for each of the supported operating systems, for the following: * Professional Server software (includes Standalone Engine with SQL Remote) * Professional Standalone software (includes Standalone Engine with SQL Remote) * Standard Server software (includes Standalone Engine with SQL Remote) * Client software * Standard Standalone Engine software * Standard Standalone Engine with SQL Remote software The software you are entitled to install is determined by the package or license you have purchased. See the previous chapter for a description. To install SQL Anywhere Professional on Windows NT, you must be logged on as a user with Administrator privileges. Choose the correct installation program --------------------------------------- The installation programs are in the top directory of the CD-ROM. The following installation programs are provided: * To install software from OS/2, run the INSTALL.EXE installation program. * To install software from Windows NT, Windows 95, Windows 3.x, or DOS, run the SETUP.EXE installation program. * To install the QNX client or server software, run the standard QNX installation process. To start the process, type /etc/install The remainder of the installation description does not apply to QNX installations. The SQL Anywhere server for NetWare is a special case. To install a NetWare database server, you run the installation program from a client workstation. You should run SETUP or INSTALL, depending on the client workstation operating system. The installation program installs software for the operating system you are currently running. Enter your registration number ------------------------------ The installation program asks you to enter your registration number. Your registration number is the 12-digit code printed on your registration card. Entering a valid registration number helps ensure that you install only software for which you have a valid license. You are presented with a choice of options: the choices depend on the kind of license you have purchased. Choose the software you wish to install --------------------------------------- The installation program presents you with a choice of options, depending on the license or package you have purchased: If you have purchased the SQL Anywhere Professional base package, you are presented with the following options: * Professional Server software (includes Standalone Engine with SQL Remote) * Professional Standalone Client software (includes Standalone Engine with SQL Remote) * Standard Server software (includes Standalone Engine with SQL Remote) * Client software * Standard Standalone Engine software * Standard Standalone Engine with SQL Remote software If you have purchased the SQL Anywhere base package, you are presented with the following options: * Sybase SQL Anywhere Server (includes Engine/SQL Remote) * Sybase SQL Anywhere Client * Sybase SQL Anywhere Standalone Engine * Sybase SQL Anywhere Standalone Engine with SQL Remote If you have purchased a SQL Anywhere Concurrent Server license, you are presented with the following options: * Sybase SQL Anywhere Server (includes Engine/SQL Remote) * Sybase SQL Anywhere Client If you have purchased any other license, you are not presented with a choice of software to install. In this case you should skip the following section. The installation program installs software for the operating system you are currently using. If you run the installation program from Windows 95, software for Windows 95 is installed on your computer. If you select the Sybase SQL Anywhere Standalone Engine while running Windows NT, the installation program installs the Standalone Engine for Windows NT. Click the option you wish to install, and click Install to continue. Choose the process you want to carry out ---------------------------------------- Once you have chosen the software to install, choose which process you wish to carry out: * Install or reinstall the software * Uninstall the software * Create installation diskettes * Create a package for Microsoft Systems Management Server Choosing to install the software installs into a directory of your choice. Uninstalling the software removes files from your computer. Creating installation diskettes copies files onto a set of installation diskettes, together with a SETUP.EXE or INSTALL.EXE program, for later installation onto a hard drive. If you are a System Administrator using Microsoft Systems Management Server, you can choose to create a package for unattended installation. If you choose to create installation diskettes, you will be presented with a window informing you how many 1.44Mb diskettes you need, and guided through copying files onto the diskettes. Once you have clicked one of the choices, click OK to continue. Install/reinstall the software If you choose to install software, the installation program prompts you for an installation directory. The default installation directory is C:\SQLANY50. If you wish to install the application into a directory other than the default, type the name of another installation directory and/or drive, and click OK to continue. The installation program also asks if you wish to install some optional components. You can install these components now, or at a later time, or not at all: * NetImpact Dynamo (Professional Edition only) NetImpact Dynamo is a package for bringing Internet features to your database. * Powersoft InfoMaker (Professional Edition only) The powerful reporting tool from Powersoft. * C/C++ development components If you will be developing C or C++ applications for SQL Anywhere, you should choose to install the development components. These include header files and sample code for C and C++ development projects as well as libraries and the preprocessor. * DLLs for version 3.2 and 4.0 applications If you have applications that explicitly specify a version 3.2 or 4.0 DLL, you should choose to install these components. Once you have selected the components to install, click OK. Open Server Components A separate window offers you a choice of installing the Open Server Gateway and the Open Server components (not available for all operating systems). The Open Server components are available for the Windows NT, NetWare, and OS/2 server installations only. These components are required if you will be using or developing client applications that connect to SQL Anywhere using the Open Server Gateway. The Open Server Gateway is provided for compatibility with Sybase SQL Server. If you are not developing applications using Sybase client libraries, you will not need the Open Server Gateway or the Open Server Components. The installation program installs the options that are checked, and uninstalls any unchecked options. Concurrent server license If you have purchased a SQL Anywhere Concurrent Server license, you are prompted for the license diskette once the files are copied. If you have purchased the SQL Anywhere base package or another license, you are prompted to enter your name and organization. Changes made by the installation program In addition to installing the SQL Anywhere fles onto your computer, the installation program makes some other changes to your system. These changes are described here, along with other changes you may wish to make in order to run the software. The descriptions here assume the installation directory is C:\SQLANY50. If you have installed into a different directory, the new name should be substituted below. Changes to the DOS AUTOEXEC.BAT and CONFIG.SYS files The DOS, Windows 3.x, and Windows 95 installations modify the DOS AUTOEXEC.BAT and CONFIG.SYS files. It prompts you whether to make the changes in place, or save them for you to make later in the files C:\SQLANY50\AUTOEXEC.DOS and C:\SQLANY50\CONFIG.DOS. These changes ensure that certain configuration parameters are adequate to run the software and set some environment variables used by the software. We recommend that you allow the install program to make the changes to these files-a backup copy of these files is automatically made (CONFIG.BAK and AUTOEXEC.BAK). The changes to AUTOEXEC.BAT are: * Add the operating system subdirectory of your installation directory to your path. For example, if you have installed the Windows 3.x version into the default installation directory, then C:\SQLANY50\WIN is added to your path. * Set the SQLANY environment variable to point to the installation directory. The changes to CONFIG.SYS are: * Ensure that the maximum number of open FILES parameter is set to at least 20. * Ensure that the BUFFERS parameter is at least 30. Changes to the OS/2 CONFIG.SYS file The OS/2 installation modifies the OS/2 configuration file, CONFIG.SYS. It prompts whether to make the changes in place, or save them for you to make later in the file C:\SQLANY50\CONFIG.NEW. Some of the SQL Anywhere software will not run without the changes to the CONFIG.SYS file, so we recommend that you allow the install program to make the changes to the file-a backup copy of this file is automatically made (CONFIG.BAK). The PATH and LIBPATH environment variables are modified to include C:\SQLANY50\OS2, and the SQLANY environment variable is set to C:\SQLANY50. The HELP environment variable is modified to include C:\SQLANY50\OS2. The Windows NT Registry In addition to the ODBC changes described below, the Windows NT installation makes the following changes to the registry: * Add the C:\SQLANY50\WIN32 directory to your path. * Set the SQLANY environment variable to C:\SQLANY50. * Sets registry entries for NetImpact Dynamo and SQL Central. The NetWare AUTOEXEC.NCF file The NetWare installation procedure does not automatically change the AUTOEXEC.NCF file. To avoid having to specify a full path every time you want to start up the SQL Anywhere. NLM server, you should install it into the SYS:\SYSTEM directory on your NetWare server. If you do install the NLMs elsewhere, you may wish to add that directory to your NetWare server search path. To do this, add the following line to your AUTOEXEC.NCF file: search add SYS:\SQLANY50 NetWare installation directory If you install the SQL Anywhere database server NLM in a directory other than \SYSTEM and you have run the SECURE CONSOLE command under NetWare, you will not be able to run the database server NLM. QNX changes A symbolic link is created from the usr/bin directory to the bin subdirectory of the installation directory for all executable files in the directory, with exceptions listed below. The link has the same name as the file, with the exception of the following: link name executable name ------------------------------------ dbclient dbclient32 dbsrv50 dbsrv50 isql isql32 rtsql rtsql32 Links are created from the /etc/sqlany50 directory to the help subdirectory for the dbserver.hlp and isql.hlp files. The links have the same name as the files. Changes to ODBC data sources For Windows 3.x, Windows 95, Windows NT, and OS/2, the setup program installs the SQL Anywhere ODBC driver into the ODBCINST.INI file or registry, and the SQL Anywhere 5.0 Sample data source into the ODBC.INI file or registry. For Windows 3.x, Windows 95, Windows NT, and OS/2 clients, the setup program installs the SQL Anywhere ODBC driver into ODBCINST.INI and a SQL Anywhere 5.0 Sample Client data source into ODBC.INI. The Windows 3.x, Windows 95, and Windows NT installations convert ODBC data sources for Watcom SQL to use the drivers from the SQL Anywhere 5.0 installation. You can choose to convert all data sources, selectively convert one at a time, or not convert any. Obtaining updates Periodically, updates to this release of the software (patches) will be made available. You can obtain these updates in one of the following ways. Obtaining updates electronically Updates to the software (patches) are put up on the BBS, Compuserve forum, World-Wide Web site and FTP site. They can be downloaded free of charge. See the Contact Sheet for addresses and numbers. Upgrade subscriptions For greater convenience, and to be sure your software is as current as possible, you can purchase an Upgrade Subscription. With a Sybase SQL Anywhere Upgrade Subscription you automatically receive a CD-ROM containing updated software whenever an update becomes available. See the Customer Services Reference Guide for contact numbers and addresses.