Installation Overview

This section provides an overview to the components that make up Pervasive.SQL 9 SP1 (9.1). Also included in this section is information on the files included in the different types of installation.

Major Components of Pervasive.SQL 9 SP1 (9.1)

Pervasive.SQL 9 SP1 (9.1) consists of the following components:

Pervasive.SQL 9 SP1 (9.1) Database Engine

Pervasive.SQL 9 SP1 (9.1) consists of two database sub-engines:

MicroKernel Database Engine (MKDE), which provides Btrieve/MicroKernel API support for Pervasive.SQL applications

SQL Relational Database Engine (SRDE), which provides ODBC/SQL API support for Pervasive.SQL applications

Note
The Pervasive.SQL 9 SP1 (9.1) stand-alone client install is not included in the Workgroup edition of Pervasive.SQL 9 SP1 (9.1). Each installation of Workgroup edition includes all client components, so a separate install is not needed.

Client

Requesters that allow you to access the server-based MicroKernel from a DOS client, a Windows 98/ME client, or a Windows 32-bit client.

The 16-bit requesters used in DOS clients are Btrieve requesters only and have no relational access.

Pervasive.SQL 9 SP1 (9.1) Utilities

Pervasive.SQL 9 SP1 (9.1) includes a suite of useful utilities for every phase of database management from engine installation and configuration to data maintenance. They include the following:

Pervasive System Analyzer (PSA)

Pervasive.SQL Control Center(PCC)

SQL Editor

Table Editor

Configuration properties for client and engines

Monitor

Function Executor

Maintenance

Rebuild

License Administrator

ODBC Administrator

Gateway Locator

Printed Documentation

Individual manuals, and the complete set, are available for purchase through the Pervasive Web site or through the Pervasive Software Sales Team. To order, contact Pervasive Software online at http://www.pervasive.com/ecommerce/Scripts/default.asp, e-mail salessupport@pervasive.com, or telephone 1-800-287-4383.

Online Documentation

The complete Pervasive.SQL 9 SP1 (9.1) documentation set is provided in Javahelp format. This help also serves as the context-sensitive help for the Pervasive.SQL Control Center.

Documentation Titles

The following titles are included in the online library and are available for purchase in hardcopy:

Getting Started with Pervasive.SQL 9 (Server and Workgroup Editions)-helps you to get Pervasive.SQL running with installation, setup, and basic configuration information based on your operating environment.

Pervasive Products and Services-provides an overview of Pervasive Software products and services, including support options and information regarding licensing and registration. This manual also describes the database and product architectures.

Pervasive.SQL User's Guide-gives basic information on the utilities provided with the Pervasive.SQL Control Center, including several interactive wizards designed to help you accomplish basic database tasks. This manual also contains information on the Linux version and the utilities available for that particular platform.

SQL Engine Reference-provides database programmers a complete reference guide to the SQL relational database language supported in Pervasive.SQL 9 SP1 (9.1).

Advanced Operations Guide-explains tasks typically performed by Network or System Administrators, using various tools such as the Rebuild, Maintenance, Monitor, and Function Executor utilities.

Status Codes and Messages-lists the error and informational codes and messages that can be received when using Pervasive software.

Installation Options

Pervasive.SQL 9 SP1 (9.1) offers Complete and Custom installation options. You can accept default installation parameters by selecting the Complete install, or you can specify certain installation parameters by selecting the Custom install option.The following sections outline the major differences in these two installation options.

Complete Setup Installation

The Complete installation is recommended for most users. This option takes default actions for most operations performed during the installation.

The Complete setup installs the following components:

Pervasive.SQL 9 SP1 (9.1) Engine (including ODBC interface)

Pervasive.SQL Control Center and other utilities

Transactional and Relational interfaces

Online documentation in Javahelp format

Custom Setup Installation

Selecting Custom setup type allows you to specify the program folder name and select the components to install.

During a Custom setup, the following components are optional:

Pervasive.SQL Control Center and Javahelp documentation

Other Utilities (except for a minimum set)

The default installation location for Pervasive.SQL 9 SP1 (9.1) is C:\PVSW, assuming the Windows system drive is C.