Pervasive.SQL V8 SP3 (8.7)

This release delivers a number of updates and requested changes to Pervasive.SQL V8.

Note: What’s New in Pervasive.SQL V8, included in your online documentation, contains information about the new features in the V8 releases compared with the last major version of the product. You can view this documentation via the Start Menu by selecting Start | Programs | Pervasive.SQL V8 | Documentation | What’s New.

There are four different installs, one each for NetWare Servers, Windows Servers, Linux Servers, and Workgroup Engine. Each one is a complete installation program (patch installations are not available). Except for Linux, the 8.7 installations can also be used to upgrade a previous version of Pervasive.SQL.

To update your client installations, install the server first. Then install the client at each client computer by mapping a drive to the server and running setup.exe from the server directory C:\pvsw\clients (or your chosen installation location).

Installation Notes

After reading these notes, see Getting Started with Pervasive.SQL for installation procedures.

Windows

You must have Administrator rights to install this product.

Windows 95 is not supported. You must have at least Windows 98 SE to install Pervasive.SQL V8 SP3 (8.7).

If you are installing a downloaded version of Pervasive.SQL, do not place the setup files in a location that is listed in the PATH environment variables, as this can cause issues with file copying during install. Place the setup files in a location such as the Windows TEMP directory.

You cannot install Pervasive.SQL from a terminal server session. You must be on the console of the server to install.

You need Internet Explorer 4.01 SP2 or later in order to install the product due to a requirement from Windows Installer. You also need Internet Explorer to view the online documentation, and use the Network troubleshooting features of PSA. To determine if your Internet Explorer version is adequate, select Help | About Internet Explorer from a browser window and ensure that the version displayed is 4.72.3612.1713 or higher.

When installing the Client to Windows XP/2000/NT 4, you must reboot after the client install for Win 16-bit access to Btrieve.

When installing to Windows 98 SE, you may encounter an issue if the PATH environment variable is too long, as the Pervasive.SQL installation program may be unable to modify the PATH to add the Pervasive BIN directory. If you encounter issues after installing to Windows 98 SE even if install reports success, check your PATH statement and, if necessary, manually add <installed_drive>:\PVSW\BIN to your PATH.

A local security policy in Windows XP Professional “Sharing and security model for local accounts” can adversely affect network logins. Under the default policy, all network logins to local accounts are authenticated as Guest, no matter what credentials were supplied. This causes your authorization for databases using Mixed or Database mode not to match your OS credentials and can prevent data access you intended to authorize. To resolve this condition, ensure that your policy for “Sharing and security model for local accounts” is set to Classic, which authenticates users as themselves. Windows 2003 already has a default setting of Classic. Windows XP Professional has a default setting of Guest, and Windows 2000 and earlier releases do not have this security policy. To find this policy in Windows XP, browse to Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options.

NetWare

NetWare 6.0 includes Pervasive.SQL 2000i SP4. However, NetWare 6.0 configures Pervasive.SQL 2000i with very minimal resources. These settings in some cases are much lower than the recommended default settings from Pervasive. We highly recommend that you review all of the settings and adjust them based on the expected usage of your applications. In particular, you should reset the MicroKernel cache size to at least 20% of your total physical memory. If you do not change this setting then you can experience NetWare CPU hog timeout errors.

The NetWare install creates shortcuts that link to utilities on the mapped NetWare drive. Running these utilities from the NetWare shortcut can potentially causes a conflict in the pscore component depending on the Pervasive components on the local machine. If you receive such a conflict message using the License Administrator, run the utility locally and connect to the remote engine.

Running the NetWare install from a Windows 2000 (SP4) machine can produce warning messages from Windows such as “Error 1321.The Installer has insufficient privileges to modify the file.” Despite the warnings, Install should complete normally. If it does not, install your NetWare server from a machine running an earlier service pack of Windows 2000.

Running the NetWare install from a Windows 2003 machine can produce Windows security warning messages that reference files install is trying to copy. If you receive such dialogs starting with “Some files can harm your computer”, click Open and Install will complete normally.

Linux

You cannot upgrade the Linux server release from a previous V8 release. Instead, you should remove the previous version and then install V8 SP3 (8.7).

To remove the previous version of Pervasive.SQL for Linux and then install Pervasive.SQL V8 SP3 (8.7) using RPM, enter the following sequence of commands under the root user account:

rpm -e ‘Pervasive.SQL’

rpm -ivh ‘Pervasive.SQL-8.70-114.000-i486.rpm’

Note: Verify the correct package name of the 8.7 release. The build number 114.000 might be different than the final build.

The Pervasive.SQL installation package is available for all versions of Linux that meet the requirements. Refer to the Getting Started with Pervasive.SQL (Server Edition) for complete instructions on installing the product.

The HTML-based documentation for the Linux release has not been updated in the SP3 (8.7) release. Please refer to the PDF documentation and Readme file, both of which have been updated for this release.

New Features and Enhancements

This section describes the new features, enhancements, or significant changes in behavior that are offered in this release.

Pervasive.SQL V8 SP3 (8.7)

The SP3 (8.7) release contains an updated installer compared with the 8.5 and SP2 (8.6) releases. This is the only functionality change compared with the previous V8 releases. Getting Started with Pervasive.SQL documents the new installer.

Embedding Pervasive.SQL

The updated installer used in Pervasive.SQL SP3 (8.7) requires that you alter the parameters of your call-out installations compared with that of the Pervasive.SQL 8.5 and 8.6 releases.

To prepare your product installation to call the Pervasive.SQL installation, create a directory on your CD image. You may name the directory whatever you choose. The example code below uses the directory name psql. Copy the contents of the appropriate Pervasive install program directory to the directory on your install image.

The command to call-out to a Pervasive.SQL installation located in a “psql” subdirectory is:

Note: Note The -SMS options keep the setup.exe in memory until the installation is complete. This is useful because the setup.exe is simply an InstallShield loader application that terminates as soon as the installation is loaded. It is also possible to omit the -SMS options and wait for the _ISDEL module to terminate.

A silent install requires the “-s” command line option. The command to call-out to a Pervasive.SQL installation and have it run silently is:

To change the default behavior of a call-out installation, edit the ptksetup.ini configuration file. This file is located in the same directory as the other installation files, including setup.exe. It is in the form of a Windows initialization file. It contains settings that can be modified programmatically or with a text editor. You can modify these settings to specify the components that do or do not get installed when the installation program is executed.

Pervasive.SQL V8

Please see What’s New in Pervasive.SQL V8 for a description of all new features in V8 as well as documentation for the use of these features. What’s New in Pervasive.SQL V8 is included in your product installation in HTML Help (.CHM) format.


Feature	What’s New Chapter
Overview of New Features	Chapter 1, “What’s New in Pervasive.SQL V8”
New Security models and Wire Encryption	Chapter 1, “What’s New in Pervasive.SQL V8”
Utility updates to support the security features	Chapter 2, “Utility Updates to Support Security”
Changes to programming interfaces to support security	Chapter 3, “Changes to Programming Interfaces for Security”
Information on how to migrate to the new security features	Chapter 4, “Setting Up Btrieve Security”

Environments Supported

This section lists the platforms and environments on which Pervasive.SQL V8 SP3 (8.7) has been tested.

Server Engine

Windows 2003 Server/Advanced Server with Hotfix KB 823980

Windows 2000 Corporate SP4

Windows 2000 Advanced SP4

Windows 2000 Professional SP4

Windows NT 4 Server SP6a or higher

Windows NT 4 Workstation SP6a or higher

NetWare 6.5 final release

NetWare 6 SP3

NetWare 5.1 SP6e

Microsoft Terminal Server and Citrix MetaFrame 1.8/XP

Linux deployments with a Kernel version 2.4 or higher, Glibc 2.2 or higher, and the PAM libraries.

Workgroup Engine

Windows 2003 Server/Advanced Server with Hotfix KB 823980

Windows XP Professional

Windows XP Home Edition

Windows 2000 Corporate SP4

Windows 2000 Advanced SP4

Windows 2000 Professional SP4

Windows NT 4 Server SP6a or higher

Windows NT 4 Workstation SP6a or higher

Windows ME

Windows 98 SE

Tool for Running Workgroup Engine as a Windows Service

A tool that installs the Workgroup engine as a service is available on the Pervasive Component Zone web site. The tool is unsupported and available only on an as-is basis. To download the tool, visit the following URL and select the "Toolbox - WGE as an NT Service." link.

http://www.pervasive.com/ComponentZone/Component/Lookup.asp?Function=ShowComponents&ID=6&Category=Tools+%2F+Utilities

Place the tool in the BIN directory where your Pervasive files are installed.

Shut down your Workgroup engine.

Double-click PVSW.EXE to run the tool.

From the menu, choose Tools | WGE as a Service.

The next screen provides the option to install the Workgroup engine as a service. Before you do so, click Info and follow the instructions provided.

Clients

Microsoft Client for Windows, 32-bit (Windows 98 SE, ME, NT, 2000, and XP)

Microsoft DOS 6.22

Microsoft Client for NetWare

NetWare Client for Windows NT (4.9, 4.83 SP1)

NetWare Client for Windows 9X (3.40, 3.32 SP1)

Documentation Notes

This section provides information regarding the documentation included with the Pervasive.SQL V8 SP3 (8.7) product.

HTML Help and Internet Explorer

This release includes support for Microsoft HTML Help on Windows based platforms (files with .CHM extension).

HTML Help uses components of the Internet Explorer (IE) engine to display help files. A defect in the early versions of IE 5 (and some 5.5 versions) causes display irregularities with modular HTML Help systems. These display conditions may be seen in PVSWDOCS.CHM, the master help file for Pervasive.SQL V8 SP3 (8.7) that dynamically loads the other help files. Since this defect affects only the file merging mechanism, you will see no display irregularities when loading individual help files. Some specific symptoms you may encounter are:

The Contents/Index/Search/Favorites pane at the left side of the help window does not display correctly or is slow to repaint when you select a different tab such as Index or Search.

The body pane on the right side of the help window does not display correctly or at all.

The splash screen displayed when first loading the help window does not clear until you click on it.

If you encounter any of these display conditions, the solution is to upgrade to IE 5.01 or higher. You may download version 5.01 or higher from Microsoft’s web site. You can determine your version by clicking Help | About Internet Explorer from the browser window.

If your Internet Explorer version is one of the following, or a later version, then your HTML Help should function correctly.

Windows XP Professional and XP Home includes IE 6.0. Windows 2000 and Windows ME shipped with IE 5.01 so you should not see the display irregularities on those platforms, nor with older IE 4 versions.

Contact Pervasive Technical Publications

If you have additional questions or comments about documentation, please feel free to post your remarks on DevTalk at the following URL:

Known Issues

This section documents the known issues for this release. These issues are priority candidates for the next service pack release of Pervasive.SQL. The issues are organized alphabetically by component area, then numerically by tracking number within the component area.

IE Version	Description
5.00.2919.6307	Internet Explorer 5.01
5.00.3105.0106	Internet Explorer 5.01 with Service Pack 1
6.00.2800.1106	Internet Explorer 6.00 with Service Pack 1


Component Area	Tracking Number	Description
Documentation	52145	The Pervasive.SQL Programmer’s Guide manual in the 8.5 and 8.6 SDKs incorrectly states that you can specify a drive letter in the `dbfile=` parameter of a URI. The What’s New document in this release correctly states the `dbfile` use cases.
Installation	52141	If you disable the Pervasive Control Center installation using `Ptksetup.ini`, the SQL interface and GUI version of the License Administrator are also disabled. The command line version of License Administrator will still function correctly in this configuration.
Installation	52107	You cannot upgrade the Linux server release from a previous V8 release. Instead, you should remove the previous version and then install V8 SP3 (8.7). To remove the previous version of Pervasive.SQL for Linux, enter the following under the `root` user account: `rpm -e ‘Pervasive.SQL’`
PSA	52097	After upgrade of Pervasive.SQL 2000i (SP4) to Pervasive.SQL V8 SP3 (8.7), duplicate keys for Pervasive.SQL exist in the registry (keys for 8.7 and the prior version). This does not not affect using Pervasive.SQL V8 SP3 (8.7).
	52161	Upgrading to Pervasive.SQL V8 SP3 (8.7) and then archiving 8.7 leaves a few files in PVSW\bin from the previous release. This applies only to upgrading from versions of Pervasive.SQL in the “V8” family (V8, V8.5, or V8.6). This does not not affect using Pervasive.SQL V8 SP3 (8.7).
	52160	After upgrade, Start menu contains two entries for Pervasive.SQL. This occurs if the previous version of Pervasive.SQL V8 (V8, V8.5, or V8.6) was installed using the Custom installation choice. This does not not affect using Pervasive.SQL V8 SP3 (8.7).

Technical Support

Pervasive Knowledge Base at http://support.pervasive.com/eSupport

To open a support incident or check the status of an existing incident, see http://www.pervasive.com/support/support_email.asp.

If you require something other than what Web-based support options provide, contact Pervasive Support by phone:

800-287-4383 option 3 (the Americas)

+800.1212.3434 (Austria, Belgium, Denmark, France, Germany, Italy, Luxembourg, The Netherlands, Spain, Sweden, Switzerland, and the U.K)

+32.70.23.37.61 (Any other European, Middle Eastern, African or Asian countries, excluding Japan)

Visit the DevTalk forum at http://www.pervasive.com/devtalk.

Visit http://www.pervasive.com/company/contact/index.asp for other contact information.

Visit the updates page at http://www.pervasive.com/support/updates

Useful Links

For a comprehensive list and details of Pervasive Products, see

http://www.pervasive.com/products

Discuss all your Pervasive development issues at:

http://www.pervasive.com/devtalk

Review information about application development at:

http://www.pervasive.com/developerzone

For Technical Papers, see:

http://www.pervasive.com/support/techpapers.asp

For Product Manual downloads, see:

http://www.pervasive.com/support/technical/online_manuals.asp

For viewing Product Manuals online, see:

http://www.pervasive.com/library

For information on our Support programs, see

http://www.pervasive.com/support/support_programs.asp

For information on updates and Service Packs, see:

http://www.pervasive.com/support/updates

Disclaimer

This application uses the free iODBC Driver Manager as written by Ke Jin <kejin@inprise.com>, enhanced with local modifications from Pervasive for the NetWare platform. Pervasive will donate their code changes to the current maintainer of the iODBC Driver Manager project, in accordance with the LGPL license agreement of this project.

For further information on this project, contact its current maintainer: Patrick van Kleef <iodbc@openlinksw.com>.

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND 
DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY 
ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH 
THE TERMS AND CONDITIONS OF THE ACCOMPANYING 
LICENSE AGREEMENT.  
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES 
WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING 
THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; 
PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND 
YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE 
SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, 
INCLUDING, FOR EXAMPLE, WITH RESPECT TO 
MERCHANTABILITY, TITLE, OR FITNESS FOR ANY 
PARTICULAR PURPOSE OR ARISING FROM COURSE OF 
DEALING OR USAGE OF TRADE, AMONG OTHERS.  
Copyright © 2005 Pervasive Software Inc.  
All Rights Reserved.

Pervasive.SQL V8 SP3 (8.7) - README
Service Pack 3 Release - August 2005

Contents

General Information

Installation Notes

Windows

NetWare

Linux

New Features and Enhancements

Embedding Pervasive.SQL

Pervasive.SQL V8

Environments Supported

Server Engine

Workgroup Engine

Tool for Running Workgroup Engine as a Windows Service

Clients

Documentation Notes

HTML Help and Internet Explorer

Contact Pervasive Technical Publications

Known Issues

Technical Support

Useful Links

Disclaimer

Pervasive.SQL V8 SP3 (8.7) - README Service Pack 3 Release - August 2005

Contents

General Information

Installation Notes

Windows

NetWare

Linux

New Features and Enhancements