PreviousGetting Started with Pervasive PSQL v9 SP2 (9.5) (Server Edition) (v9 SP2 (9.5) revision 1) Next

Understanding Client Requesters

Chapter contents

A workstation that needs to access database files is considered a client to the machine running the Pervasive PSQL Server product. A piece of software called a client requester, or requester for short, is required to access database files from a Pervasive PSQL database server. Your application's Pervasive PSQL calls go through the requester, which sends them to the Pervasive PSQL Server for processing and then returns the reply to your application.

Refer to the README file provided with the product for a list of the platforms on which Pervasive PSQL requesters are supported. The requesters use the TCP, SPX or NetBIOS protocols to communicate with the server MicroKernel, depending on the type of server you have. Ensure that your workstation has the appropriate network protocol software installed.


Note
Clients using DOS operating systems will have only transactional access to the data files. No relational access is available for this platform.

Types of Windows Requesters

Pervasive PSQL includes the following types of requesters for Windows:

You do not load or unload the Requester explicitly (except for the DOS requester); the system loads the Requester with the first application call to Pervasive PSQL and unloads the Requester when you exit your application.

DOS Requesters

This type of requester is used for applications that run under the DOS operating system. You may install only the DOS requesters if that is all you require. SeeInstalling DOS Requesters .

Trace Requesters

Trace requesters are used for troubleshooting (tracing) client problems at a low level. Generally, you will never need to perform this type of tracing. The low-level tracing is intended for use by trained support staff. Your product vendor or Pervasive Software Support will direct you on how to conduct low-level client tracing, which includes how to use the trace requesters.

Note that the tools provided with Pervasive Software solve most troubleshooting issues. For example, you would run the network connectivity tests in Pervasive System Analyzer to verify network connectivity. Also at your disposal is the Pervasive Knowledge Base (http://support.pervasive.com/eSupport), through which you may search for information about particular client issues.

WIN32 Requesters

This type of requester is used for applications that run under a Windows 32-bit operating system.

Installation

You have two choices for installing the requesters: install all three types or install only the DOS requesters.

A single installation program installs all three types of requesters to a client workstation. In addition, a set of Pervasive PSQL utilities is installed and a set of Pervasive PSQL documentation. By default, the requesters and most of the utilities are installed to C:\PVSW. You may change the location during the installation process. The documentation set, Pervasive System Analyzer (PSA), and some common files are installed to Program Files\Common Files\Pervasive Software Shared.

If you require only the DOS requesters. SeeInstalling DOS Requesters .

Configuration

The configuration of requesters is covered in Chapter 18, Configuring Network Communications for Clients.

Existing Configuration Settings

If you have an existing installation of the Pervasive PSQL client software on your computer, nearly all of the client configuration values are automatically migrated to the client configuration during the installation process. There are two exceptions that are not migrated, shown in Table 5-1.

Table 5-1 Configuration Setting Values not Migrated
Configuration Setting
Value
Client4Access4Use IDS
Off. Because most customers do not use the idshosts file, by default this setting is turned off to improve performance. If you use the idshosts file, you must turn this setting On. See Use IDS in Advanced Operations Guide.
Server Address Table (SAT), not available in Configuration but stored in Windows Registry
The SAT keeps a record of the computers where database servers have been detected or not detected, to improve connection time. This registry key is reset during the installation and will be re-populated over time as you connect to the servers in your environment.


Chapter contents
Book contents

Prev topic: Before You Begin
Next topic: Installing the Pervasive PSQL Client Components