Pervasive PSQL Optional Features

Pervasive PSQL Optional Features

During a Custom install, Pervasive PSQL features may be excluded with the Pervasive PSQL product you are installing. The features listed here are optional, so if all the features in this section are excluded from the install, the Pervasive PSQL product is still installed by default.

The following lists the optional features available with each Pervasive PSQL installation, unless noted otherwise.

Xtreme I/O (Server 32-bit Only)

Xtreme I/O (XIO) is a database accelerator included with Pervasive PSQL. XIO increases database performance by accelerating disk access time for Pervasive PSQL data files. XIO can be installed only on Windows Server 32-bit platforms meeting the minimum system requirements for XIO. See System Requirements in Advanced Operations Guide.

Pervasive Access Methods

Pervasive Access Methods include the Pervasive PSQL Software Developer’s Kit (SDK) and the DOS Requester.

ActiveX Interface Controls

A set of nine custom controls that enable development environments that support ActiveX to easily access Btrieve data. The interface includes a data source control and eight bound data controls.

ADO.NET Provider

ADO.NET is a .NET managed data provider, built with 100% managed code. The data provider is a native wire protocol provider, which means that the data provider will not have to call out to unmanaged code-code outside of the .NET Framework-in the form of a database client.

The DOS VxD (Virtual eXtended Driver) (DOS client requester) is the Btrieve requester used for running DOS based applications via a Windows Command window. (Transactional access only)

The Pervasive Distributed Tuning Objects (DTO) are used from visual development environments.

The Java Class Library (JCL) is used for direct transactional access to data files via Java.

The JDBC driver is used for relational access to data files using the Java programming language.

The OLE DB access method includes runtime binaries used for transactional and relational access to data files.

The Pervasive Direct Access Components (PDAC) includes a set of Visual Component Library (VCL) components that allow direct transactional and relational access to Pervasive Database Engines from within the Borland Delphi and C++ Builder Environments.

Note: Design time component and sample downloads will be available for each access method on the Pervasive Software web site.

The minimum set of utilities used to manage, configure and maintain the various components of the Pervasive PSQL database engines. The utilities included in this base set are installed as a set for all Pervasive PSQL products and may not be individually excluded from installation.

•

•

Function Executor

•

Btrieve Maintenance

•

•

Query Plan Viewer

•

License Administrator

•

Gateway Locator (Workgroup Engine only)

Cobol Schema Executor

The Pervasive Cobol Schema Executor utility is used for providing SQL access to COBOL based applications.

Data Dictionary File Builder

Pervasive PSQL Data Dictionary File Builder is used for creating and modifying Data Dictionary Files (DDFs).

Pervasive Control Center

The Pervasive Control Center is used for creating and manipulating database objects and accessing database tables via SQL.

Pervasive System Analyzer

The Pervasive System Analyzer utility is used for testing and troubleshooting network connectivity, viewing loaded modules and performing a component search.

The Pervasive PSQL Engine and SDK user documentation is integrated into Pervasive PSQL Control Center (PCC). The documentation library is accessed through the PCC interface on the Welcome view, in the Help menu, by pressing F1 (Windows) or Shift F1 (Linux). Printed copies of the Pervasive PSQL Engine documentation may be purchased from Pervasive Software. The Pervasive PSQL SDK documentation titles are only available online.

Note: If you choose to not install the documentation, context sensitive (F1) help will be unavailable from all of the Pervasive PSQL utility graphical user interfaces.

Java Runtime Environment (JRE)

The components of the JRE needed by the following features are installed as part of Pervasive PSQL:

•

•

•

•

The PSQL features use the local version of the JRE installed by Pervasive PSQL.

Note: The installation of a local version of the JRE is for use only by the Pervasive PSQL features listed above. The local version of the JRE does not affect the requirements for developing Java applications using the Pervasive PSQL access methods Java Class Libraries (JCL) or JDBC. Those requirements, such as components obtained from java.sun.com, are discussed in the Pervasive PSQL software development kit (SDK) documentation. See Java Class Library Guide and JDBC Driver Guide.