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 the Product

The product consists of the following components:

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

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 platform client.

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

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

If you received a boxed version of Pervasive.SQL 9 SP1 (9.1), your package contains a printed copy of Getting Started with Pervasive.SQL V8 (Server Edition) and the Status Codes and Messages Quick Reference card. You can order a complete hardcopy set of the manuals through the Pervasive Software Sales Team.

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 in hardcopy except where noted:

This book - Getting Started with Pervasive.SQL 9 (Server Edition) - helps you to get Pervasive.SQL 9 SP1 (9.1) Server engine running with installation, setup, and basic configuration information based on your operating environment.

Getting Started with Pervasive.SQL 9 (Workgroup Edition) - helps you to get Pervasive.SQL 9 SP1 (9.1) Workgroup engine running with installation, setup, and basic configuration information based on your operating environment. This title is not available in hardcopy.

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 database engine 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 - details 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, which is recommended for most first time users, takes default actions for most operations performed during the installation.

The Complete setup installs the following components:

Database engine (including ODBC interface)

All client requesters (Win32 and MS-DOS requesters)

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 server installation, the following components are optional:

Pervasive.SQL Control Center and JavaHelp documentation

Other Utilities (except minimum set)

Note
Client installation programs for DOS, Windows, and Linux are not part of the server installation. You must run a separate installation program for Pervasive.SQL clients. See Installing Pervasive.SQL Clients for Windows for more information.

On Windows, the default installation location is C:\PVSW, assuming the Windows system drive is C.

On NetWare, the default installation location is SYS:\SYSTEM.

On Linux, the default installation location is /usr/local/psql.