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

Pervasive.SQL 8.7 (code GSW_870, revision 1)  Sync manual in Pervasive Library

About This Manual

Who Should Read This Manual

Manual Organization

Getting Ready to Install

Installing the Engine

Customizing Pervasive.SQL Workgroup

After Installation

Supplemental Information

Conventions

Getting Ready to Install

Welcome to Pervasive.SQL

About Pervasive.SQL

Competitive Advantages

Relational or Transactional Access

About Pervasive.SQL Workgroup

Purpose

Where to Install

User Licenses

Features

Preparing to Install Pervasive.SQL

Installation Overview

Major Components of Pervasive.SQL V8

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 NT Server

Windows 2000 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 V8 with No Previous Installation

Before You Begin

Installing Over Existing Pervasive Products

Installation Tips

Accessing README file information

Installing the Pervasive.SQL V8 Workgroup Engine

Post Installation

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL V8

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

Post Installation

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL V8

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

SPX Protocol and the Workgroup Engine

Avoiding Unavailable Protocols

Client Network Configuration

Default Settings

How to Configure the Pervasive Clients

Configuring the Win32 Requester

Configuring the Win16 Requester

Network Path Formats Supported by Pervasive Requesters

Universal Naming Convention (UNC) Path Formats

Drive-based Formats

NetWare Specific Formats

UNIX 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 NT/2000 Server

Tasks

Using SPX to Connect to a Windows NT/2000 Server

Name Resolution

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 NT or 2000

Running DOS Applications on Windows 9x/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 Servers 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 V8 Issues

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

Additional Resources

Printed Documentation

Developer Center

Pervasive.SQL Knowledge Base

FTP Site

Online Documentation

Pervasive Library

Webinars

Subscription Based E-mail Services

DevTalk

Newsgroup

E-Mail Contacts

Technical Support

Supplemental Information

Introduction to Networking

About this Document

Audience

Conventions

Summary of Content

Terminology

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


Pervasive logo
Pervasive Software, Inc.
http://www.pervasive.com
Voice: (512) 231-6000
Fax: (512) 231-6597
Pervasive Sales Support
Contact Technical Support
Pervasive DevTalk Forums
Pervasive Developer Center
Sync manual in Pervasive Library Index