Application Support for Sweeps Software (Input Systems)

QUICK LINKS FOR PERVASIVE PSQL v9 USERS:

• Download 30-Day Evaluation License of Pervasive PSQL v9: This link allows you to download a 30-day evaluation license of the Pervasive PSQL v9 database engine. For smaller sites (under 5 users), you will want to get the Workgroup Engine. Larger Sites (6+ users) should get the Client/Server Engine instead.
• Download Pervasive PSQL v9.5 Service Pack 2: This updates your v9.0 or v9.1 software to the current v9.5 code release. Sites which purchased Pervasive PSQL v9 PRIOR to APRIL, 2006 should get this update. DO NOT DOWNLOAD if you have PSQLV8 or older, unless you want to pay for an upgrade license as well!

QUICK LINKS FOR PERVASIVE.SQL V8 USERS:

• Frequently Asked Questions About the SP3 Update. Click here to get answers to the most common questions about the updating process.
• Download Pervasive.SQL V8.7 Service Pack 3 (This updates your V8.0, 8.1, 8.5 or 8.6 software to the current V8.7 code release. Sites which purchased the Pervasive.SQL V8 PRIOR to AUGUST, 2004 should get this update applied to their systems.

The SWEEPS application, designed by Input Systems for use by environmental health agencies and managers, uses the Pervasive PSQL v9 database engine. This database engine provides the power, performance, and flexibility to store all of the SWEEPS data on your computer and server. There are two editions of the Pervasive PSQL v9.5 engine -- the Client Server Engine (CSE) and the Workgroup Engine (WGE).

The CSE is the preferred solution for all users, as it provides superior performance, easier setup, straightforward access via Citrix or Terminal Services, and it leverages your operating system security to protect your data. The CSE is available in user counts of 6U, 10U, 20U, and higher, and it is REQUIRED for all sites that will be running more than 5 users CONCURRENTLY in the database application. The CSE requires the use of a Windows NT/2000/2003, NetWare, or Linux database/file server.We also recommend making sure that you meet the Pervasive.SQL Pre-Requisites list on your network before upgrading.

On the other hand, if you have less than 5 concurrent users and do not need the security or other features offered by the server engine, then the Workgroup Engine (WGE) may be right for you. Substantially cheaper than the CSE, the WGE offers database access for small workgroups and standalone systems.

Special Note: SWEEPS users who plan on running the software in a "disconnected" or stand-alone state (e.g. field laptops) WILL require Pervasive Workgroup licenses for each disconnected computer. Smaller configurations can use ONLY the WGE, but larger users may find themselves needing BOTH engines for some environments. If you have specific questions about exactly what you may need, you may wish to contact Input Systems (see link at the top of this page) for more information.

Installation is similarly easy with both types of engines -- pop in the CDROM & follow the prompts, then reboot. It is usually as simple as that, although Vista users may have some additional configuration to do. (Pervasive Software has a white paper on Vista to get you started.)

For pricing, please refer to our price list for Pervasive PSQL v9 or contact us for an exact quote!


There are four installation tips for this software at this time:

1. Performance Tip: If the WGE is used, the machine with the data files physically on it (usually known as the peer server) should be designated as the permanent gateway using the Gateway Locator Utility. (If this is on a separate server, then you will need to purchase a database engine license for this computer as well.) Changing the configuration from a floating gateway (the default) to a permanent gateway will provide the best performance and stability. See our white paper on this topic for more information, or click HERE for the video!
2. Status Code 2738 During Installation: Some users are experiencing this error on certain computers, especially on older Windows 98 computers. This error message indicates that the Microsoft Installer was unable to run the VBScript needed to install the product. If you get this message, you will need to download and install the VBScript update utility from Microsoft, reboot your computer, and then try the installation again.
3. Status Code 161 After Installation: If you are getting a Status 161 (Licensing Error) after installing Pervasive and trying to run with more than 1 user, then your database license may not be properly applied. On each computer, start the Pervasive License Administrator (which you'll find in the Start/Programs/Pervasive programs group) and check the license count showing on this screen. If you see a 1-user license, then you will need to apply your permanent license to this software. See your invoice or packing slip for your Registration Keycode, and enter this number into the boxes provided on that dialog box, then click "Add License". You should see the proper license count then showing.
4. Is Pervasive PSQL v9 supported on Windows Vista? Windows Vista adds a whole new level to the security game. See the Pervasive/Vista white paper for more details.