Getting Started with Pervasive PSQL v9 SP2 (9.5) (Workgroup edition) - Table of Contents

Pervasive PSQL v9 SP2 (9.5) (code GSW_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 Pervasive PSQL Workgroup

Preparing to Install Pervasive PSQL

Installation Overview

Major Components of Pervasive PSQL v9 Service Pack 2

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

Workgroup Engine Running as a Service

Installing the Engine

Installing Pervasive PSQL with No Previous Installation

Before You Begin

Installing Over Existing Pervasive Products

Installation Tips

Accessing README file information

Installing the Pervasive PSQL Workgroup Engine

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive PSQL

Uninstalling Pervasive PSQL Workgroup

Upgrading Your Pervasive PSQL Installation

Before You Begin

Considerations

Platform Notes for Windows

Migration of Existing Configuration Settings

Installing Over Existing Pervasive Products

Installation Tips

Accessing README file information

Upgrading to Pervasive PSQL Workgroup Engine from Earlier Pervasive.SQL Versions or Btrieve 6.x

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive PSQL

Customizing the Workgroup Engine

Network Settings

Determining What Kind of Network You Have

Database Engine on Windows

Default Engine Settings

Setting Up TCP/IP Support

Setting Up NetBIOS Support

Avoiding Unavailable Protocols

Configuring Network Communications for Clients

Default Settings

How to Configure the Pervasive Clients

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

Using TCP/IP to Connect to a Linux Server

Tasks

Using the DOS Requesters

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

Using Multiple Applications

Settings Affected by Multiple Applications

Using a Server Engine and a Workgroup Engine Concurrently

Using a Workgroup Engine to Access Local Files and a Remote Server Engine to Access Remote files

Accessing Data on Other Computers

Using the DOS Requesters

Overview

Requesters Available to Access Workgroup Engines

Requesters Available to Access Remote Server Engines

Supported Configurations

DOS Box Support on Windows

Win16 and DOS Workstations

Running DOS applications on Windows 32-bit Platforms

Running DOS Applications on Windows 98/ME

Verifying the DOS Configuration

Configuring the Workgroup Engine

Overview

Installation Requirements

Operating System Security

When to Use Workgroup

What is a Gateway Engine?

Multiple Engine File Sharing

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

After Installation

Connecting Clients to a Pervasive PSQL 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

Users's Guide

Advanced Operations Guide

Installation Troubleshooting

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

Obtaining File, Client, and Engine Version Number

Determining Client and Engine Version

Determining a File Version

Troubleshooting Common Pervasive PSQL Issues

Issues After Uninstalling Pervasive PSQL on Windows

How to Get Additional Help

Thirty-Day Free Technical Support

Additional Resources

Printed Documentation

Developer Center

Pervasive PSQL Knowledge Base

Subscription Based E-mail Services

Supplemental Information

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

Microsoft Windows Networks that Include Novell Servers

Methods of Troubleshooting Your Network

Ping

Pervasive System Analyzer (PSA)

Expanding Your Basic Network

Server Operating Systems

Additional Reading