Skip to content
+1-888-319-3663

HELP ARTICLE

Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error.


Attempting to run SmartConnect maps using Excel as a datasource.  Maps have been working fine until recently when all my Excel maps starting giving the error that says, “Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error.”  Double clicking on the error results in additional information that looks like this.



How to resolve this error?

This error is caused by a recent set of Windows updates that breaks ODBC connectivity for Excel.  We are hoping that Microsoft releases a fix for this soon, however until that time the only solution is to uninstall specific Windows updates depending on the operating system.  Following is a list of the updates that need to be uninstalled.  After uninstalling the updates, you will need to reboot the machine.  After the reboot the maps will function correctly again.  

Windows 7 SP1 and Windows Server 2008 R2 SP

  • KB4041678 — 2017-10 Security Only Quality Update for Windows Embedded Standard 7 for x64-based Systems
  • KB4041681— 2017-10 Security Monthly Quality Rollup for Windows 7 for x86-based Systems
  • KB4041686 — 2017-10 Preview of Month Quality Rollup for Windows Embedded Standard 7 for x64-based Systems

Windows 8.1 and Windows Server 2012 R2

  • KB4041687 — 2017-10 Security Only Quality Update for Windows 8.1 for x86-based Systems
  • KB4041693 — 2017-10 Security Monthly Quality Rollup for Windows 8.1 for x86-based Systems

Windows 10 and Windows Server 2016 (version 1607)

  • KB4041691— 2017-10  Cumulative Update for Windows 10 Version 1607 and Windows Server 2016

Windows 10 and Windows Server 2016 (version 1703)

  • KB4041676 — 2017-10 Cumulative Update for Windows 10 Version 1703

If you need assistance uninstalling Windows updates, you can search for “How to uninstall Windows Updates” in your favorite search engine.  One article I found while searching is here: How to remove installed Windows Updates and block them afterwards.

RECENT POSTS


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.

POPULAR POSTS


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.