Frequently Asked Questions
and understanding error messages
".NET Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"
This error is a result of missing data connectivity components from your MS Excel, you will need to download a file from the microsoft website (link below) to run which should resolve this issue. If for whatever reason you don't wish to run this microsoft file on your system, you can just use the .xls import spreadsheet as opposed to the .xlsx file.
Download and install the Microsoft driver from this link: <<Download Microsoft Access Database Engine Driver>>
"Error connecting to Sage. Check login details are correct"
If you're receiving this message, ensure:-
Your Sage software has the Third Party Integration enabled (SDO) - Tools > Activation > Enable Third Party Integration
The username/password being used in the E2S Connector has been setup in Sage
You have the required access to the location of the data ie. if the data is held on a server
If you're using a Mapped Drive letter within the E2S Connector to point to the data, try using either a UNC path, or the ip address of the server. Examples below:-
"Cannot open SETUP.DTA" - showing in the Company Control Tab of the E2S Connector
If you can connect to your Sage data but you're seeing this message in the Company Control Tab against each of your Sage companies, the likelihood is your data is held on another machine, a server, and the E2S Connector cannot find the Sage Company names held in the local registry.
Simply double click in the field and you'll be able to manually key in the names of your Sage companies.
"Data type mismatch in criteria expression"
The data in the field is in the wrong format, the most common is the InvRef field. If you have only entered a number in this field, MS Excel is likely to have formatted the field into a Number format. You must either, prefix your number with an apostrophe ' which makes MS Excel leave the number as text.
We recommend using an alpha-numeric reference for the InvRef field to prevent MS Excel from auto-formatting the field as number.7
"Error obtaining record count zero returned"
In Journals, this will be shown when the NomCode field is not in the expected format. If you do not wish to use the look-up functionality, please prefix the first NomCode number with an apostrophe '.
"Error getting balance check for ref : xxx'xx"
In Journals, this will be shown where the Ref field is not in the expected format. Please ensure that the reference is a Alpha-Numeric, or prefixed with an apostrophe ', but does not contain an apostrophe as part of the reference.
"Error getting data from Excel - Numeric Format"
Refer to the issue above, just as the data type mismatch error, this often relates to the E2S Connector seeing data it doesn't expect in a field, for example a number where it expects to see text.
So just as above, you can either prefix the number with an apostrophe ' or use an alpha-numeric reference which will prevent MS Excel from auto-formatting the field as a number.
TROJAN Warnings - False positives from your Antivirus software, typically Norton/Symantec
The article below from Symantec explains false detections on some software, our E2S software is 100% virus free.
Symantec- Handling and preventing SONAR false positive detections: https://support.symantec.com/en_US/article.HOWTO55273.html
"Sage Data Objects not registered" - Third Party Integration (SDO)
Your Sage software hasn't been enabled for Third Party Integration. Enable your Sage Data Objects (SDO) for Third Party Integration from within Sage, from Tools > Activation > Enable Third Party Integration you will need to contact the number listed here to request the Serial No. and Activation Key from Sage (These are not the same as those received with the product).
You can check to see if your Sage software has Sage Data Objects (SDO) registered by going to Help > About from within Sage under Features Enabled.
Will E2S still work if I upgrade my Sage software?
Not without either selecting the latest version from within the E2S Connector > Configuration tab or downloading the latest version of E2S software should the version not be listed in the Configuration tab.
If you are using E2S Automation, your files may require re-mapping when upgrading.
We strongly recommend informing us of any intended upgrade before upgrading your Sage Software so we can anticipate and schedule any additional work that maybe required to keep your site up and running.
My PC has died and my E2S license key doesn't work on the new PC?
E2S Software licenses are tied to a single machine name, if you rename your new PC with the same name as the old PC your existing license will continue to work.
If you'd like to transfer the license to another machine, depending on how many months remain on your existing license you can do so by purchasing a license transfer from our Online Shop