home *** CD-ROM | disk | FTP | other *** search
- 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.
-
-