Getting Started with Pervasive PSQL - Table of Contents

Pervasive PSQL v10 (show all books in this release)

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Welcome to Pervasive PSQL

About Pervasive PSQL

Competitive Advantages

Relational or Transactional Access

The Pervasive PSQL Transactional Interface

Benefits of the Transactional Interface

Transactional Features

The Pervasive PSQL Relational Interface

Benefits of the Relational Interface

Relational Features

About the Pervasive PSQL Engines

Pervasive PSQL Server

Pervasive PSQL Workgroup

Engine Feature Comparison

Pervasive PSQL SDK

Development Environment

Preparing to Install Pervasive PSQL

Installation Requirements

Installation Options

Complete Installation

Custom Installation

Pervasive PSQL v10 Products

Server Engine (64-bit)

Server Engine (32-bit)

Workgroup Engine (32-bit)

Client (64-bit)

Client (32-bit)

Pervasive PSQL v10 Optional Features

Xtreme I/O (Server 32-bit Only)

Pervasive Access Methods

Utilities

Documentation

Java Runtime Environment (JRE)

Installation Review

Quick Checklist

Common Pre-Installation Questions

Upgrading Your Pervasive PSQL Installation for Windows

Upgrading to Pervasive PSQL v10 From a Previous Version

Considerations When Upgrading to Pervasive PSQL v10

Common Questions After Upgrading to Pervasive PSQL

Installing Pervasive PSQL Server for Windows

Before You Install the Windows Server Engine

Platform Notes

Installation Tips

Installing Pervasive PSQL Server for Windows

Installing Pervasive PSQL Clients for Windows

Before You Install the Windows Client Engine

Installing the Pervasive PSQL Client for Windows

Installing the BTRBOX Requester

Win32 DOS Box Support

Understanding Client Requesters

Types of Windows Requesters

Configuration

Where To Go From Here

Installing Pervasive PSQL Workgroup for Windows

Before You Install the Windows Workgroup Engine

Installation Tips

Installing the Pervasive PSQL Workgroup for Windows

After Installing Pervasive PSQL for Windows

Common Questions After Installing Pervasive PSQL

Where To Go From Here

Uninstalling Pervasive PSQL

Configuring the Workgroup Engine

Overview

Installation Requirements

Operating System Security

When to Use Workgroup

What is a Gateway Engine?

Setting Up a Small Client/Server Configuration

Setting Up a Peer-to-Peer Configuration

Setting Up a Gateway Configuration

Floating or Fixed Gateway

Working with the Gateway Locator Utility

Running the Workgroup Engine as a Service

Configuration

Stopping the Service

Configuring Engine Network Communications

Determining What Kind of Network You Have

Database Engine on Windows

Engine Network Communication Settings

Setting Up TCP/IP Support

Setting Up SPX Support

Setting Up NetBIOS Support (Workgroup only)

Avoiding Unavailable Protocols

Configuring Network Communications for Clients

Client Network Communication Settings

Network Path Formats Supported by Pervasive Requesters

Universal Naming Convention (UNC) Path Formats

Drive-based Formats

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

Configuring a Client for the Server IP Address

Using SPX to Connect to a Windows 32-bit Server

Configuring Pervasive PSQL to use IPX/SPX

Changing the Default Communication Ports

Services File

Using TCP/IP to Connect to a Linux Server

Configuring a Client for the Server's IP Address

Using the DOS Requester

Supported Configurations

DOS Box Support on Windows

Running DOS Applications on Windows 32-bit Platforms

Application Configuration Scenarios

Terminal Services

Disabling Administrative Functions

Terminal Server as Network Server

Workgroup Engine Running as a Service

Active Directory Service

Pervasive Administrative Authority

Active Directory Tasks

Multiple Client Applications

Settings Affected by Multiple Applications

Concurrent Local and Remote Applications

Using the Server and Workgroup Engines Concurrently

Accessing Data on Other Computers

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)

Verifying Database Engine is Running

Windows Server (Non-Vista)

Windows Workgroup

Linux Server

Obtaining File, Client, and Engine Version Number

Determining Client and Engine Version

Determining a File Version

Engine and Client Version Conflicts

Troubleshooting Common Pervasive PSQL Issues

Issues After Uninstalling Pervasive PSQL on Windows

How to Get Additional Help

Technical Support

Introduction to Networking

Description of a Network

A Typical Small- to Midsized Office Network

Pervasive PSQL And Networking

Checklist

Pervasive PSQL Networking Settings

Basic Networking Using Pervasive PSQL With Microsoft Windows Systems

How to Install and Configure Networking Components

Verifying your Microsoft Windows Network Configuration

Setting Up Protocols on Windows

Basic File Sharing Setup

Methods of Troubleshooting Your Network

Ping

Pervasive System Analyzer (PSA)

Expanding Your Basic Network

Server Operating Systems

Additional Reading