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


Configuring Salesforce Integration User
Business Central Extension Publish Error
Re-registering a Change Data Source in Business Central on SmartConnect.com
Moving SmartConnect 21 to a new server
eConnect error 4628 - The Tracking Number (Tracking_Number) is empty

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 Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce Salesforce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.