Getting Started with Pervasive.SQL (Workgroup edition) - Table of Contents

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

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Getting Ready to Install

Welcome to Pervasive.SQL

About Pervasive.SQL

Competitive Advantages

Relational or Transactional Access

About Pervasive.SQL Workgroup

Preparing to Install Pervasive.SQL

Installation Overview

Major Components of Pervasive.SQL 9 SP1 (9.1)

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

Workgroup Engine Running as a Service

Installing the Engine

Installing Pervasive.SQL with No Previous Installation

Before You Begin

Installing Over Existing Pervasive Products

Installation Tips

Accessing README file information

Installing the Pervasive.SQL Workgroup Engine

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL

Uninstalling Pervasive.SQL Workgroup

Upgrading Your Pervasive.SQL 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.SQL Workgroup Engine from Earlier Pervasive.SQL Versions or Btrieve 6.x

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL

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.SQL 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.SQL 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

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.SQL 9 SP1 (9.1) Issues

Issues After Uninstalling Pervasive.SQL on Windows

How to Get Additional Help

Thirty-Day Free Technical Support

Additional Resources

Printed Documentation

Developer Center

Pervasive.SQL Knowledge Base

Subscription Based E-mail Services

Supplemental Information

Introduction to Networking

Description of a Network

A typical small- to midsized office network

Pervasive.SQL And Networking

Checklist

Pervasive.SQL Networking Settings

Basic Networking Using Pervasive.SQL 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