3305 Main Street Ste 019 Vancouver, WA 98663

Featured

slide

An Error Occurred While Attempting To Retrieve The List of Sage 100 Contractor Databases From The Server

Scenario When migrating from Sage 100 Contractor 2014 (version 19.x) to 2016 (version 20.x), the underlying database framework changes to Microsoft SQL Server. As there are considerable differences between the previous underlying database framework, Fox Pro, and Microsoft SQL Server, there are certain configurations which can result in the following […]
slide

Compatibility with Sage 300 CRE v16.1

Software Compatibility Alert Some or all of the functionality of the following products may be disabled by the installation of Sage 300 CRE v16.1 REV 4 This article describes the nature of the issues and their resolutions. If you intend to upgrade to v16.1, please read this article thoroughly before […]
slide

How can I identify the installed version of the Sage 300 CRE ODBC Driver?

Background The Sage 300 CRE ODBC driver is installed as part of the Sage 300 CRE workstation or server install. Updates and hotfixes to Sage 300 CRE may include newer versions of the driver. Depending on specific issues that may be addressed by a given update, it may be important […]
slide

Add Trusted Locations To Microsoft Excel

Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]
slide

Add Event 1 Software, Inc. to Microsoft’s Trusted Publishers

Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]
slide

Anti-virus Policy Update Damages Office Connector and Liberty Reports .xla File

Background When using Sage Office Connector or Liberty Reports with certain anti-virus applications, a recent security policy update marks the Office Connector.xla or LR.xla file as dangerous and attempts to quarantine/disinfect/remove the file. Problem Office Connector.xla and LR.xla provide the main functionality for Office Connector and Liberty Reports. Once either […]
slide

Liberty Reports shows ‘invalid data drive’ message when trying to connect

Background Liberty Reports for Sage 100 Contractor uses the Sage 100 Contractor API when working with a Sage 100 Contractor database of version 19 or prior. The API is used to populate the list of known databases for use with Liberty Reports and is also used to validate login credentials. […]
slide

How to access a Sage 100 Contractor SQL database with Liberty Reports

Background Beginning with Sage 100 Contractor version 20, Microsoft SQL Server is now used for the underlying database that stores your Sage 100 Contractor data. Liberty Reports automatically adds databases to the list of known databases with Sage 100 Contractor version 19 and prior. This functionality is not possible with […]
slide

Does Liberty Reports for Sage 100 Contractor support the SQL Server Version?

Background The purpose of this article is to make you aware of the status of Liberty Reports as is relates to compatibility with Sage 100 Contractor v20 (the SQL release). As you may already be aware, the release of Sage 100 Contractor v20 is an extensive upgrade because the underlying […]
slide

Why is my Liberty Reports Add-in unresponsive?

Symptom After opening Microsoft Excel, clicking any part of the Liberty Reports Add-in results in no action taken. Re-installing Liberty Reports does not change this behavior. The following possible Cause & Resolution could relate to the following versions of Excel: Excel 2007 Excel 2010 Excel 2013 Excel 2016 Cause & […]