Schulz Consulting

Consulting and Upgrades

Sage Intelligence Not Compatible with the 64-bit version of Sage 100 2021

by

Sage 100 version 2021 for the first time is available in both 32-bit and 64-bit versions. The difference between the versions is largely for compatibility with applications that might integrate to Sage 100 and require 64-bit technology.

There does not at this time appear to be much reason to install the 64-bit version and I expect most users wil upgrade to the 32-bit release. And it’s worth noting that you cannot install both the 32-bit and 64-bit versions on the same computer. Sage offers a conversion utility for version 2021 users who may need to switch to ( or from ) the 64-bit Sage 100 version.

However, it bears note that should you decide to install the 64-bit version of Sage 100 that you review the 2021 Integrated Solutions Compatibility Matrices ( ISCM ) .

The latest ISCM for Sage 100 2021 notes that Sage Intelligence reporting does not support the 64-bit version of Sage 100 although it does support either 32-bit or 64-bit versions of Microsoft Excel ( desktop only ).

Review the most current Integrated Solutions Compatibility Matrix for Sage 100 version 2021 on the Sage website here.

As of May 2021 Sage 100 versions 2019, 2020 and 2021 are officially supported by Sage.

How to run or install FRX 6.7 for Sage 100 ERP (fka Sage ERP MAS90 or 200) with a 64 Bit OS (SOLVED)

by

As more customers have adopted 64 bit operating systems they’ve found that one of their core financial reporting tools – FRX –  has refused to install. Even though Microsoft will stop the support and upgrades for FRX on December 31, 2012 the product is for all purposes already a lame duck.

If you’ve recently updated workstations and tried to load FRX for your Sage 100 ERP (formerly Sage ERP MAS 90 or 200) you may have found that you can load the FRX just fine but when you go to print the report you receive an error “Unable to process this output request for the following reason: C:\Windows\System32\Msxml.dll could not be found…”.

If you follow the suggestion and try to register the msxml.dll in the System32 you’ll receive a failure message.

The solution for most people has been to copy the DLL into the sysWOW64 and then use RegSRV32 to register it from that folder.

Double check the msxml DLL version as the one which has reportedly been working for most people is 8.0.5226. If you check the DLL version on your computer and it’s earlier than 8.0.5226 then try downloading and installing service pack 11 for FRX for Sage 100 ERP.

Here’s my 90 Minds KB entry for getting FRX to work under a 64-bit Windows operating system

Version(s): 4.x

Problem / Description:

FRX version 6.5+ will not usually install on 64 bit Windows OS. An error message may occur when trying to register msxml.dll from the System32 (as the Sage KB directs)

 

Resolution:

NOTE: Installing the below fix (registering MSXML) appears to get the FRX system running. Makie sure you have the latest FRX SP 11.

 

A. Install and register the 64 bit (put this in syswow64) using Regsvr (see attached file) v8.0.5226

After registering (used Regsvr32) I received:

“Runtime error -2147220503( 800403E9) fatal error language database (path)/FRxXML4.dll not found” when launching FRx

Resolution:
Register the .DLL files on the workstation.

In Window’s Explorer, go to the FRx program file directory.
Double-click on FRxReg.exe.
Date Created: 8/27/12
Created By: Wayne Schulz
Source: SC
Updated:

 

Source: 90 Minds Consulting Group

64 Bit ODBC and Sage 100 ERP (Formerly Sage ERP MAS 90 and 200)

by

An interesting question was just asked on the MAS 90 LinkedIn Group. One of the users posed the question:

When a customer has 64-bit OS systems, they naturally want to install 64-bit versions of MS Office. All seems fine until one decides to connect to their 32-bit ODBC and are greeted by the “Specified DSN contains and architecture mismatch”. This happened to me – from a 64-bit version of Excel running on a 64-bit OS, selected Data, Other Sources and then selected SOTAMAS90*. (Note the asterisk). Once selected the message displays about the mismatch.

Is there any way around this? It seems that you need a method to tell the 64-bit programs that when they want to use a specific 32-bit ODBC they need to go through SYSWOW64 and call the ODBCAD.EXE. However, I’ve not found any options to force it to the 32-bit ODBC.

 

The short answer is that 64 bit ODBC drivers are not yet available for Sage 100 ERP .

What most users have done is uninstall any 64 bit apps (usually Microsoft Office 64 Bit) and installing their 32 bit versions.

Our 90 Minds Consulting Group has been tracking this issue since August 2011 and have the following feedback:

 

– Might be able to in MAS 5.0 but probably pushed to 5.1
– PVX Plus may have a 64 bit ODBC to offer (for a fee) at some point (I think they’re testing)

The present resolution has been to uninstall 64 bit Microsoft and install 32 bit.

Would gladly welcome updates from anyone with different workarounds.

 

UPDATE: The 64 Bit ODBC Drivers are available from PVX Plus per the following post on the MAS90 LinkedIN group:

 

 

The driver could be installed on select workstations. If a workstation needed both the 32 Bit and 64 Bit they would have to have different DSNs (logical Data set name) in order to have the system identify which driver to use.
To order the driver you can contact sales@pvxplus.com or call us at 1-888-975-7587 and press 1 for sales.If you want to give it a try it can be downloaded from
http://www.pvxplus.com/pgsrvr.pvp?pg=dl_optional
(select the 64 bit version — second from the top). It should work using a key of DEMO for testing.

MAS 90 Paperless Office Updated for 64 Bit Environments [Links]

by

Sage today released a pair of hot fixes to enable printing to MAS90 Paperless Office on Windows 7 or Windows Server 2008 64-bit due to incompatible PDF Driver.

The patches are now available in the Sage Partner File center at the following link. Expect to see similar fixes for Extended Enterprise Suite 1.3. and 1.4 shortly:

Version 4.4 of MAS 90 and MAS 200:
LM4045-T: Enable printing to paperless office under Windows 7 or Windows Server 2008 64-Bit

Version 4.3 of MAS 90 and MAS 200:

Note: According to Sage you must be on Service Update 18 to install the patch below

Enable printing to paperless office under Windows 7 or Windows Server 2008

Via: Sage Product Suggestion Completion List

MAS90 & MAS200 Official Windows 7 Compatibility Chart – February 2010

by

Sage has just published their official Windows 7 compatibility chart. Based on the document it appears that the MAS 90 product line (Sage MAS90, MAS200 and Sage MAS 200 Extended Enterprise) will become Windows 7 compatible sometime on or about March 2010.

Although the document conveniently omits stating whether the compatibility will be with 32-bit or 64-bit Windows 7 versions – we recommend sticking with 32-bit for the time being.

Sage MAS90, MAS200, MAS500, Accpac Windows 7 Compatibility Announcement

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.