About This Manual
Welcome to PSQL
About PSQL
Competitive Advantages
Transactional (Direct Data) Access or Relational Access
The PSQL MicroKernel Engine
Benefits
Features
The PSQL Relational Engine
Benefits
Features
About the PSQL Database Editions
PSQL Server and Vx Server
PSQL Workgroup
Server and Workgroup Comparison
PSQL SDK
Development Environment
Preparing to Install PSQL
Installation Requirements
Access Rights
Required Windows Updates
No Other PSQL Database Engine Installed
Upgrading to a New Version of PSQL
Operating Requirements
Installation Options
Complete Installation
Custom Installation
PSQL Products
Server and Vx Server
Workgroup
Client
PSQL Optional Features
PSQL Access Methods
ActiveX Interface Controls
ADO.NET Provider
Btrieve DOS
DTO
JCL
JDBC Driver
OLE DB
PDAC
Utilities
Cobol Schema Executor
Data Dictionary File Builder
PSQL Control Center
PSQL System Analyzer
Documentation
Java Runtime Environment (JRE)
Installation Review
Quick Checklist
Common Preinstallation Questions
Where do I install the PSQL Server or Vx Server?
What about the Server’s client software?
Where do I install the PSQL Workgroup?
What about Workgroup clients?
How do I install PSQL in a Microsoft Cluster Services environment?
How do I install PSQL in a Microsoft Terminal Services or XenApp environment?
How do I install my PSQL database engine in a Microsoft Active Directory environment?
Where do I install my PSQL Clients accessing Web applications?
Does the PSQL Client version have to match the PSQL Server version?
Does it matter where I download the PSQL v13 installer?
My system runs 24/7. What is the best time for installing or upgrading to PSQL v13?
How can I restrict users running in Terminal Services from changing PSQL configuration settings, creating DSNs, and using the Monitor utility?
Are there special settings not listed here that I need to make for my configuration?
Upgrading Your PSQL Installation for Windows
Upgrading to PSQL v13 from a Previous Version
Considerations When Upgrading to PSQL v13
Common Questions After Upgrading to PSQL
How to Handle Data Source Names (DSNs)
How Do I Convert Files from Previous PSQL Products?
What User License Was Installed with PSQL?
Installing PSQL Server and Vx Server for Windows
Before You Install
Platform Notes
Installing the Engine on Terminal Server
Running the Engine on Terminal Server
Installation Tips
Failover Clusters
Installing a PSQL Server on Windows
Where to Go from Here
Installing PSQL Clients for Windows
Before You Install the Windows Client
Installing PSQL Client for Windows
Installing the BTRBOX Requester
Win32 DOS Box Support
Understanding Client Requesters
Types of Windows Requesters
DOS Requesters
Trace Requesters
Where to Go from Here
Installing PSQL Workgroup for Windows
Before You Install PSQL Workgroup
Installation Tips
Installing PSQL Workgroup for Windows
Authorization of Workgroup Key on Windows with UAC
Where to Go from Here
Installing the Client Reporting Engine for Windows
Before You Install the Windows Client Reporting Engine
Installing PSQL Client Reporting Engine for Windows
Where to Go from Here
After Installing PSQL for Windows
Common Questions After Installing PSQL
What happened to PVSW\BIN on Windows platforms?
What happened to PVSW\BIN on Windows platforms?
Where are the PSQL files installed?
What is an Application Data file?
What is a Program File?
What is the difference between 32- and 64-bit Program Files?
What if I need a 64-bit Client in a Workgroup environment?
What happened to the Client install image?
Do I need to install the Client with a Workgroup engine?
How Do I Read the Online Documentation?
How Do I Verify or Update My User License?
What User License Was Installed with PSQL?
Where to Go from Here
Uninstalling PSQL
Setting Up Network Communications for Servers
Determining What Kind of Network You Have
Engine Network Communication Settings
Setting Up TCP/IP Support
Setting Up SPX Support
Setting Up NetBIOS Support (Workgroup only)
Avoiding Unavailable Protocols
Setting Up Network Communications for Clients
Client Network Communication Settings
Network Path Formats Supported by PSQL Requesters
Universal Naming Convention (UNC) Path Formats
Drive-based Formats
Linux, macOS, and Raspbian Path Formats
Share Names
Absolute Paths
Native SMB File Sharing on macOS
IPv6
IPv6 Addresses
Recommendations for Numeric IPv6 Addresses
Unicast Addresses
IPv6 Address Modifiers
Address Presentations
IPv6-literal.net Names
Bracketed IPv6 Addresses
IPv6 and the MicroKernel Engine
IPv6 and the Relational Engine
IPv6 with Linux, macOS, and Raspbian
Suggested Distributions
Limitations and Conditions
Best Practices
Frequently Asked Questions About IPv6
Using TCP/IP to Connect to a Windows Server
Configuring a Client for the Server IP Address
Using DNS to Configure the Server IP Address
Using the Hosts File to Configure the Server IP Address
Preventing the Windows Dial-Up Network Dialog Box from Displaying When Using a PSQL Application with TCP/IP
Using SPX to Connect to a Windows Server
Configuring PSQL to use SPX
Changing the configuration of PSQL to use SPX with a Windows platform
Changing Windows Configuration to Make SPX Run with PSQL
Changing the Default Communication Ports
Services File
Windows FireWalls
Profile Changes After Installation
Notes About Policies
Using TCP/IP to Connect a Windows Client to Linux, macOS, or Raspbian Servers
Configuring a Client for the Server IP Address
Using DNS to Configure the Server IP Address
Using the Hosts File to Configure the Server IP Address
Preventing the Windows Dial-Up Network Dialog Box from Opening
Data Encoding
Using the DOS Requester
Supported Configurations
DOS Box Support on Windows
Running DOS Applications on Windows 32-bit Platforms
Using DOS Box Support
Setting Up the Workgroup Engine
Overview
Installation Requirements
Operating System Security
When to Use Workgroup
Small Client-Server Configuration
Peer-to-Peer Configuration
Gateway Configuration
What is a Gateway Engine?
Setting Up a Small Client-Server Configuration
Setting Up a Peer-to-Peer Configuration
Setting Up a Gateway Configuration
Floating or Fixed Gateway
Use the Gateway Locator Utility
Use the DOS Command Line
Use the Windows Explorer
Working with the Gateway Locator Utility
Running the Workgroup Engine as a Service
Configuration
Stopping the Service
Setting Up a Client Reporting Engine
Server Properties for Client Reporting Engine
Client Properties for Client Reporting Engine
Database Properties for Client Reporting Engine
Client Reporting Engine Limitations
Using the Client Reporting Engine as a Btrieve Cache Engine
Using the Client Reporting Engine with the DTI API
Application Configuration Scenarios
Terminal Services
Disabling Administrative Functions
Terminal Server as Network Server
Workgroup Engine Running as a Service
Active Directory Service
Server and Client Support
Server and Client Support
Directory and File Permissions
Microsoft Terminal Services Support
PSQL Administrative Authority
Active Directory Tasks
Multiple Client Applications
Settings Affected by Multiple Applications
Compatibility | Create File Version
Data Integrity | Transaction Durability
Concurrent Local and Remote Applications
Using the Server and Workgroup Engines Concurrently
Accessing Data on Other Computers
Installing PSQL Server, Vx Server, and Client for Linux-based Systems
Before You Install PSQL on Linux, macOS, or Raspbian
Full and Client Installations
Utilities on Raspbian
Connecting from a Linux-Based Client to a Windows Server or Vx Server
Installing PSQL Using RPM
Installing PSQL Server or Vx Server for Linux - RPM
First-Time Installation
Upgrade Installation
Installing PSQL Client for Linux - RPM
First-Time Installation
Upgrade Installation
Installing PSQL Using TAR
Installing PSQL Server or Vx Server for Linux and Raspbian - TAR
First-Time Server Installation on Linux and Raspbian
Upgrade Server Installation on Linux and Raspbian
Installing PSQL Server or Vx Server for macOS - TAR
First-Time Server Installation on macOS
Upgrade Server Installation on macOS
Installing PSQL Client for Linux and Raspbian - TAR
First-Time Client Installation on Linux and Raspbian
Upgrade Client Installation on Linux and Raspbian
Installing PSQL Client for macOS - TAR
First-Time Client Installation on macOS
Upgrade Client Installation on macOS
Installing PSQL Using DMG on macOS
Installing PSQL Server or Vx Server for macOS - DMG
First-Time Server Installation on macOS
Upgrade Server Installation on macOS
Installing PSQL Client for macOS - DMG
First-Time Client Installation on macOS
Upgrade Client Installation on macOS
After Installing PSQL on Linux, macOS, or Raspbian
Verifying Installed Products with RPM
Verifying Database Engine is Running
Server Configuration
Client Configuration
Linux, macOS, and Raspbian Clients and the Monitor Utility
Licensing
Common Questions After Installation
Where Do Files Reside After Installing PSQL on Linux, macOS, and Raspbian?
How Do I Access the Documentation?
Man Pages
Documentation Library
Release Notes
What If I Get Errors Trying to Start the Utilities?
Uninstalling PSQL on Linux, macOS, or Raspbian
Removing a PSQL RPM Package
Removing a PSQL TAR Package
Removing a PSQL DMG
Using PSQL on Linux, macOS, and Raspbian
Finding What You Need
Accessing the User Documentation
Man Pages
PSQL Account Management on Linux, macOS, and Raspbian
After Installation Behavior
The User Environment
Using Utilities from Users Other Than psql
Examples of a Modified Profile
Linux and Raspbian
macOS
Configuration
Samba Configuration File
Authentication
Supported Path Formats for Samba
Windows Client
Linux, macOS, or Raspbian Client
Client Information
Authentication to Remote Machines
Creating a Client DSN
Setting Up Web-based Data Access
ODBC Behavior
Configuring Web Server
PHP
PSQL PHP Requirements
PHP Connection Snippet
PHP Sample
Additional PHP Sample
Perl
PSQL Perl Requirements
Perl Connection Snippet
Perl Sample
Using Perl and ODBC with PSQL
Code Snippet for Perl and DBI
Installing PSQL on Windows Nano Server or Windows IoT Core
Before You Install PSQL on Windows Nano Server or IoT Core
Installing PSQL Using PowerShell
Choosing a .Zip Archive for Installing PSQL
First-Time Installation on Windows Nano Server or IoT Core
Windows Firewall Configuration
Upgrade Installation on Windows Nano Server or IoT Core
After Installing PSQL on Windows Nano Server or IoT Core
Server Configuration
Client Configuration
Licensing
Code Page Configuration on Windows IoT Core Systems
Common Questions After Installation
How Can I Verify That the Database Engine is Running?
What Utilities Are Installed?
Where Do Files Reside After Installing PSQL?
How Do I Access the Documentation?
Where Are the Release Notes?
Uninstalling PSQL on Windows Nano Server or IoT Core
Troubleshooting After Installation
Troubleshooting Tools
Troubleshooting Strategies
Checklist for Problems
Troubleshoot the Problem
Logged Messages
Configuration for Special Installation Situations
Diagnosing Problems with PSQL System Analyzer (PSA)
Verifying Database Engine is Running
PSQL Server on Windows
PSQL Workgroup on Windows
PSQL Server on Linux-based Systems
Obtaining File, Client, and Engine Version Number
Determining Client and Engine Version
Using Function Executor
Using the butil Utility
Determining a File Version
Using the PSQL Control Center
Using Btrieve Maintenance
Using Function Executor
Using the butil Utility
Engine and Client Version Conflicts
State of Key Is “Failed Validation” or “Disabled”
Troubleshooting Common PSQL Issues
I receive Status 7224 or my license is no longer listed in the License Administrator utility.
I fail to see the effects of my configuration changes.
Why do I receive Status 7012 when trying to create a new database with the Workgroup Engine using PCC on Windows?
Why do I (now) receive Status 95, after running my application successfully?
Installing a PSQL application has rendered another application unusable.
How do I verify that my DOS components are functioning properly?
Why can’t I restart my application after an improper program exit?
Why isn’t my application using the Workgroup engine?
How Do I Access the PSQL Online Manuals?
I received an error message during installation that begins: “Setup did not update the PATH statement in autoexec.bat because the new path would be too long for Windows.”
Issues After Uninstalling PSQL on Windows
How to Get Additional Help
About This Manual
Troubleshooting After Installation
gateway:Setting Up a Gateway Configuration%A gateway is a Workgroup Engine that can be used when data is stored on a file server without a database engine.