                            Pervasive.SQL 2000i
                Service Pack 3 General Release - March 2001
                                README.TXT

Contents

  ------------------------------------------------------------------------

This document contains the following topics:

   * "General Information"
   * "Installation Warnings"
   * "New Features and Enhancements"
   * "Environments Tested"
   * "Documentation Notes"
   * "Known Issues"
   * "Technical Support"
   * "Useful Links"
   * "Disclaimer"

  ------------------------------------------------------------------------

General Information

Welcome to the Pervasive.SQL 2000i Service Pack 3 release.

Note:   What's New in Pervasive.SQL 2000i, included in your online
documentation, contains a wealth of information about new features in this
release. You can view this documentation via the Start Menu by selecting
Start | Programs | Pervasive | Pervasive.SQL 2000i | Documentation | Whats
New.



Technical Note:  Cache Tuning on Servers

Windows NT and Windows 2000 both implement dynamic file system cache 
mechanisms which allow the system to take advantage of free memory to cache 
recently accessed data.  Microsoft provides several mechanisms which allow 
applications and administrators to configure this cache growth algorithm to 
match the needs of different application execution environments.  By default 
this mechanism is configured to favor simple file sharing which results in 
very aggressive system cache growth.  Pervasive.SQL implements a private disk 
cache as well as utilizing the Windows file system cache, and so, following 
Microsoft’s guidelines, Pervasive.SQL configures this mechanism to better 
accommodate network applications when installed on either NT 4.0 Server or 
Windows 2000 Advanced Server.

The registry parameter that is modified is:

HKEY_LOCAL_MACHINE\SYSTEM\
CurrentControlSet\Control\Session Manager\Memory Management

Value: LargeSystemCache

By default, on Windows Server operating systems this value is set to 1.  
Pervasive.SQL sets this value to 0 at install time. You must reboot your 
server after installing for this setting to take effect. 

More information on these mechanisms can be found on Microsoft’s support 
web site at http://support.microsoft.com/support/kb/articles/Q232/2/71.ASP

  ------------------------------------------------------------------------

Installation Warnings

This release has been tested thoroughly and in a variety of configurations.

There are several Microsoft system DLLs that must be updated for
Pervasive.SQL 2000i SP3 to work correctly. If Install finds that these DLLs
are not the latest versions, it will update them and you MUST reboot before
continuing the install.

Also, please note the following in regards to installing this product:

General

   * If you have the Beta release of this service pack installed, you must
     uninstall it and reboot before installing the general release.
   * The Pervasive.SQL 2000i MicroKernel supports the Pervasive.SQL 7
     Scalable SQL relational database engine. It is important to note
     however that as of this writing, the Pervasive.SQL 7 Scalable SQL
     engine is not yet supported on Windows 2000.
   * You may encounter display problems when using the new HTML Help
     documentation. These problems are caused by specific Internet Explorer
     versions on your system. For information on how to solve this problem,
     please see the section "Internet Explorer and the HTML Help System"
     under "Documentation Notes".

Windows-specific

   * When installing to Windows NT 4, you must have at least Windows NT 4
     Service Pack 3 to install Pervasive.SQL 2000i SP3. The use of Windows
     NT 4, Service Pack 5 or higher is strongly recommended. Use of Windows
     NT 4 Service Pack 4 is not recommended due to known defects in that
     release.
   * You must have Administrator rights in order to install Pervasive.SQL
     2000i. If you do not have at least Power User rights when installing 
     to Windows 2000, you will receive an inaccurate error message stating
     that unInstallShield is in use.
   * Pervasive.SQL 2000i SP3 may not install or run correctly on older
     Windows 95 systems. If you experience difficulties while installing to
     Windows 95, ensure that you have the latest service packs from
     Microsoft installed. These Microsoft updates are not redistributable
     by Pervasive. You also need Internet Explorer 4.01 SP2 or later for
     Windows 95 to function correctly with Pervasive.SQL 2000i. 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.

Terminal Server-specific

Pervasive.SQL 2000i is designed to operate seamlessly in a 
Terminal Server deployment. Supported configurations for Pervasive.SQL
2000i and Terminal Server include:

   * Installation of Terminal Server with Client requesters loaded in each
     individual session and accessing a remote Pervasive.SQL 2000i Server
     engine
   * Installation of Terminal Server with the Pervasive.SQL 2000i Server
     engine installed on the same hardware. Client requesters can be loaded
     in each individual session accessing either a remote Pervasive.SQL
     2000i Server engine or the local Server engine.

At this time, Pervasive.SQL 2000i Workstation and Workgroup engines are not
supported accessing files locally.

NetWare-specific

   * During NetWare installations, the creation of a DSN for DEMODATA will
     fail if TCP/IP is installed on the NetWare server but is not
     functioning correctly. Pervasive.SQL defaults to using TCP/IP if the
     installation detects that TCP/IP is installed, whether or not it is
     configured correctly. The same will be true of any subsequent attempts
     to create a database on the NetWare server. There are three ways to
     resolve this: 1) Ensure TCP/IP is working prior to installing
     Pervasive.SQL; 2) Uninstall TCP/IP from the server prior to installing
     Pervasive.SQL; 3) Change the protocol in use to SPX after installing.



  ------------------------------------------------------------------------

New Features and Enhancements

Please see What's New in Pervasive.SQL 2000i for a complete description of
new features in this release as well as documentation for the use of these
features.

           New Feature                       What's New Chapter

 Row-level locking               Chapter 1, "What's New in Pervasive.SQL
                                 2000i SP3"

 Improved networking support     Chapter 1, "What's New in Pervasive.SQL
                                 2000i SP3"

 Improved operating system       Chapter 1, "What's New in Pervasive.SQL
 support                         2000i SP3"

 New and enhanced documentation  Chapter 1, "What's New in Pervasive.SQL
                                 2000i SP3"

 Pervasive System Analyzer       Chapter 2, "Pervasive System Analyzer
 utility                         Utility"

 Improved SQL support            Chapter 3, "SQL Syntax Enhancements"

 Dynamic cursors                 Chapter 4, "Dynamic Cursors in
                                 Pervasive.SQL 2000i SP3"

 OLE DB 2.5 support              Chapter 5, "Improved OLE DB Provider"

 JDBC 2 driver                   Chapter 6, "JDBC Enhancements"



  ------------------------------------------------------------------------

Environments Tested

Pervasive.SQL 2000i SP3 release is supported on the following platforms:

   * "Server Engines"
   * "Workgroup/Workstation Engines"

Server Engines

   * "NetWare"
   * "Windows NT/2000"

NetWare

   Server OS     Client OS   Network client    Requester

 NW 4.11 (SP7) Win95 (SP1)   MS             Win32

 NW 5 (SP4)    Win98         MS             Win32

 NW 5 (SP4)    Win95 (SP1)   Novell 3.3     Win32

 NW 5 (SP4)    Win98         Novell 3.3     Win32

 NW 5 (SP4)    NT4.0 (SP5)   Novell 4.8     Win32

 NW 4.2 (SP8a) NT4.0 (SP5)   Novell 4.8     Win32

 NW 5 (SP4)    Win95 (SP1)   MS             Win32

 NW 5 (SP4)    Win95B        MS             Win16

 NW 3.2        Win95B        MS             Win32

 NW 5 (SP5)    NT 4 (SP5)    MS             DOS 16 (Breqnt)

 NW 5 (SP5)    Win95         MS             Win32

 NW 4.2 (SP8a) NT 4 (SP5)    Novell 4.8     Dos16 (Breqnt)

 NW 4.2 (SP8a) Windows 2000  Novell 4.8     Win32

 NW 4.2 (SP8a) Windows 2000  MS             Win32

 NW 5 (SP4)    Windows 2000  MS             Win32

 NW 5 (SP4)    Windows 2000  Novell 4.8     Win32

 NW 3.2        Windows 2000  MS             Win32

Windows NT/2000

         Server OS             Client OS     Network client    Requester

 Windows 2000              Windows ME        N/A            Win32

 Windows 2000              NT 4 SP5          N/A            Win32

 Windows 2000              Windows 95B       N/A            Win32

 Windows 2000              Windows 98        N/A            Win32

 Windows 2000              Windows 2000      N/A            Win32

 Windows 2000 Terminal     Local + remote
 Server                    DB                N/A            Win32

 NT 4 (SP5)                Windows 98        N/A            Win32

 NT 4 (SP5)                Windows ME        N/A            Win32

 NT 4 (SP5)                NT 4 (SP5)        N/A            Win32

 NT 4 (SP5)                Windows 95B       N/A            Win16 Thunking

 NT 4 (SP6a)               Windows 98        N/A            Win32

 NT 4 (SP5) Citrix
 MetaFrame                 Windows 98        N/A            Win32

Workgroup/Workstation Engines

Pervasive.SQL 2000i SP3 release is supported on the following platforms:

   * Windows 2000
   * Windows NT 4, SP5 and greater
   * Windows ME
   * Windows 98
   * Window 95B

Note:   As a platform for either a server client or a workgroup/workstation
engine, Windows 95 is only supported if you are running Windows 95B with
all the latest service packs and you have installed Internet Explorer 4.0
or greater. Otherwise, you may encounter problems installing the product.



  ------------------------------------------------------------------------

Documentation Notes

This section provides information regarding the documentation included with
the Pervasive.SQL 2000i product.

   * This release includes new support for Microsoft HTML Help. The
     installation program determines whether your system can support the
     new HTML Help format. If so, your documentation is provided in HTML
     Help format (files with .CHM extension). If not, Winhelp documentation
     is installed (files with .HLP extension). On a server installation,
     both forms are installed so that clients without support for HTML Help
     can access the documentation on the server.
   * You cannot read online documentation on Windows 3.x until you install
     the 16-bit Acrobat reader. The Pervasive.SQL 2000i install does not do
     this for you. The 16-bit Acrobat Reader is located at <CD>:\acroread
     on the NetWare and Windows NT server CDs.

Internet Explorer and the HTML Help System

HTML Help uses parts of the Internet Explorer (IE) engine to display help
files. In the early versions of IE 5, Microsoft included a defect that
causes display problems with modular HTML Help systems. These problems can
be seen in PSQL2000.CHM, the master help file for Pervasive.SQL 2000i that
dynamically loads the other help files. Since this defect only affects the
file merging mechanism, you see no problems 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 problems, the solution is to upgrade to IE
5.01 or higher.

Configurations Where the IE Problem Occurs

You can experience this problem under the following conditions:

   * You have Windows NT 4, Windows 98, or Windows 95.
   * You have an Internet Explorer version listed in "Internet Explorer
     Versions that Cause Problems with HTML Help". A typical problem
     scenario is applying MS Office 2000 (which applies a defective IE 5
     version) onto a Windows NT 4 system.

You can determine your version by clicking Help | About Internet Explorer
from the browser window.

Internet Explorer Versions that Cause Problems with HTML Help

If your Internet Explorer version is one of the following, then you may
encounter problems with the main HTML Help file (PSQL2000.CHM).
   IE Version                           Description

 5.00.2014.0216 Internet Explorer 5 (First Production version)

 5.00.2314.1003 Internet Explorer 5 (shipped with Office 2000, also known
                as 5.0a)

 5.00.2614.3500 Internet Explorer 5 (shipped with Windows 98 Second
                Edition)

To resolve the problem, download version 5.01 or higher from Microsoft's
web site:

   * IE 5.01 http://www.microsoft.com/windows/ie/download/ie501sp1.htm
   * IE 5.5 http://www.microsoft.com/windows/ie/download/ie55sp1.htm

Internet Explorer Versions that work with HTML Help

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

 5.00.2919.6307 Internet Explorer 5.01

 5.00.3105.0106 Internet Explorer 5.01 with Service Pack 1

Windows 2000 and Windows ME shipped with IE 5.01 so you should not see the
problem on those platforms. Also, the problem should not occur with older
IE 4 versions.

Contact Pervasive Technical Publications

If you have additional questions, or cannot make the documentation function
correctly, e-mail docs@pervasive.com.



  ------------------------------------------------------------------------

Known Issues

This release of Pervasive.SQL 2000 changes the way Known Issues are
published. So that we can update known issue reports periodically between
releases, all Known Issues are now published in the Knowledge Base on the
Pervasive web site, rather than in this static document.

In the Knowledge Base, perform a search on "Pervasive.SQL 2000 Service Pack
3 known issues" in order to get a list of known issues. Click the link
below to visit the Knowledge Base:

http://support.pervasive.com/eSupport/

You can also visit the following URL for a static list of known issues
including links to the associated Knowledge Base articles:

http://www.pervasive.com/support/technical/papers/psql2kftf.tml



  ------------------------------------------------------------------------

Technical Support

   * For technical support and discussions about Pervasive products, browse
     to http://www.pervasive.com/devtalk.
   * If you wish to file a support incident, see the following page for
     more information: http://www.pervasive.com/support/Email_Support.taf.
   * You can also visit http://www.pervasive.com/contact on the Pervasive
     Home Page for other contact information.



  ------------------------------------------------------------------------

Useful Links

   * For a comprehensive list and details of Pervasive Products, see

http://www.pervasive.com/products/software

   * Discuss all your Pervasive development issues at:

http://www.pervasive.com/devtalk

   * For Known Issues, see

http://www.pervasive.com/support/technical/papers/psql2kftf.tml

   * For Technical Papers, see:

http://www.pervasive.com/support/technical/papers/

   * For online Product Manuals, see:

http://www.pervasive.com/support/technical/product/

   * For information on our Support programs, see

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

   * See our new and updated Knowledge Base at:

http://support.pervasive.com/eSupport/

   * For information on Updates and Patches, see:

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



  ------------------------------------------------------------------------

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.

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 © 2001 Pervasive Software Inc.
All Rights Reserved.

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

       *** END OF README.TXT ***
