Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
PSQL Database Engines
+ Actian PSQL Vx 12
+ Actian PSQL v12
+ Actian PSQL Vx 11
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users File Repair Mailing List
Need Answers Now?
     Get Support Now
Licensing Help
Contact Actian to Fix a License
Navigation Background

Application Support for Itron


Software Vendor: Itron
Application Versions:

MV-90 xi v3.0 (2010): Requires Pervasive PSQL v9.5 or higher. PSQLv11 is recommended.
MV-RS: Requires PSQLv9 or higher. PSQLv11 is recommended.
MV-RS v8.5: Requires PSQLv10 or higher. PSQLv11 is recommended.

IEE 6.0 SP4: Certified for Pervasive PSQL v9.5. However, Itron indicates that no source code changes were made for PSQLv11 support, so PSQLv11 should be OK (though not officially supported).
IEE 7.0 SP4: Certified for Pervasive PSQL v11

Important Note from Itron:In the fall of 2011, Itron announced (via their newsletter) that 64-bit database engines are now supported for MV-90xi. This mirrors the acceptance of 64-bit PSQLv11 engines for MV-RS.

QUICK LINKS FOR PERVASIVE PSQL v11 USERS:
  • Download 30-Day Evaluation License of Pervasive PSQL v11: This link allows you to download a 30-day evaluation license of the PSQLv11 database engine. Single user installations should get the Workgroup Engine. Multi-user installations should get the Server Engine. You should download the Server Engine bit level that matches your OPERATING SYSTEM, but you should ALWAYS download the Clent Win32 for use on the workstations, as Itron provides 32-bit applications today. Be sure to ALSO download and apply the v11.01 Update 4 (or later) before using the system with Itron MV-90 xi.
QUICK LINKS FOR PERVASIVE PSQL SUMMIT v10 USERS:

MV-90 xi v3.0 SOFTWARE & HARDWARE REQUIREMENTS

We have received many questions about this lately, so here is the most current information on the requirements for operating MV-90 xi v3.0 (as of June, 2012).

Server Operating Systems: 
- Windows Server 2003, 2008, 2008 R2

Client/Workstation Operating Systems: 
- Windows XP
- Windows Vista: Business & Enterprise
- Windows 7: Professional & Enterprise: 32-bit & 64-bit
- Windows Server 2003, 2008, 2008 R2

Pervasive PSQL database:
- v9 SP2 and above
- v10: 32-bit
- v11: 32-bit & 64-bit
- Vx Server 11

A minimum of 4 GB RAM is recommended for both client/workstations and the server.


The Itron MV-90 xi application uses the Pervasive database engine to provide world-class performance and flexibility to their application development efforts. Itron allows users to purchase software through Itron or through Goldstar Software, their preferred reseller for the Pervasive database engine. We have worked extensively with Itron over the years and are in an excellent position to help you get your software installed and running quickly.

Installation of the Pervasive database is easy -- pop in the CDROM & follow the prompts, then reboot, so you can do it yourself or have your tech guy (or gal) handle it for you. There is also a trial download available from the Pervasive web site (see links above) if needed. This trial can be converted to a full license, if you wish to avoid shipping costs of the physical CDROM.

For stand-alone (single-user) installations of MV-90 xi, the WorkGroup Engine (WGE) is for you. Although the Workgroup Engine is capable of supporting small workgroups of up to 5 concurrent users, Itron does not currently support this configuration, and you should instead get the Server engine. Please contact Itron for more information about their support for multi-user Workgroup Engines.

For multi-user installations, you want the Pervasive Server Engine, which is available with user counts of 6, 10, 20, 50, 100, and more. The Server Engine also provides additional performance and security over the WGE, and should be considered even for smaller sites looking to grow in the future. The Server Engine requires the use of a Windows 2000/2003/2008. We also recommend making sure that you meet the Pervasive.SQL Pre-Requisites list on your network before upgrading.

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

Pervasive PSQL Summit v10 has been discontinued by and is now unsupported by Pervasive Software. PSQLv10.31 is the current version, and is supported by both Itron and Goldstar Software as well. The PSQLv10 software does NOT support running on Windows 95, 98, ME, or NT, so sites with older computers may be forced to upgrade their operating systems first. Also, please note that Windows 2000 users must have SP4, and Windows XP users must have SP2 to install this release. Users should also obtain the latest patch, indicated above. Windows 2008 Server, Vista, and 7 operating systems require the use of PSQL v10 or higher.

Pervasive PSQL v11 is the latest Itron-supported database engine and is a paid upgrade from older versions. PSQLv11 is the best platform if you are running Windows Vista, Windows 7, or Windows Server 2008. The PSQLv11 software does NOT support running on Windows 2000 or older, so sites with older computers may be forced to upgrade their operating systems first. Users should also obtain the latest patch, indicated above.

Pervasive PSQL Vx Server 11 may be a viable option if you are running a virtual server on VMWare ESX. It uses the same code base as PSQLv11, but with a different licensing mechanism to enable vMotion technology without causing license problems.

Database Engine Support: Here is the table of the versions of PSQL that are supported for use with MV-90 xi as of March, 2012:

Database Engine Version MV-90xi 1.5 MV-90xi 2.0 SP1 MV-90xi 3.0
Pervasive.SQL V8 (8.5, 8.6, 8.7) YES NO NO
Pervasive PSQL v9 YES YES YES (1)
Pervasive PSQL Summit v10 32-bit NO YES YES
Pervasive PSQL v11 32-bit NO Limited YES
Pervasive PSQL v11 64-bit NO NO YES
Pervasive PSQL Vx 32/64-bit NO NO YES

(1) For MV-90 xi v3.0, the free patch to v9.71 Update 4 must be applied.
Users of Windows Vista, Windows 7, or Windows 2008 Server must use PSQLv10.30 or higher.

There are a few points of interest:

  1. Installation Tip: Itron has found a possible conflict with the Cache Engine feature of Pervasive PSQL. After installation of the Workgroup Engine (or the client components in a Server Engine), you should disable the Client-Side Cache feature by following these steps from each computer on your network:
    • Start the Pervasive Control Center (Start/Run/PCC.EXE)
    • On the Welcome screen, click on the option "Configure Microkernel Router".
    • Click on the heading (on the left) for "Performance Tuning".
    • On the right side of the window, Uncheck "Use Cache Engine" to disable the CCE.
    • Click OK or APPLY, exit the PCC, and restart your computer to ensure that the changes take effect.
  2. Performance Tip: If the WGE is used, the machine with the data files physically on it (also called the peer server) should be designated as the permanent gateway using the Gateway Locator Utility. 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!
  3. Performance Tip: If you have a very old system, you may wish to consider upgrading your database files to the v9.5 file format. See our white paper on this topic for more information. If you have a very old database with 5.x files, you may be REQUIRED to rebuild files to maintain compatibility with PSQLv9 or newer.
  4. Status Code 161 After Installation: If you are getting a Status 161 (Licensing Error) after installing Pervasive, then your database license may not be properly applied. Go to the database server and 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 do not see a permanent license with the correct user count, then you will need to apply your license. See your invoice or packing slip for your Registration Keycode, and enter this string into the boxes provided, then click "Add License". You should then see the proper license count. See our License Troubleshooting White Paper for more information.
  5. Problems with Backups on PSQLv10: Some sites have seen some problems when running on PSQLv10 with their backups, since the database engine erroneously holds files open that it should be closing. You may wish to update to v10.13 or higher, or use Continuous Operations Mode or Backup Agent to obtain proper backups.
  6. Moving to a New Server: If you are moving MV-RS to a new server, you may have to adjust the ODBC Client DSN on each workstation. The Database Directory field should point to the correct MV-RS database you wish to connect with. Interestingly, it seems that while the first install leaves a drive letter in this path (which then works if you change servers), subsequent installs drop in a UNC path name instead. When attempting to access the database, it may then hit the old server, even if the drive letter has been mapped to the new server. Modify the DSN to fix this issue.
  7. Status 30: If you get a Status 30, it likely means that you have a Btrieve 6.15 workstation on your computer. Search your ENTIRE computer for WBTRV32.DLL and W32MKDE.EXE and delete any copies older than 1999 or not in the PSQL\BIN folders.
  8. Unable to connect to database. Error Code: 0: If you get this message with MV-RS, it likely indicates that your Merant ODBC driver is unable to connect to the database. First, check to verify that PSQL is installed and functioning correctly, and use the Function Executor to test access to a simple file. Second, verify that the ODBC data source is properly configured. (Be sure to use the 32-bit ODBC Administrator on Win64 machines.) Finally, make sure that the MVRS INI file has the same DSN defined in the sections "Security" and "Database".

If you need help with installing or patching your database engine, Goldstar Software also provides update services via the Internet for a fixed fee. See our Installation Services page for more details. If you are running PeachTree Accounting or other Pervasive applications, then we strongly recommend using our installation services, as PeachTree can make installing a bit more of a challenge.

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-2014, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
  Legal Statements | Privacy Statements | Contact Us