Getting Started with Pervasive.SQL (Server edition) - Contents

---

About This Manual

Who Should Read This Manual

Manual Organization

Getting Ready to Install

Windows

NetWare

Linux

Client Requesters

After Installation

Conventions

Getting Ready to Install

Welcome to Pervasive.SQL

A Basic Introduction to Pervasive.SQL V8

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

Preparation Needed for Pervasive.SQL V8 Server Installation

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

How to Use Pervasive.SQL with 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

Windows Server: Installing and Configuring

Installing Pervasive.SQL with No Previous Installation

Instructions for First-time Windows Server Installation

Before You Begin

Platform Notes for Windows

Installation Tips

Installing Pervasive.SQL Server

Complete Setup

Custom Setup

Post Installation

What to do Next

Custom Installation Path

Excluding Features

Common Questions After Installing Pervasive.SQL

Where To Go From Here

Uninstalling Pervasive.SQL Server

Upgrading Your Pervasive.SQL Installation

Instructions for Upgrading an Existing 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 Server from Earlier Pervasive.SQL Versions or Btrieve 6.x

Notes About Complete Setup

Notes About Custom Setup

Post Installation

What to do Next

Custom Installation Path

Common Questions After Installing Pervasive.SQL

Where To Go From Here

Network Settings for Server Engine on Windows

How to Configure Network Settings for a Windows-based Pervasive.SQL Server

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

Common Scenarios for Setting up Your Server

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

Instructions for NetWare Server Installation or Patching

Before You Begin

Platform Notes for NetWare

Installing Over Existing Pervasive Products

Installation Tips

NetWare Security and Configuration Issues

Installing the Pervasive.SQL Server Components

Complete Setup

Custom Setup

Custom Installation Path

Excluding Features

Common Questions After Installing Pervasive.SQL

Network Settings for Server Engine on NetWare

How to Configure Network Settings for a NetWare-based Pervasive.SQL Server

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

Issues for Configuring Applications on the NetWare Platform

Local Applications on NetWare Servers

NSS Volume Support

Linux Server: Installing and Configuring

First-time Server Installation on Linux

Instructions for First-time Installation of Pervasive.SQL V8 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

How to Upgrade an Existing Installation of Pervasive.SQL 2000 on Linux platforms

Before You Begin

Samba Package Installation

Platform Notes for Linux

Upgrading the Pervasive.SQL Server Components

Upgrade Procedure for Pervasive.SQL 2000i (SP 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

How to Configure the Network Settings for your Pervasive.SQL Server on 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

Issues for Configuring the Linux Platform after Installation

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

How to Install Pervasive.SQL Client Requester Software for Connecting to Servers

Before You Begin

Understanding Client Requesters

Types of Requesters

Installation

Configuration

Installing the Pervasive.SQL Client Components

Complete Setup

Custom Setup

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

Instructions for Installing and Uninstalling the Client for Linux

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

How to Install Clients for your Pervasive.SQL Server

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

How to Configure your Pervasive.SQL Clients

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

Win1 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

How to Connect Clients to the Sample Database on a Pervasive.SQL Server Machine

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

Rebuilding MicroKernel Data Files to the Latest Version Gains Functionality

Issues After Upgrading

Converting MicroKernel Data Files

Running the GUI Rebuild Utility

Getting Help

Converting a Data File

Command-Line Rebuild Utilities

Deleting Temporary Files

Troubleshooting After Installation

How to Proceed When You Encounter Errors During 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

A Guide to Pervasive.SQL Customer Information 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

Pervasive Software, Inc. http://www.pervasive.com Voice: (512) 231-6000 Fax: (512) 231-6597 Pervasive Sales Support Documentation Feedback Contact Technical Support Pervasive DevTalk Forums Pervasive DeveloperZone