Pervasive.SQL 2000i
Service Pack 3 General Release - March 2001
README.HTM
Contents
This document contains the following topics:
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
Return to top of page.
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.
Return to top of page.
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 support |
Chapter 1, "What's New in Pervasive.SQL 2000i SP3" |
| New and enhanced documentation |
Chapter 1, "What's New in Pervasive.SQL 2000i SP3" |
| Pervasive System Analyzer utility |
Chapter 2, "Pervasive System Analyzer 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" |
Return to top of page.
Environments Tested
Pervasive.SQL 2000i SP3 release is supported on the following platforms:
Server Engines
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 Server |
Local + remote 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.
Return to top of page.
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 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:
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.
Return to top of page.
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
Return to top of page.
Technical Support
Return to top of page.
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
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/
Return to top of page.
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.
*** END OF README.HTM ***