# Pervasive PSQL v10 SP3 - README
General Release - November 2009

## Contents

Welcome to the General Release of Pervasive PSQL v10 SP3. This readme file contains the following topics:

- New Features and Enhancements
- Installing Pervasive PSQL
- Known Issues
- Usage Notes
- Technical Support
- Windows 2008 Server Certification
- Disclaimer

## New Features and Enhancements

Refer to What’s New in Pervasive PSQL for complete details about the new features and enhancements. This section provides only the highlights:

- Support for Windows 7
- Product Activation
- JRE Components Included in Installation
- Trial License for 30 Days
- XIO Changes

### Support for Windows 7

Pervasive PSQL v10 SP3 is compatible with Windows 7. It has been tested on the following versions:

Operating System | Pervasive PSQL Products Supported
--- | ---
Windows 7 Ultimate (32-bit and 64-bit) | Server, Workgroup, Client
Windows 7 Enterprise (32-bit and 64-bit) | Server, Workgroup, Client
Windows 7 Professional (32-bit and 64-bit) | Server, Workgroup, Client
Windows 7 Home (32-bit) | Workgroup, Client

For a full list of supported environments, including all editions of Windows 7 supported, refer to the System Requirements page on the Pervasive Software web site.

### Product Activation

Product activation is a license validation process that verifies the copy of Pervasive PSQL is legitimate, correctly licensed, and on the appropriate hardware and software platform. Beginning with Pervasive PSQL v10, Pervasive began using product activation for PSQL trials and e-commerce versions obtained from the Pervasive Web site.

With Pervasive PSQL v10 SP3, product activation is also included in Pervasive PSQL software purchased from resellers and distributors. (That is, Pervasive PSQL as a boxed product.)

Currently, product activation is not included in Pervasive PSQL products available from original equipment manufacturers (OEMs).

Note that, with Pervasive PSQL v10 SP3, a product can be activated within a virtual machine. The same licensing requirements apply whether using Pervasive PSQL directly on a physical machine or running it within a virtual machine. Since only one copy of the software may be associated with each license key, each virtual image (including clones and copies) requires its own key.

You can activate the product at installation time through the interactive graphical user interface (GUI), or after installation using the licensing utilities (see Note below). The installation GUI guides you though the activation process and is self-explanatory. If you choose to activate Pervasive PSQL after installation, see “License Administrator” chapter in Pervasive PSQL User’s Guide.

#### Notes

- On Windows 2000 only, you must active the product after installation by using a licensing utility. Because of limitations in the operating system, the Pervasive PSQL installation cannot provide product activation.
- If you are upgrading from Pervasive PSQL v10 or later, the interactive installation automatically uses the permanent license from the Pervasive PSQL v10 or later release. No activation step is required by you. See Upgrading from Pervasive PSQL v10 or Later.
- See the Usage Note Activation of Workgroup Key on Vista and Windows 7 for a discussion of activating a key for Pervasive PSQL Workgroup.

### JRE Components Included in Installation

The JRE is no longer invoked as a separate installation by the Pervasive PSQL installation. The components of the JRE needed by the following features are now installed as part of Pervasive PSQL unless an appropriate version of the JRE (1.6.0_01 or higher) is already installed on the system:

- PCC and Documentation
- DDF Builder
- Core utilities

On Windows 32-bit operating systems, the Pervasive PSQL installation does not install the JRE components if an appropriate version of the JRE (1.6.0_01 or higher) is already present. On Windows 64-bit operating systems and on Linux, the JRE components are always installed.

### Trial License for 30 Days

The trial license key that is included with the Pervasive PSQL Server and Workgroup installations has a trial period of 30 days. You have up to 30 days to activate the Pervasive PSQL product with a non-trial key. If not activated within 30 days, the database engine no longer runs.

The trial license for Pervasive PSQL Server 32-bit and 64-bit on both Window and Linux provides a user count of 20. The trial license for Pervasive PSQL Workgroup provides a user count of 5.

### XIO Changes

The memory requirements for the optional database accelerator Xtreme I/O (XIO) have increased to 4 GB.

In addition, XIO is now supported only on server class operating systems. The following Windows 32-bit operating systems are supported (XIO is not supported on 64-bit platforms):

- Windows 2008 Server, RTM (6.0.6001), or Service Pack 2 (SP2, 6.0.6002), or greater
- Windows 2003 Server (SP3)
- Windows 2000 Server (SP4)

## Installing Pervasive PSQL

This section discusses topics pertaining to the installation of the product on Windows and Linux.

Note Before reading this section, review the content on Product Activation in the previous section.

### Windows

Run the full (setup*.exe) Pervasive PSQL v10 SP3 installation for the following:

- Upgrading from Versions Prior to Pervasive PSQL v10
- Upgrading from Pervasive PSQL v10 or Later
- Installing Pervasive PSQL for the First Time

#### Upgrading from Versions Prior to Pervasive PSQL v10

Product activation is required for Pervasive PSQL Server or Workgroup. You may install Server or Workgroup with only the trial license if you want, but product activation is required before expiration of the trial license period.

If you have Backup Agent 1.2, DataExchange 2.9 or AuditMaster 6.4 installed, they will continue to work after you upgrade to Pervasive PSQL v10 SP3.

#### Silent Installation

To install Pervasive PSQL v10 SP3 silently follow these steps:

1. Run the PSQL installation using the silent command line option. To activate PSQL during the installation, update the installation configuration file ptksetup.ini to specify the activation key (PVSW_PSQL_LICENSE_KEY=<key>). To activate PSQL from the command line after the installation has completed, see step 2.

    Setup<InstallType>_x<Platform>.exe /s /v"/qn /leom
    \¨%temp%\v10sp3_UpgradeLogFileName.log\""

This example creates an installation log file in the Windows temp directory.

2. [Optional] To activate PSQL after the installation has completed, use the License Administrator Command Line Interface utility:

    "<PSQL_install_path>\bin\clilcadm.exe" -a <key>

#### Upgrading from Pervasive PSQL v10 or Later

The interactive installation automatically uses the permanent license from the Pervasive PSQL v10 or later release. No activation step is required by you. The Pervasive PSQL v10 SP3 installation wizard does not display the activation dialog.

If you have Backup Agent 1.2, DataExchange 2.9 or AuditMaster 6.4 installed, they will continue to work after you upgrade to Pervasive PSQL v10 SP3.

#### Silent Installation

To install Pervasive PSQL v10 SP3 silently follow these steps:

1. [Optional] If Pervasive PSQL v10 or Pervasive PSQL v10.10 is installed, download the latest available update for the installed release from the Pervasive download web page and apply the update before upgrading to Pervasive PSQL v10 SP3. Applying the update ensures that the uninstall of the previous version retains any user settings.

2. Run the PSQL installation using the silent command line option.

    Setup<InstallType>_x<Platform>.exe /s /v"/qn /leom
    \¨%temp%\v10sp3_UpgradeLogFileName.log\""

This example creates an installation log file in the Windows temp directory.

#### Installing Pervasive PSQL for the First Time

Product activation is required for Pervasive PSQL Server or Workgroup on systems with no previous version of Pervasive PSQL installed. You may install Server or Workgroup with only the trial license if you want, but product activation is required before expiration of the trial license period.

If you have not installed the product and want to read about installation, see the portable document format (PDF) book Getting Started with Pervasive PSQL.

The following topics apply when you install to Windows.

Subject | Discussion
--- | ---
Windows firewall and client/server applications | The Pervasive PSQL Server and Workgroup installation adds files to the firewall access list to enable client/server functionality. If the operating system security prompts you during installation of Pervasive PSQL to unblock or allow communication with a Pervasive PSQL component, select OK (yes). If you encounter problems with your client/server applications not working correctly after installation, check the firewall access list or the ports. You may need to adjust some of the security settings to enable client/server applications. You can add files to the access list or open ports. You do not need to do both. If you want to add Pervasive PSQL components to the firewall access list, add the following: For Pervasive PSQL 32-bit Server, ntdbsmgr.exe. For Pervasive PSQL Workgroup, w3dbsmgr.exe. For Pervasive PSQL 64-bit Server, ntdbsmgr.exe and ntdbsmgr64.exe. If you want to open ports, Pervasive PSQL communicates via the following ones: 3351 for the transactional interface, 1583 for the relational interface, and 139 for named pipes. Note that opening a port opens it for all access, not just for Pervasive PSQL. Refer to the operating system documentation on security, firewall settings, and ports.
Default location of installed components | The default location of installed components places files into different root locations depending on product and platform. See “Default Location of Installed Components” in What’s New in Pervasive PSQL for details.
Characters to avoid in installation path | The pound (#) and percent (%) characters should not be used in installation paths for the Pervasive PSQL products if you intend to use Pervasive PSQL Control Center or DDF Builder. Those two utilities will not run if the installation path contains a pound character or a percent character.
FireFox browser | Note that the Registration page invoked at the end of a Pervasive PSQL installation, register.htm, does not display in the FireFox browser. The Workaround solution is to open the registration page manually in FireFox. The file is located in installation_location\Pervasive Software\PSQL\Docs.
Upgrading to run Workgroup Engine as a Service | If you install Workgroup Engine or Client Cache Engine as an application, then later decide you want to run it as a service, uninstall the engine, then reinstall it as a service. Any previous Beta versions of Pervasive PSQL v10 must be uninstalled prior to installing this General version.
Authorization and security | You must have Administrator rights to install Pervasive PSQL.
Depending on the particular account, a local security policy, “Sharing and security model for local accounts,” in Vista and Windows 2008 platforms can adversely affect network logins. Ensure that your policy for “Sharing and security model for local accounts” is set to Classic, which authenticates users as themselves.
PATH location | If you are installing a downloaded version of Pervasive PSQL, do not place the setup files in a location that is listed in the PATH environment variables. This can cause issues with file copying during install. Place the setup files in a location such as the Windows TEMP directory.
Windows Installer Version | Some versions of Windows supported with Pervasive PSQL v10 SP3 may not have the minimum required version of the Windows Installer installed. Pervasive PSQL v10 SP3 requires Windows Installer v3.1 be installed in order to run the PSQL installation. To see what version of the Windows Installer is present on your system, type MSIExec /? at a command prompt. If your version of Windows does not have Windows Installer v3.1 installed, either upgrade your version of Windows Installer or install Pervasive PSQL v10 SP3 using the Setup executable file, which will automatically upgrade the installed version of Windows Installer to v3.1 before running the Pervasive PSQL v10 SP3 installation.
Windows 2008 Server Core installation | The optional installation features are disabled by default when installing Pervasive PSQL Server on Windows 2008 Server Core.
Installing XIO on Virtual Machines | Pervasive Software does not support running XIO on a virtual machine image.

#### Silent Installation

To install Pervasive PSQL v10 SP3 silently, follow these steps:

1. Run the PSQL installation using the silent command line option. To activate PSQL during the installation, update the installation configuration file ptksetup.ini to specify the activation key (PVSW_PSQL_LICENSE_KEY=<key>). To activate PSQL from the command line after the installation has completed, see step 2.

    Setup<InstallType>_x<Platform>.exe /s /v"/qn /leom
    \¨%temp%\v10sp3_UpgradeLogFileName.log\""

This example creates an installation log file in the Windows temp directory.

2. [Optional] To activate PSQL after the installation has completed, use the License Administrator Command Line Interface utility:

    "<PSQL_install_path>\bin\clilcadm.exe" -a <key>

### Linux

Linux installations are one of the following types:

- Upgrading from Prior Versions of Pervasive PSQL
- Installing Pervasive PSQL for the First Time

#### Upgrading from Prior Versions of Pervasive PSQL

If you are upgrading from a previous version of Pervasive PSQL on Linux, you must uninstall and then install Pervasive PSQL v10 SP3. For information on upgrading to Pervasive PSQL v10 SP3 on Linux, see “Upgrade Installation” in Getting Started with Pervasive PSQL.

##### Product Activation

If you upgrade from a version prior to Pervasive PSQL v10, Pervasive PSQL Server must be activated after you upgrade. A Pervasive PSQL v10 key is required. You perform product activation after installation by using a licensing utility. See “License Administrator” chapter in Pervasive PSQL User’s Guide.

If you upgrade from Pervasive PSQL v10 or later, the key provided with your original product is still valid. After installation, use a licensing utility to activate the product with your original key. See “License Administrator” chapter in Pervasive PSQL User’s Guide.

#### Installing Pervasive PSQL for the First Time

Pervasive PSQL v10 SP3 supports Linux distributions running Kernel 2.6.0 or higher. For information on installing Pervasive PSQL v10 SP3 on Linux, see “Installing Pervasive PSQL for Linux” in Getting Started with Pervasive PSQL.

Product activation is required for Pervasive PSQL Server on systems with no previous version of Pervasive PSQL installed. By default, the product is installed with the trial license. Product activation is required before expiration of the trial license period. You perform product activation after installation by using a licensing utility. See “License Administrator” chapter in Pervasive PSQL User’s Guide.

#### Installation Packages

Full installation packages are available for Linux. A full installation includes the necessary engine and client files, all available utilities and the complete user documentation.

The following table outlines the installation packages available.

Pervasive PSQL Product | Installation Type | Contains | Example Name of Package1
--- | --- | --- | ---
Server 64-bit | Full | Engine and client files, utilities, and documentation | Pervasive.SQL-x.yy-zzz.zzz.x86_64.[rpm | tar]
Server 32-bit | Full | Engine and client files, utilities, and documentation | Pervasive.SQL-x.yy-zzz.zzz.i486.[rpm | tar]
Client 32-bit | Client | Client files, utilities, and documentation | Pervasive.SQL-Client-x.yy-zzz.zzz.i486.[rpm | tar]
1 x.yy-zzz.zzz represents the actual digits in the file name that indicate the release and build number of the product

## Known Issues

This section lists the known issues for Pervasive PSQL v10 SP3.

#### Client Requesters

Tracking Number | Description
--- | ---
57018 | PCC says incorrectly "Windows 32-bit only" for Embedded spaces setting
57586 | When a communication session between client and server is no longer valid status 170 is returned

####

#### Data Archival

Tracking Number | Description
--- | ---
55919 | Archival logging does not work when a client machine has "use cache engine" turned on and Workgroup Engine or Cache Engine configured to run as a service. Workaround: Configure the Workgroup or Cache Engine service to run under a username/password that has the necessary rights to access objects on the remote server machine.

####

#### Documentation

Tracking Number | Description
--- | ---
58262 | Explanation of how to add ActiveX controls to a Visual Basic project is out of date

####

#### Eco-system Products

Tracking Number | Description
--- | ---
58520 | On Windows 7, navigational icons do display on DataExchange Wizard screen

####

#### I18N

Tracking Number | Description
--- | ---
57338 | Fails to bind database with lowercase non-Ascii characters using DTI PvModifyDatabase() function

####

#### Installation

Tracking Number | Description
--- | ---
55591 | After installation, the Add/Remove Programs “Modify” option displays features that were disabled during install
55835 | Installation time on Windows Vista is twice or more slower than non-Vista operating systems on equivalent hardware. Microsoft has confirmed that this is expected behavior because of the increased number of filter drivers such as UAC Virtualization and Vista Search Indexing.
56018 | Install not prompting user to uninstall PDAC SDK
56075 | Engines not added to firewall when performing minimum installation.
56240 | Pervasive PSQL v10 upgrade install does not disable DX 2.8 services
56300 | bdu command line utility is installed by a V10 client32 utility
56496 | Environment variables for v9 are not cleared on upgrading from v9 to v10
57224 | v10.10 install cannot handle long Java path
57447 | At the end of a Workgroup installation on Vista SP1 and Win 2008, the engine may not be started properly. Workaround: Manually start the Workgroup engine or reboot the machine to restart the engine.
57947 | Install may fail if 'MyPictures' folder is not available
58040 | Install fails if BtrevDos.cab is not present
58042 | Command line repair fails if EclipRCP.cab is not present
58045 | PSQL uninstall does not check for pending reboots on the system
58295 | 10.20 Install miscalculates disc space requirements
58316 | Workgroup Engine returns message engine already loaded as install runs Workaround: Click OK on the message dialog and the patch install continues and successfully installs.
58355 | Patch install on top of 10.10 is slow on Vista 64 bit
58420 | Install cancellation rollback result different than reported when invoked after the service is started
58553 | PSQL Install: Show disabled checkbox option to 'view registration page' on install finish dialog.

####

#### MicroKernel Engine

Tracking Number | Description
--- | ---
56363 | Accessing a file using two different symlinks on Windows Vista or Windows 2008 results in status 85 (file locked). If two applications access a file using two different symlinks, the second open results in status 85 (file locked). For example, if one application opens C:\ProgramData\Pervasive Software\PSQL\Demodata\Class.mkd and another application opens C:\Users\All Users\Pervasive Software\PSQL\Demodata\Class.mkd, the database engine returns status 85. Workaround: Use the same path for each open to access the file.
58003 | A B_GET_EQUAL operation on the system key (index 125) copies 244 bytes of the input key buffer even only 8 bytes were passed in. That does not happen on any other index but 125 (system key).
58427 | Custom installation using a128 byte destination path crashes the MicroKernel on Windows 7

####

#### Services

Tracking Number | Description
--- | ---
55946 | Set data path to ~150 chars and Pervasive PSQL services will not start

####

#### Software Development Kit (SDK)

Tracking Number | Description
--- | ---
55423 | PvCopyDatabase() does not work for database with referential integrity (RI), regardless of RI level. PvCopyDatabase API cannot properly copy tables with RI constraints. The copied tables with RI constraints return status 73 on open attempts.
55994 | Pervasive OLEDB Provider does not work with a database under "mixed" mode security. Workaround: Use MSDASQL Provider instead.
56481 | After completion of the ADO.NET design time installation, ADO.NET 3.0 provider does not appear in the Add Reference list.
56968 | DTO won't set a DBCodePage other than UTF8
58146 | Memory leak running .net application using Pervasive OLEDB.
58153 | Enumerated Types in DTO & DTI do not include Numeric even digit flag
58323 | JCL SDK Package is missing PVIDEODB's dbbackup folder and contents
58484 | ADO.NET provider fails to display in Visual Studio column names that contain a hyphen

####

#### SQL

Tracking Number | Description
--- | ---
54781 | Executing a stored procedure that contains a print statement inside the PCC or any other GUI tool (such as ODBCTest) may cause the tool to hang. Workaround: Modify the PSQL Relational Engine service property to "allow service to interact with desktop." This option is configurable with the "Log On" pane under the service's "Properties" screen.
55807 | DROP DATABASE disables user session. Any attempt to switch to another database fails.
56108 | On Linux, creating a user with a password of length 129 or greater is crashing the engine.
56863 | Attempting to create a client DSN from 10.10 client to v9.50 server fails
57076 | Data pulled from cross databases of different encodings is corrupted
57216 | Database Code Page setting change doesn't take effect until all connections are closed
57274 | Stored procedure out parameters crash server
57330 | Set owner to a value longer than 24 characters returns an erroneous message.
57345 | SQL Engine not matching index definition to existing Btrieve key
57362 | When doing ODBC translation for UTF8 database, space padding is not adjusted
57372 | Relational engine converts I18N Characters to upper case.
57385 | SQLForeignKeys() incorrectly returns HY000 instead of HY009 with invalid use of NULL pointer
58404 | Create database fails if database deleted then re-created and DDFs exist from previous creation
58630 | “Record Too Large” error from MS Access 2007 (escalation #183524)

####

#### System Driver

Tracking Number | Description
--- | ---
56575 | XIO is not supported in the Microsoft cluster environment

####

#### Utilities

Tracking Number | Description
--- | ---
54446 | DDF Builder does not support creating a table definition for a file that uses ISR (International Sort Rules). DDF Builder does not currently provide a warning. How to determine if a data file uses ISR: When a key has one of the ACS flags set, look at the 265 bytes for that ACS. If the signature byte is 0xAC, then it's a User-defined ACS. If the signature byte is 0xAD, then it's a locale-specific ACS. If the signature byte is 0xAE, then it's an ISR.
54785 | BDU utility fails when the secured database password is longer than 111 characters.
54990 | Some configuration settings in PCC are missing from a virtual network computing (VNC) session. Workaround: To configure the database engine, use PCC directly on that engine's console or use a remote desktop tool other than VNC.
55321 | PCC grid cannot display tables with numerous fields. Workaround: Use views or SELECT statements to limit the number of fields displayed in the grid.
55396 | The PSA functionality “View loaded Pervasive modules” does not list 64-bit Pervasive PSQL components.
55960 | DDF Builder encounters error when operating on files that are held open exclusively by another process. Workaround: Ensure that the files are not held open exclusively by another process.
56633 | DDF Builder should not allow saving a file with more than 119 indexes
56634 | DDF Builder creates an invalid definition for an overlapping segment file
56681 | Invoking DDF Builder plug-in details on 64-bit Linux results in internal error
56779 | PCC crashes in FedoraCore8 on Linux when adding a new table. This is caused by a known bug in Sun's JRE. Workaround: turn off some features using the following command: `sed -i 's/XINERAMA/FAKEEXTN/g' $JAVA_HOME/lib/i386/xawt/libmawt.so`
56842 | CNVDDF.exe returns status 357 and will not convert dictionary
56855 | 'Master' login name does not show in PCC on Linux as it does on Windows
56857 | One-column select in PCC on Linux results in grid taking the entire space instead of the width of the column data
56878 | COLLATE once specified in PCC is not removed on deletion
57056 | Create Btrieve File\Key Specification Page isn't scrolling.
57070 | When using DDF Builder in a virtual enviroment the SQL Index pane is very small or can barely be seen
57077 | DDF Builder does not show preview values for GUID
57088 | DDF Builder does not complain when you try to create a definition on a file with 1 multisegmented key
57093 | Help link for Table Definition Editor throws an error dialog
57111 | DDF Builder will not import btrieve schema remotely against demodata
57210 | PCC F10 hot key to Execute All SQL Statements does not work on Linux
57217 | butil crashes on Linux when incorrect -endbu parameter is used
57230 | Can't execute a view right after you create it in PCC
57255 | Window DDF Builder does not recognize 5x files on remote Linux servers.
57257 | Progress dialog displayed when loading data in the grid has unusable cancel button
57265 | Remote Window DDF Builder cannot see large file with extension going against linux server
57271 | Cannot export Btrieve Schema from a remote machine using DDF Builder
57310 | On SuSE 10.1 PCC may abort with message "line4: 5502 Aborted". This is a known system issue with SuSE 10.1 GTK controls.
57334 | butil @commandfile does not utilize quoted paths correctly
57335 | DDF Builder prompts multiple times for owner name on tables with owner names during database check even if you cancel the operation
57343 | Problem importing Btrieve schema remotely using DDF Builder
57345 | Error refreshing grid after adding a row in PCC
57414 | PCC displays a “20: Session Security Error” when showing properties of a table in a secure database
58150 | PCC GUI allows entering scale higher than precision for numeric data types
58170 | Minimum State Delay units would be better as seconds as in the manual
58171 | Range description in bcfg for Minimal State Delay is incorrect
58173 | Preview of DateTime doesn't show Milliseconds values
58230 | Repeated offline activation request for an auth.pky file fails with rc7267
58237 | Call from clilcadm.exe should start the engine like it did pre latest els changes
58259 | One part of PSA's log file has English dates
58268 | CLI license administrator can connect to another server without username and password but the GUI cannot
58276 | PCC throws errors when launched as user psql on Suse11. The GCC libraries installed with Pervasive PSQL are a different version from those provided with the Linux distribution. Workaround: Move the version of the libraries installed with Pervasive PSQL so the database engine will use the libraries provided with the Linux distribution. On a 32-bit installation run: cd /usr/local/psql/lib mkdir away mv libstdc++.so.6 away/ mv libgcc_s.so.1 away/ On a 64-bit installation run: cd /usr/local/psql/lib64 mkdir away mv libstdc++.so.6 away/ mv libgcc_s.so.1 away/
58287 | DDFBuilder log file cannot be displayed on SUSE 11
58303 | w64clilcadm displays a different message to clilcadm when no local engine is present (when client64 is installed).
58341 | PCC does not stop infinite loop resulting from stored procedure execution
58379 | File types incorrect in PCC Open File dialog
58493 | Signing information details about DDF Builder plugin display is in English on a Japanese system
58524 | DDF Builder does not create a new database with default options or with recommended options when directory is not present
58543 | Setting an encoding crashes PCC
58545 | XIOStats “Open CSV File” returns English errors on a Japanese system
58602 | CLI license administrator gives erroneous 7317 error when attempting to deactivate a product key
58611 | DDF Builer CheckTable sees LONGVARCHAR columns as a warning

####

## Usage Notes

This section discusses situations you may encounter using the product after installation. See also Known Issues.

### Windows

Subject | Discussion
--- | ---
Activation of Workgroup Key on Vista and Windows 7 | You can encounter difficulty activating a permanent key for Pervasive PSQL Workgroup on Windows Vista or Windows 7 if the following conditions are all true: Pervasive PSQL Workgroup was installed as an application. The Workgroup database engine is running without administrative privileges. Note that, by default, applications run with privileges of a standard user unless the privileges are elevated. That is, even if you are a member of the administrator’s group and you start the Workgroup database engine without using Run as Administrator to elevate privileges, the engine runs with privileges of a standard user. A permanent key for Pervasive PSQL Workgroup was not supplied during the installation process. That is, you chose to activate the permanent key after installation by using a licensing utility. Complete the following steps to ensure a permanent key is correctly activated: 1. If the Pervasive PSQL Workgroup application is running, close the application (stop the database engine by right-clicking on the engine tray icon then clicking stop). 2. From File Explorer, locate the file w3dbsmgr.exe. Look for the file under <install_drive>\Program Files\Pervasive Software\PSQL\bin. 3. Right-click w3dbsmgr.exe then click Run as Administrator. You must have administrative rights or know the password and name of a user with administrative rights. You need to elevate the privileges of the database engine before activating a key with a licensing utility. 4. From File Explorer, locate the file guilcadm.exe. Look for the file under <install_drive>\Program Files\Pervasive Software\PSQL\bin. (Alternatively, you could use the command line interface licensing utility, clicladm.exe, if you prefer.) 5. Right-click guilcadm.exe then click Run as Administrator. You must have administrative rights or know the password and name of a user with administrative rights. You need to elevate the privileges of the utility before activating a key with it. 6. Type, or paste, the permanent key for Pervasive PSQL Workgroup in the Key field, then click Activate. 7. Optionally, stop the database engine and re-start it without elevated privileges.
Restore point errors in Pervasive PSQL install log | Failures pertaining to restore point can be ignored. Sometimes the Windows operating system fails to create a snapshot of the current disk (called a restore point) prior to allowing a new application installation. The restore point is not required because the Pervasive PSQL uninstall completely removes the Pervasive PSQL product, rendering the same result as if you had used the Windows restore capability.
System DSN creation on Windows 2008 Server and Windows Vista | You can create system data source names (DSNs) only if logged on as an elevated administrator. A standard user cannot create system DSNs. This is a restriction placed by Windows, not Pervasive PSQL. When you create a new database with PCC, a corresponding system DSN is created by default. (You can override the default if you choose.) If you are logged on as a standard user or a non-elevated administrator and attempt to create a system DSN from PCC, status code 7011 results. As a standard user, you have two choices to create the system DSN for the database. You can use PCC or the Pervasive Distributed Tuning Interface PvCreateDSN() call. You must run the Workgroup Engine in an elevated mode with administrative privilege, or as a service with LocalSystem or administrative privilege. If you are logged on as a non-elevated administrator, you can also use the ODBC Administrator to create a system DSN locally once you elevate to full administrator. Once the system DSN is created successfully, any user may start the Workgroup Engine and use the DSN. Refer to the Windows documentation for security and types of users.
Internet protocol on Windows 2008 Server and Windows Vista | Pervasive PSQL supports Internet Protocol (IP) v4, not IP v6. Consider changing the operating system default configuration from IP v6 to IP v4. Using IP v4 as the default prevents the delay caused by the database engine when it attempts to use IP v6 then must revert to IP v4. Refer to the operating system documentation for setting the IP default.
Right-click shortcut for "Run As Administrator" on Windows 2008 Server and Windows Vista | A right-click on an application utility in the Windows Start menu does not offer a "Run As Administrator" option. This is a limitation of Windows. If, for some reason, you want to run a Pervasive PSQL utility in an elevated mode, you have several options: Run the utility from an elevate command prompt Create your own desktop shortcut to the utility executable Navigate to the utility executable with Windows Explorer.

###

### Linux

Subject | Discussion
--- | ---
ODBC and Linux | Unix ODBC does not come installed with Red Hat Enterprise 5. If your ODBC application is set to use the Unix ODBC cursor library, you need to install the Unix ODBC package or change your ODBC application to use the Pervasive ODBC driver.

## Technical Support

You may obtain technical support from the following Web-based support options:

- Pervasive Knowledge Base at http://www.pervasive.com/kb
- To open a support incident or report a product defect, see http://www.pervasive.com/support
- For technical discussions about Pervasive products, also see the Community Forum at http://cs.pervasive.com/forums

## Windows 2008 Server Certification

Pervasive PSQL is Certified for Windows 2008 Server (64-bit editions). As part of the certification requirements, the following topics are included in this readme file.

- Files Not Digitally Signed
- Windows Installer Custom Actions
- Log Files Stored at Root
- Files Requiring Administrator Privileges
- Files Not Installed To The Applications Directory
- Files Without Valid Version Information
- Icon Resource Files With an EXE File Extension

### Files Not Digitally Signed

The following two tables list files installed with the Pervasive PSQL v10 SP3 products on Windows platforms that are not digitally signed.

File | Vendor | Product | Description
--- | --- | --- | ---
keyhh.exe | KeyWorks Software (www.keyworks.net) | KeyHH | KeyHH augments HTMLHelp, a help development environment from Microsoft that produces .chm files from HTML-based source. KeyHH can be used in addition to, or as a complete replacement for, HH.EXE, which is provided by Microsoft. KeyHH provides all of the functionality of HH.EXE, offers solutions for some known bugs in HTMLHelp, and provides additional functionality.
mfc80.dll MFC80ENU.dll MFC80JPN.dll mfc80u.dll mfcm80.dll mfcm80u.dll msvcm80.dll msvcp80.dll msvcr80.dll | Microsoft (www.microsoft.com) | Visual C++ 2005 SP1 Libraries | Installs runtime components of Visual C++ Libraries required to run applications developed with Visual C++ SP1 on a computer that does not have Visual C++ 2005 SP1 installed.
localfile_1_0_0.dll in org.eclipse.core.filesystem. win32.x86_1.1.0.v20070510.jar swt-awt-win32-3347.dll in org.eclipse.swt.win32 .win32.x86_3.3.2.v3347a.jar swt-gdip-win32-3347.dll in org.eclipse.swt.win32.win32 .x86_3.3.2.v3347a.jar swt-wgl-win32-3347.dll in org.eclipse.swt.win32.win32 .x86_3.3.2.v3347a.jar swt-win32-3347.dll in org.eclipse.swt.win32.win32 .x86_3.3.2.v3347a.jar swt-xpcominit-win32-3347.dll in org.eclipse.swt.win32.win32 .x86_3.3.2.v3347a.jar swt-xulrunner-win32-3347.dll in org.eclipse.swt.win32.win32 .x86_3.3.2.v3347a.jar update.dll in org.eclipse.update.core.win32 _3.2.110.v20070615.jar win32refresh.dll in org.eclipse.core.resources.win32 _3.3.0.v20070226.jar | Eclipse Foundation (www.eclipse.org) | Eclipse Platform Software Development Kit (SDK) | Eclipse Platform SDK's Windows native libraries

The following Java Runtime Environment (JRE) files from Sun Microsystems (www.sun.com) are installed as required (see JRE Components Included in Installation). The JRE is a set of computer software programs and data structures that use a virtual machine model for the execution of other computer programs and scripts.

File
Abidjan, Accra, Adak, Addis_Ababa, Adelaide, Aden, Algiers, Almaty, Amman, Amsterdam, Anadyr, Anchorage, Andorra, Anguilla, Antananarivo, Antigua, Apia, Aqtau, Aqtobe, Araguaina, Argentina, Aruba, Ashgabat, Asmara, AST4, AST4ADT, Asuncion, Athens, Atikokan, Auckland, awt.dll, axbridge.dll, Azores
Baghdad, Bahia, Bahrain, Baku, Bamako, Bangkok, Bangui, Banjul, Barbados, Beirut, Belem, Belgrade, Belize, Berlin, Bermuda, Bishkek, Bissau, blacklist, Blanc-Sablon, Blantyre, Boa_Vista, Bogota, Boise, Brazzaville, Brisbane, Broken_Hill, Brunei, Brussels, Bucharest, Budapest, Buenos_Aires, Bujumbura
cacerts, Cairo, calendars.properties, Cambridge_Bay, Campo_Grande, Canary, Cancun, Cape_Verde, Caracas, Casablanca, Casey, Catamarca, Cayenne, Cayman, Center, CET, Ceuta, Chagos, charsets.pack, Chatham, Chicago, Chihuahua, Chisinau, Choibalsan, Chongqing, Christmas, chrome, chrome.manifest, CIEXYZ.pf, classlist, client, cmm.dll, Cocos, Colombo, Comoro, Conakry, content, content-types.properties, Copenhagen, COPYRIGHT, Cordoba, Costa_Rica, CST6, CST6CDT, Cuiaba, Curacao, Currie, cursors.properties
Dakar, Damascus, Danmarkshavn, Dar_es_Salaam, Darwin, Davis, Dawson, Dawson_Creek, dcpr.dll, Denver, deploy.dll, deploy.pack, deploytk.dll, Detroit, Dhaka, Dili, Djibouti, dnsns.jar, Dominica, Douala, dt_shmem.dll, dt_socket.dll, Dubai, Dublin, DumontDUrville, Dushanbe
Easter, Edmonton, EET, Efate, Eirunepe, El_Aaiun, El_Salvador, Enderbury, EST, EST5, EST5EDT, Eucla, eula.dll
Fakaofo, Faroe, ffjcext.zip, Fiji, flavormap.properties, fontconfig.98.bfc, fontconfig.98.properties.src, fontconfig.bfc, fontconfig.properties.src, fontmanager.dll, Fortaleza, Freetown, Funafuti
Gaborone, Galapagos, Gambier, Gaza, Gibraltar, Glace_Bay, GMT, GMT+1, GMT+10, GMT+11, GMT+12, GMT+2, GMT+3, GMT+4, GMT+5, GMT+6, GMT+7, GMT+8, GMT+9, GMT-1, GMT-10, GMT-11, GMT-12, GMT-13, GMT-14, GMT-2, GMT-3, GMT-4, GMT-5, GMT-6, GMT-7, GMT-8, GMT-9, Godthab, Goose_Bay, Grand_Turk, GRAY.pf, Grenada, Guadalcanal, Guadeloupe, Guam, Guatemala, Guayaquil, Guyana
Halifax, Harare, Harbin, Havana, Helsinki, Hermosillo, Ho_Chi_Minh, Hobart, Hong_Kong, Honolulu, Hovd, hpi.dll, hprof.dll, HST, HST10
Indiana, Indianapolis, indicim.jar, install.rdf, instrument.dll, Inuvik, invalid32x32.gif, ioser12.dll, Iqaluit, Irkutsk, Istanbul
j2pcsc.dll, j2pkcs11.dll, jaas_nt.dll, Jakarta, Jamaica, java-rmi.exe, java.dll, java.exe, java.policy, java.security, java_crw_demo.dll, javacpl.cpl, javacpl.exe, javaw.exe, javaws.exe, javaws.pack, javaws.policy, jawt.dll, Jayapura, jbroker.exe, jce.jar, JdbcOdbc.dll, jdk_header.png, jdwp.dll, Jerusalem, jkernel.dll, jli.dll, jmxremote.access, jmxremote.password.template, Johannesburg, Johnston, jp2iexp.dll, jp2launcher.exe, jp2native.dll, jp2ssv.dll, jpeg.dll, jpicom.dll, jpiexp.dll, jpinscp.dll, jpioji.dll, jpishare.dll, jqs.conf, jqs.exe, jqs_plugin.dll, jqsmessages.properties, jqsnotify.exe, jsound.dll, jsoundds.dll, jsse.jar, jsse.pack, jucheck.exe, Jujuy, Juneau, jureg.exe, jusched.exe, jvm.cfg, jvm.dll, jvm.hprof.txt
Kabul, Kaliningrad, Kamchatka, Kampala, Karachi, Kashgar, Kathmandu, Kentucky, Kerguelen, keytool.exe, Khartoum, Kiev, Kigali, kinit.exe, Kinshasa, Kiritimati, klist.exe, Knox, Kolkata, Kosrae, Krasnoyarsk, ktab.exe, Kuala_Lumpur, Kuching, Kuwait, Kwajalein, La_Paz, La_Rioja, Lagos, Libreville
LICENSE, LICENSE.rtf, LICENSE_de.rtf, LICENSE_es.rtf, LICENSE_fr.rtf, LICENSE_it.rtf, LICENSE_ja.rtf, LICENSE_ko.rtf, LICENSE_sv.rtf, LICENSE_zh_CN.rtf, LICENSE_zh_TW.rtf, Lima, Lindeman, LINEAR_RGB.pf, Lisbon, local_policy.jar, localedata.pack, logging.properties, Lome, London, Lord_Howe, Los_Angeles, Louisville, Luanda, Lubumbashi, LucidaBrightDemiBold.ttf, LucidaBrightDemiItalic.ttf, LucidaBrightItalic.ttf, LucidaBrightRegular.ttf, LucidaSansDemiBold.ttf, LucidaSansRegular.ttf, LucidaTypewriterBold.ttf, LucidaTypewriterRegular.ttf, Lusaka, Luxembourg, lzma.dll
Macau, Maceio, Madeira, Madrid, Magadan, Mahe, Majuro, Makassar, Malabo, Maldives, Malta, management-agent.jar, management.dll, management.properties, Managua, Manaus, Manila, Maputo, Marengo, Marquesas, Martinique, Maseru, Mauritius, Mawson, Mayotte, Mazatlan, Mbabane, McMurdo, Melbourne, Mendoza, Menominee, Merida, messages.properties, messages_de.properties, messages_es.properties, messages_fr.properties, messages_it.properties, messages_ja.properties, messages_ko.properties, messages_sv.properties, messages_zh_CN.properties, messages_zh_HK.properties, messages_zh_TW.properties, MET, meta-index, Mexico_City, Midway, Minsk, Miquelon, mlib_image.dll, Mogadishu, Monaco, Moncton, Monrovia, Monterrey, Montevideo, Monticello, Montreal, Montserrat, Moscow, MST, MST7, MST7MDT, msvcr71.dll, msvcrt.dll, Muscat
Nairobi, Nassau, Nauru, Ndjamena, net.dll, net.properties, new_plugin, New_Salem, New_York, Niamey, Nicosia, nio.dll, Nipigon, Niue, Nome, Norfolk, Noronha, North_Dakota, Nouakchott, Noumea, Novosibirsk, npdeploytk.dll, npjp2.dll, npjpi160_16.dll, npoji610.dll, npt.dll
Omsk, Oral, orbd.exe, Oslo, Ouagadougou, overlay.js, overlay.xul, pack200.exe
Pago_Pago, Palau, Palmer, Panama, Pangnirtung, Paramaribo, Paris, Perth, Petersburg, Phnom_Penh, Phoenix, Pitcairn, plugin.pack, policytool.exe, Ponape, Pontianak, Port-au-Prince, Port_Moresby, Port_of_Spain, Porto-Novo, Porto_Velho, Prague, psfont.properties.ja, psfontj2d.properties, PST8, PST8PDT, Puerto_Rico, PYCC.pf, Pyongyang
Qatar, Qyzylorda
Rainy_River, Rangoon, Rankin_Inlet, Rarotonga, README.txt, Recife, Regina, Resolute, resources.jar, Reunion, Reykjavik, Riga, Rio_Branco, Rio_Gallegos, Riyadh, Riyadh87, Riyadh88, Riyadh89, rmi.dll, rmid.exe, rmiregistry.exe, Rome, Rothera, rt.jar
Saipan, Sakhalin, Salta, Samara, Samarkand, San_Juan, San_Luis, Santarem, Santiago, Santo_Domingo, Sao_Paulo, Sao_Tome, Scoresbysund, Seoul, servertool.exe, Shanghai, Simferopol, Singapore, snmp.acl.template, Sofia, sound.properties, soundbank.gm, South_Georgia, splash.gif, splashscreen.dll, sRGB.pf, ssv.dll, ssvagent.exe, St_Helena, St_Johns, St_Kitts, St_Lucia, St_Thomas, St_Vincent, Stanley, Stockholm, sunjce_provider.jar, sunmscapi.dll, sunmscapi.jar, sunpkcs11.jar, Swift_Current, Sydney, Syowa
Tahiti, Taipei, Tallinn, Tarawa, Tashkent, task.xml, task64.xml, Tbilisi, Tegucigalpa, Tehran, Tell_City, thaiim.jar, Thimphu, THIRDPARTYLICENSEREADME.txt, Thule, Thunder_Bay, Tijuana, Tirane, tnameserv.exe, Tokyo, Tongatapu, Toronto, Tortola, Tripoli, Truk, Tucuman, Tunis, tzmappings
UCT, Ulaanbaatar, unicows.dll, unpack.dll, unpack200.exe, Urumqi, US_export_policy.jar, Ushuaia, UTC, Uzhgorod
Vaduz, Vancouver, verify.dll, Vevay, Vienna, Vientiane, Vilnius, Vincennes, Vladivostok, Volgograd, Vostok
w2k_lsa_auth.dll, Wake, Wallis, Warsaw, Welcome.html, WET, Whitehorse, win32_CopyDrop32x32.gif, win32_CopyNoDrop32x32.gif, win32_LinkDrop32x32.gif, win32_LinkNoDrop32x32.gif, win32_MoveDrop32x32.gif, win32_MoveNoDrop32x32.gif, Winamac, Windhoek, Winnipeg, wsdetect.dll
Xusage.txt, Yakutat, Yakutsk, Yekaterinburg, Yellowknife, Yerevan, YST9, YST9YDT, Zaporozhye, zip.dll, ZoneInfoMappings, Zurich

### Windows Installer Custom Actions

The technical details of each Windows Installer Custom Action executed during the Pervasive PSQL installation process are available to System Administrators. This information is listed in the document PSQL_CA_Reference.rtf, which is embedded in the Pervasive PSQL MSI installation packages.

Administrators can view and print the RTF content from the "Custom Action Reference" dialog which is only displayed during an Administrative Installation. An administrative Installation can be launched the following ways.

#### Using InstallShield Launcher Program (Setup*.exe)

1. Click Start -->Run --> {path}\SetupInstallType_xPlatformType.exe /a
2. Click Next to display the Custom Actions Reference dialog.
3. Click Print to print the RTF document.

#### Using Microsoft Windows Installer (MSI) Process Only

1. Click Start -->Run --> msiexec.exe /a {path}\PervasivePSQLv10_InstallType_xPlatformType.msi /leom {path}\LogFileName.log
2. Click Next to display the Custom Actions Reference dialog.
3. Click Print to print the RTF document.

### Log Files Stored at Root

The Pervasive PSQL Server installation stores the following log files on the system drive in the folder C:\exts:

- bdu.log
- btr.log
- ddf.log
- dta.log

### Files Requiring Administrator Privileges

The following files require Administrator privileges to run.

- Psc.exe. This is a Pervasive PSQL utility that retrieves and sets control information about Pervasive PSQL services.
- Jucheck.exe. This file is part of the Java Runtime Environment (JRE) and checks for Java updates.

### Files Not Installed To The Applications Directory

The following files do not install to the applications directory:

- C:\Windows\System32\ javacpl.cpl
- C:\Windows\SysWOW64\ javacpl.cpl

### Files Without Valid Version Information

The following files, which are part of the Java Runtime Environment (JRE), do not contain valid file version information:

- Launcher.exe
- Zipper.exe

### Icon Resource Files With an EXE File Extension

Microsoft Windows Installer (MSI) contains icon resource files with a file name extension of “exe.” Note that these files, despite the file name extension, are not executable files.

Such files are located in the %windir%\Installer\{install_type_product_code}\ directory.

For example, in that directory you might see files with names similar to c:\Windows\Installer\{0A3238D7-AC64-1010-B717-F3E3F18B4A8C}\ARPPRODUCTICON.exe and c:\Windows\Installer\{0A3238D7-AC64-1010-B717-F3E3F18B4A8C}\pvswDocsShortcut.A01E0590_D2E0_43CE_B351_BB16EA0FBDE0.exe.

## Disclaimer

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.

Copyright ©2009 Pervasive Software Inc. All Rights Reserved.

Pervasive Software Inc. http://www.pervasive.com 12365 Riata Trace Pkwy, Bldg B Austin, TX 78727 USA Voice: (512) 231-6000 Fax: (512) 231-6010 Online Pervasive Contacts

*** END OF README ***