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 :\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 ***