Getting Started with Pervasive.SQL V8 (Server Edition) - Table of Contents

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

About This Manual

Who Should Read This Manual

Manual Organization

Getting Ready to Install

Getting Ready to Install

Welcome to Pervasive.SQL

About Pervasive.SQL

Competitive Advantages

Relational or Transactional Access

About the Server Engine

Purpose

Where to Install

Additional 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

Linux System 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

Configuration and Runtime

Remote Configuration with PCC

Terminal Server as Network Server

Windows Server: Installing and Configuring

Installing Pervasive.SQL V8 with No Previous Installation

Before You Begin

Platform Notes for Windows

Installing Over Existing Pervasive Products

Installation Tips

Installing the Pervasive.SQL V8 Server Components

Notes About Typical Setup

Notes About Custom Setup

Post Installation

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL V8

Where To Go From Here

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

Notes About Typical Setup

Notes About Custom Setup

Post Installation

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL V8

Where To Go From Here

Network Settings for Server Engine on Windows

Determining What Kind of Network You Have

Server Engine on Windows

Server Engine on NetWare

Server Engine on Linux

Default Engine Settings

Setting Up TCP/IP Support

Setting Up SPX Support

Avoiding Unavailable Protocols

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

Multiple Client Applications

Settings Affected by Multiple Applications

Concurrent Local and Remote Applications

NetWare Server: Installing and Configuring

Installing Pervasive.SQL V8 on NetWare

Before You Begin

Platform Notes for NetWare

Installing Over Existing Pervasive Products

Installation Tips

NetWare Security and Configuration Issues

Installing the Pervasive.SQL V8 Server Components

Post Installation

Common Questions After Installing Pervasive.SQL V8

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

Linux Server: Installing and Configuring

First-time Server Installation on Linux

Before You Begin

Samba Package Installation

Platform Notes for Linux

Installing the Pervasive.SQL Server Components using RPM

RPM Install Procedure

Installing the Pervasive.SQL Server Components using Tar

Tar Install Procedure

Installation Information

User Count License

Accessing README file information

Configuring Pervasive.SQL for Linux

Common Questions After Installing Pervasive.SQL

Upgrade Installation Procedure for Linux

Before You Begin

Samba Package Installation

Platform Notes for Linux

Upgrading the Pervasive.SQL Server Components

Upgrade Procedure for Pervasive.SQL 2000i (SP3 or SP4)

Upgrade Procedure for Versions Older than Pervasive.SQL 2000i (SP3)

Installation Information

User Count License

Accessing README file information

Configuring Pervasive.SQL for Linux

Common Questions After Upgrading Pervasive.SQL

Network Settings for Linux

Default Settings

Configuring the Linux Server

Security Configuration

Using Utilities

Supported Path Formats

Server and Client Settings

Configuring the Linux Client

Linux Clients and the Monitor Utility

Mounting NetWare Volumes

Application Configuration on Linux

Pervasive.SQL Account Management on Linux

After Installation Behavior

Configuring the User Environment

Using Utilities from Users Other than psql

Authentication to Remote Machines Using Linux Client

Using the pvnetpass Utility to Store Client Credentials

Creating a Client DSN with the Linux Client

Internationalization with the Linux Client

Btrieve

ODBC

DTI

Setting Up Web-based Data Access on Linux

ODBC Behavior

Configuring Web Server

PHP

Perl

Using Perl and ODBC with Pervasive.SQL for Linux

Code Snippet for Perl and DBI

Pervasive.SQL Clients: Installing and Configuring

Installing Pervasive.SQL Requesters

Before You Begin

Requester Notes

Migration of Configuration Settings

Installing the Pervasive.SQL V8 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

Installing Pervasive.SQL Linux Requesters

Before You Begin

Platform Notes for Linux

Hardware/Software Requirements

Linux Client in Conjunction with Server Engine

Major Features of the Linux Client

Summary of Differences Between Linux and Windows Clients

Installing the Client Using Tar

Installing the Client Using RPM

Verifying a RPM Installation

Installation Scripts

Common Questions After Installing the Linux Client

Uninstalling the Client

Uninstalling the RPM Version

Uninstalling the Tar Version

Distributing the Pervasive Client

Introduction to Client Distribution

Recommended Method of Installing Clients

Minimal Clients: Using the Pervasive.SQL Server for Requester Operations

Installing Clients Using Networked Client Support

Installing Clients Using a Systems Management Server

Where To Go From Here

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

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

Overview

Requesters Available

Supported Configurations

Win16 and DOS Workstations

Running DOS applications on Windows NT/2000

Running DOS applications on Windows 9X/ME

Verifying the DOS Configuration

DOS TCP/IP Technical Information

Configuring the Pervasive.SQL DOS Requester

After Installation

Connecting Clients to a Pervasive.SQL Database

Basics About Pervasive.SQL Servers and Clients

Servers

Clients

Connect a Client to a Pervasive.SQL Server

Use the Client to Obtain Data from the Server

Become an Expert User

User's Guide

Advanced Operations Guide

Taking Full Advantage of Upgrade

Issues After Upgrading

Converting MicroKernel Data Files

Running the GUI Rebuild Utility

Command-Line Rebuild Utilities

Deleting Temporary Files

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

Linux

NetWare

Obtaining File, Client, and Engine Version Number

Determining Client and Engine Version

Determining a File Version

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

Pervasive.SQL Resources and Contacts

Printed Documentation

Developer Center

Pervasive.SQL Knowledge Base

Subscription Based E-mail Services