User's Guide - Contents
Who Should Read This Manual
Manual Organization
Conventions
Understanding Pervasive.SQL
What is a Database?
What is a Database Management System?
Components of Pervasive.SQL
Key Concepts
Basic Database Structures and Terms
Unique Benefits of Pervasive.SQL
Why Pervasive.SQL?
Understanding the Product Family
Workgroup
Server
DataExchange
Crystal Reports for Pervasive.SQL
Helpful Utilities
Using Pervasive.SQL Documentation
Getting Started Guides
What's New
User's Guide
Advanced Operations Guide
SQL Engine Reference
Status Codes and Messages
Pervasive Products and Services
Online Help
File System Security
Starting and Stopping the Database Engine
Starting and Stopping the Server Engine on a Windows Server
Starting and Stopping the Workgroup Engine on Windows
Starting and Stopping the Database Engine on NetWare
Starting and Stopping the Database Engine on Linux
Granting Administrative Rights for the Database Engine
Tasks Requiring Administrative Rights
How Administrative Rights are Granted
Rights Within an Active Directory Environment
Rights Provided to non-Administrative Users
Tasks for Granting Administrative Rights
Granting Administrative Rights on a Windows Server
Granting Administrator Rights on NetWare 4.2, 5.x or 6.x
Granting Administrator Rights on Linux
Logging in as Administrator on any platform
Setting Up ODBC Database Access
Basic Concepts
What to Know if You are Recreating DSNs
Prerequisites to Setting up Database Access
Setting Up Database Access on Windows
Setting Up Database Access on a NetWare Server
Setting Up Database Access on a Linux Server
Setting Up Client Access
Accessing Data via ODBC From Other Applications
Before You Begin
Accessing Data Using Microsoft Excel
Accessing Data Using Microsoft Access
Deleting DSNs
Bound Databases and Enforced Integrity
Using the Fast User Switching Feature of Windows XP
An Overview of Pervasive Control Center
Registering or Removing a Server
Viewing Database Engines
Interpreting Engine Status Icons
Pervasive Control Center Wizards
Adding or Creating a Database
Deleting a Database
Adding a Table
Dropping a Table
Setting Database Security
Turning Security On and Off
Working with Groups and Users
Stopping and Restarting Services on Windows Servers
Viewing and Modifying Table Properties
Viewing and Modifying Data
Exporting/Importing Data
Export and Import Procedures
Checking Consistency and Referential Integrity
Listing Referential Constraints
Checking Consistency
Checking Referential Integrity
License Administrator Concepts
Graphical User Interface
Command Line Interface
User Count
Licenses for Prior Versions of Pervasive.SQL
License Administrator GUI Visual Reference
GUI Dialog
License Administrator Tasks
GUI Tasks
CLI Tasks
Table Designer Concepts
Overview
Tabbed Dialogs
Modes
Data Types
Null Values
Table Designer GUI Visual Reference
Main Window
Columns Tab
Indexes Tab
Statistics Tab
Btrieve Tab
Table Designer Tasks
General Tasks
Columns Tasks
Indexes Tasks
Statistics Tasks
Btrieve Tasks
SQL Data Manager Concepts
Overview
Restrictions
Results Tabs
Panes
SQL Reference
SQL Data Manager GUI Visual Reference
Main Window
Query Builder Diagram
Query Builder Grid for SELECT Statements
Query Builder Grid for UPDATE Statements
Query Builder Grid for INSERT Statements
Query Builder Grid for DELETE Statements
SQL Data Manager Tasks
General Tasks
Query Pane Tasks
Execution and Results Tasks
Query Builder Tasks
PSA Concepts
PSA Functional Overview
Why Use PSA?
PSA Tests in Detail
Frequently Asked Questions
Introductory Network Information
PSA GUI Visual Reference
PSA Tasks
Analyze and Archive Tasks
Restore Archive Tasks
Delete Components or Archives Tasks
View Components Tasks
Test Active Installation Tasks
Other Tasks
User Manual Exclusions for Linux
Utilities
Changes and Exclusions
Man Pages
Linux Utilities
General Troubleshooting
Error Messages from PCC
Frequently Asked Questions
Installation
Security
Documentation
User Counts
Networking
Difficulty Accessing Data
ODBC and DDFs
Upgrading from Btrieve 6.15
Upgrading and Migration
Miscellaneous
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
