Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v16
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Application Support for Sweeps Software (Input Systems)

Software Vendor: Input Systems, Incorporated
Application Name: SWEEPS
Application Versions:  
  • 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!

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.
If you are a software vendor and would like to add, remove, or modify your information on these pages, we'll be happy to oblige. Simply contact us directly!
  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us