Getting Started with Pervasive.SQL 9 (Server Edition) - Table of Contents

Pervasive.SQL 9.1 (code GSS_910, revision 1) Sync manual in Pervasive Library

About This Manual

Who Should Read This Manual

Manual Organization

Getting Ready to Install

Getting Ready to Install

Welcome to Pervasive.SQL

About Pervasive.SQL

Competitive Advantages

Relational or Transactional Access

About the Server Engine

Purpose

Where to Install

Additional User Licenses

Features

Preparing to Install Pervasive.SQL

Installation Overview

Major Components of the Product

Installation Options

Installation Checklist

Quick Checklist

Check the Hardware Requirements

Check the Software Requirements

Ensure Adequate Permissions

Verify Compatibility of Vendor Applications

Schedule the Upgrade and Perform with Care

Installing to a Cluster

Check for Special Configuration Issues

Read the README File

Pervasive.SQL and Terminal Services

Overview

Supported Environments

Licensing

Installation

Windows 32-bit Server

Configuration and Runtime

Remote Configuration with PCC

Terminal Server as Network Server

Installing Components for Windows

Installing Pervasive.SQL Server for Windows

Before You Begin

Platform Notes

Installation Tips

Installing Pervasive.SQL Server

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL

Where To Go From Here

Uninstalling Pervasive.SQL Server

Installing Pervasive.SQL Clients for Windows

Before You Begin

Understanding Client Requesters

Types of Windows Requesters

Installation

Configuration

Installing the Pervasive.SQL Client Components

Restarting Your Computer After Installation

Custom Installation Path

Where To Go From Here

Installing DOS Requesters

Available Requesters

Installation of the DOS Requesters

Alternate DOS Requesters

Network Communication with Pervasive.SQL Server for Windows

Determining What Kind of Network You Have

Server Engine on Windows

Server Engine on NetWare

Server Engine on Linux

Network Communication Settings

Setting Up TCP/IP Support

Setting Up SPX Support

Avoiding Unavailable Protocols

Upgrading Your Pervasive.SQL Installation for Windows

Before You Begin

Considerations

Platform Notes

Migration of Existing Configuration Settings

Installing Over Existing Pervasive Products

Accessing README file information

Upgrading to Pervasive.SQL Server from Earlier Pervasive.SQL Versions or Btrieve 6.x

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL

Application Configuration Scenarios

Support for Active Directory Service

What Is Active Directory?

Installation of Active Directory

Installation of Pervasive.SQL

Pervasive Administrative Authority

Active Directory Tasks

Multiple Client Applications

Settings Affected by Multiple Applications

Concurrent Local and Remote Applications

Installing Components for NetWare

Installing Pervasive.SQL Server for NetWare

Before You Begin

Platform Notes for NetWare

Installing Over Existing Pervasive Products

Installation Tips

NetWare Security and Configuration Issues

Installing the Pervasive.SQL Server Components

Custom Installation Path

Excluding Features

Common Questions After Installing Pervasive.SQL

Network Settings for Server Engine on NetWare

Determining What Kind of Network You Have

Server Engine on NetWare

Mixed NetWare and Microsoft Network

Default Settings

Setting Up TCP/IP Support

Setting Up SPX Support

Disabling Certain Protocols

Application Configuration on NetWare

Local Applications on NetWare Servers

NSS Volume Support

Installing Components for Linux

Installing Pervasive.SQL Server for Linux

Before You Begin

Samba Package Installation

Platform Notes

Installing Pervasive.SQL Server Using RPM

Installing Pervasive.SQL Server Using Tar

After Installation

User Count License

Accessing README File Information

Configuration

Common Questions After Installation

Uninstalling the Server Engine

Installing Pervasive.SQL Client for Linux

Before You Begin

Hardware/Software Requirements

Linux Client in Conjunction with Server Engine

Installing the Pervasive.SQL Client Using RPM

Verifying an RPM Installation

Installing the Client Using Tar

After Installation

Configuring the Linux Client

Common Questions After Installing the Linux Client

Uninstalling the Pervasive.SQL Client

Installing PCC and Documentation on Linux

Before You Begin

Pervasive.SQL Control Center

Documentation

Required Conditions for Installation

Installing Pervasive.SQL Control Center Using RPM

RPM Installation Steps

After Installation

Accessing README file information

Installing Pervasive.SQL Control Center Using Tar

Tar Installation Steps

Accessing README file information

Installing Pervasive.SQL Documentation Using RPM

RPM Installation Steps

After Installation

Accessing README file information

Installing Pervasive.SQL Documentation Using Tar

Tar Installation Steps

Accessing README file information

After Installation

How to Access the Documentation

Common Questions After Installing PCC and Documentation

Uninstalling Pervasive.SQL Control Center

Uninstalling Pervasive.SQL Documentation

Upgrading Your Pervasive.SQL Installation for Linux

Before You Begin

Samba Package Installation

Platform Notes

Upgrading Pervasive.SQL Server Using RPM

Upgrade Pervasive.SQL 9

Upgrade Versions Older than Pervasive.SQL 9

Installation Information

User Count License

Accessing README file information

Upgrading Pervasive.SQL Server Using Tar

Upgrade Pervasive.SQL 9

Upgrade Versions Prior to Pervasive.SQL 9

Upgrading Pervasive.SQL Client Using RPM

Upgrade Pervasive.SQL 9

Upgrade Versions Prior to Pervasive.SQL 9

Upgrading Pervasive.SQL Client Using Tar

Upgrade Pervasive.SQL 9

Upgrade Versions Prior to Pervasive.SQL 9

After Upgrading

Configuration

Common Questions After Upgrading

Using Pervasive.SQL on Linux

Finding What You Need

Accessing the JavaHelp Documentation

Man Pages

Exclusions

Pervasive.SQL Account Management on Linux

After Installation Behavior

The User Environment

Using Utilities from Users Other than psql

Configuration

Configuration File

Authentication

Supported Path Formats for Samba

Client Information

Authentication to Remote Machines

Creating a Client DSN

Internationalization with the Client

Setting Up Web-based Data Access

ODBC Behavior

Configuring Web Server

PHP

Perl

Using Perl and ODBC with Pervasive.SQL

Code Snippet for Perl and DBI

Working With Pervasive.SQL Clients

Connecting Clients to a Sample Database

Basics About Pervasive.SQL Engines and Clients

Every Engine is Also a Client

Clients

Connect a Client to a Pervasive.SQL Server

Use the Client to Obtain Data from the Server

Become an Expert User

User's Guide

Advanced Operations Guide

Configuring Network Communications for Clients

Default Settings

How to Configure the Pervasive Clients

Win32 Configuration Notes

Win16 Configuration Notes

Network Path Formats Supported by Pervasive Requesters

Universal Naming Convention (UNC) Path Formats

Drive-based Formats

NetWare Specific Formats

Linux Path Formats

Using TCP/IP to Connect to a NetWare Server

Using SPX to Connect to a NetWare Server

Using TCP/IP to Connect to a Windows 32-bit Server

Tasks

Using SPX to Connect to a Windows 32-bit Server

Tasks

NetBIOS and the Pervasive.SQL Server Engine

Using TCP/IP to Connect to a Linux Server

Tasks

Using the DOS Requesters

Overview

Requesters Available

Supported Configurations

Win16 and DOS Workstations

Running DOS applications on Windows 32-bit Platforms

Running DOS applications on Windows 98/ME

Verifying the DOS Configuration

DOS TCP/IP Technical Information

Configuring the Pervasive.SQL DOS Requester

After Installation

Troubleshooting After Installation

Troubleshooting Tools

Troubleshooting Strategies

Checklist for Problems

Troubleshoot the Problem

Configuration for Special Installation Situations

Diagnosing Problems with Pervasive System Analyzer (PSA)

How to Start PSA

Documentation for PSA

SmartScout Replaced by PSA

Verifying Database Engine is Running

Windows

Linux

NetWare

Obtaining File, Client, and Engine Version Number

Determining Client and Engine Version

Determining a File Version

Issues After Uninstalling Pervasive.SQL on Windows

Engine and Client Version Conflicts

Disabling the Client Mismatch Warning Messages

How to Get Additional Help

Thirty-Day Free Technical Support

Pervasive.SQL Resources and Contacts

Printed Documentation

Developer Center

Pervasive.SQL Knowledge Base

Subscription Based E-mail Services