Getting Started with Pervasive PSQL v9 SP2 (9.5) (Server Edition) - Table of Contents

Pervasive PSQL v9 SP2 (9.5) (code GSS_950, revision 1) Books in this release

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Getting Ready to Install

Welcome to Pervasive PSQL

About Pervasive PSQL

Competitive Advantages

Relational or Transactional Access

About the Server Engine

Purpose

Where to Install

Additional User Licenses

Features

Preparing to Install Pervasive PSQL

Installation Overview

Major Components of the Product

Installation Options

Installing Over a Previous Version

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 PSQL 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 PSQL Server for Windows

Before You Begin

Platform Notes

Installation Tips

Installing Pervasive PSQL Server

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive PSQL

Where To Go From Here

Uninstalling Pervasive PSQL Server

Installing Pervasive PSQL Clients for Windows

Before You Begin

Understanding Client Requesters

Types of Windows Requesters

Installation

Configuration

Installing the Pervasive PSQL 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 PSQL 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 PSQL 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 PSQL Server from Earlier Pervasive PSQL Versions or Btrieve 6.x

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive PSQL

Application Configuration Scenarios

Support for Active Directory Service

What Is Active Directory?

Installation of Active Directory

Installation of Pervasive PSQL

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 PSQL 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 PSQL Server Components

If You Choose Custom Install

Custom Installation Path

Return to Steps for Complete Installation

Common Questions After Installing Pervasive PSQL

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 PSQL Server for Linux

Before You Begin

Samba Package Installation

Platform Notes

Installing Pervasive PSQL Server Using RPM

Installing Pervasive PSQL Server Using Tar

After Installation

User Count License

Accessing README File Information

Configuration

Common Questions After Installation

Uninstalling the Server Engine

Installing Pervasive PSQL Client for Linux

Before You Begin

Hardware/Software Requirements

Linux Client in Conjunction with Server Engine

Installing the Pervasive PSQL 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 PSQL Client

Installing PCC and Documentation on Linux

Before You Begin

Pervasive PSQL Control Center

Documentation

Required Conditions for Installation

Installing Pervasive PSQL Control Center Using RPM

RPM Installation Steps

After Installation

Accessing README file information

Installing Pervasive PSQL Control Center Using Tar

Tar Installation Steps

Accessing README file information

Installing Pervasive PSQL Documentation Using RPM

RPM Installation Steps

After Installation

Accessing README file information

Installing Pervasive PSQL 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 PSQL Control Center

Uninstalling Pervasive PSQL Documentation

Upgrading Your Pervasive PSQL Installation for Linux

Before You Begin

Samba Package Installation

Platform Notes

Upgrading Pervasive PSQL Server Using RPM

Upgrade Pervasive PSQL 9

Upgrade Versions Older than Pervasive PSQL 9

Installation Information

User Count License

Accessing README file information

Upgrading Pervasive PSQL Server Using Tar

Upgrade Pervasive PSQL 9

Upgrade Versions Prior to Pervasive PSQL 9

Upgrading Pervasive PSQL Client Using RPM

Upgrade Pervasive PSQL 9

Upgrade Versions Prior to Pervasive PSQL 9

Upgrading Pervasive PSQL Client Using Tar

Upgrade Pervasive PSQL 9

Upgrade Versions Prior to Pervasive PSQL 9

After Upgrading

Configuration

Common Questions After Upgrading

Using Pervasive PSQL on Linux

Finding What You Need

Accessing the JavaHelp Documentation

Man Pages

Exclusions

Pervasive PSQL 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 PSQL

Code Snippet for Perl and DBI

Working With Pervasive PSQL Clients

Connecting Clients to a Sample Database

Basics About Pervasive PSQL Engines and Clients

Every Engine is Also a Client

Clients

Connect a Client to a Pervasive PSQL 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

Changing the Default Communication Ports

Services File

NetBIOS and the Pervasive PSQL 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 PSQL 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 PSQL on Windows

Engine and Client Version Conflicts

Disabling the Client Mismatch Warning Messages

How to Get Additional Help

Thirty-Day Free Technical Support

Pervasive PSQL Resources and Contacts

Printed Documentation

Developer Center

Pervasive PSQL Knowledge Base

Subscription Based E-mail Services