{"id":9937,"date":"2017-10-17T08:30:24","date_gmt":"2017-10-17T16:30:24","guid":{"rendered":"http:\/\/www.palada.net\/index.php\/2017\/10\/17\/news-3710\/"},"modified":"2017-10-17T08:30:24","modified_gmt":"2017-10-17T16:30:24","slug":"news-3710","status":"publish","type":"post","link":"http:\/\/www.palada.net\/index.php\/2017\/10\/17\/news-3710\/","title":{"rendered":"Excel, Access, external DB driver errors linked to this month\u2019s patches"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/images.techhive.com\/images\/article\/2015\/09\/thinkstockphotos-491144069-100611739-primary.idge.jpg\"\/><\/p>\n<p><strong>Credit to Author: Woody Leonhard| Date: Tue, 17 Oct 2017 08:08:00 -0700<\/strong><\/p>\n<p>I\u2019m seeing <a href=\"https:\/\/stackoverflow.com\/questions\/46707245\/odbc-excel-driver-unexpected-error-from-external-database-driver\" rel=\"nofollow\">many reports<\/a>, in <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/45ebe780-967e-4748-a146-9ec7a15626dc\/unexpected-error-from-external-database-driver-1?forum=itmanager\" rel=\"nofollow\">various locations<\/a>, about this month\u2019s Windows security patches breaking custom programs that import and export Excel XLS files. Programs that have worked for years are suddenly, mysteriously, turning belly-up. The most common symptom is an error message that says \u201cUnexpected error from external database driver\u201d followed by a number.<\/p>\n<p>There\u2019s no mention of the error in any KB article that I can find, and it isn\u2019t listed on the <a href=\"https:\/\/support.office.com\/en-us\/article\/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093?ui=en-US&amp;rs=en-US&amp;ad=US\" rel=\"nofollow\">Fixes or workarounds for recent issues in Excel for Windows<\/a> site. Either Microsoft isn&#8217;t aware of the problem, or it isn&#8217;t commenting on it.<\/p>\n<p>On the <a href=\"https:\/\/stackoverflow.com\/questions\/46706128\/odbc-export-to-excel-fails-under-windows-7-windows-8-x-and-windows-10?noredirect=1#comment80459537_46706128\" rel=\"nofollow\">Stack Overflow site<\/a>, poster xMRi states:<\/p>\n<p>The problem arises in fact due to a bug in the security updates. Currently I see no other solution than to uninstall, the security patch or using another export format. Affected patches are:<\/p>\n<p>KB4041681 \u2014 2017-10 Security Monthly Quality Rollup for Windows 7 for x86-based Systems<\/p>\n<p>KB4041678 \u2014 2017-10 Security Only Quality Update for Windows Embedded Standard 7 for x64-based Systems<\/p>\n<p>KB4041693 \u2014 2017-10 Security Monthly Quality Rollup for Windows 8.1 for x86-based Systems<\/p>\n<p>KB4041687 \u2014 2017-10 Security Only Quality Update for Windows 8.1 for x86-based Systems<\/p>\n<p>KB4041691 \u2014 2017-10 Cumulative Update for Windows 10 Version 1607 and Windows Server 2016<\/p>\n<p>KB4041676 \u2014 2017-10 Cumulative Update for Windows 10 Version 1703<\/p>\n<p>There are many proposed solutions. Two of them seem to work, at least for most of the people. The easiest (and most reliable) solution is to simply uninstall the appropriate October Windows update.<\/p>\n<p>The other approach is a bit more complex \u2014 and hard to explain.<\/p>\n<p>According to fred.schulz on the <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/55b1d633-b715-491e-917e-b7cb01ae0523\/error-in-windows-update-kb4041681-unexpected-error-from-external-database-driver-1?forum=sqldataaccess\" rel=\"nofollow\">Technet forum<\/a>, who credits a thread on the <a href=\"https:\/\/community.embarcadero.com\/forum\" rel=\"nofollow\">Embarcadero forum<\/a>, some (or all) of those Windows updates install version 4.0.9801.1 of msexcl40.dll. (No explanation why a Windows security patch would install a new version of the Excel runtime, but, hey, this is Microsoft.) Apparently that\u2019s at the core of the problem. Schulz\u2019s solution:<\/p>\n<p>Thanks to reader RD.<\/p>\n<p><em>Have a better solution \u2014 or explanation? Join us on the <a href=\"https:\/\/askwoody.com\/2017\/unexpected-error-from-external-database-driver-error-messages-in-excel-access-odbc-cause-by-this-months-windows-patches\/\" rel=\"nofollow\">AskWoody Lounge<\/a>.<\/em><\/p>\n<p><a href=\"https:\/\/www.computerworld.com\/article\/3233260\/microsoft-windows\/excel-access-external-db-driver-errors-linked-to-this-month-s-patches.html#tk.rss_security\" target=\"bwo\" >http:\/\/www.computerworld.com\/category\/security\/index.rss<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/images.techhive.com\/images\/article\/2015\/09\/thinkstockphotos-491144069-100611739-primary.idge.jpg\"\/><\/p>\n<p><strong>Credit to Author: Woody Leonhard| Date: Tue, 17 Oct 2017 08:08:00 -0700<\/strong><\/p>\n<article>\n<section class=\"page\">\n<p>I\u2019m seeing <a href=\"https:\/\/stackoverflow.com\/questions\/46707245\/odbc-excel-driver-unexpected-error-from-external-database-driver\" rel=\"nofollow\">many reports<\/a>, in <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/45ebe780-967e-4748-a146-9ec7a15626dc\/unexpected-error-from-external-database-driver-1?forum=itmanager\" rel=\"nofollow\">various locations<\/a>, about this month\u2019s Windows security patches breaking custom programs that import and export Excel XLS files. Programs that have worked for years are suddenly, mysteriously, turning belly-up. The most common symptom is an error message that says \u201cUnexpected error from external database driver\u201d followed by a number.<\/p>\n<p class=\"jumpTag\"><a href=\"\/article\/3233260\/microsoft-windows\/excel-access-external-db-driver-errors-linked-to-this-month-s-patches.html#jump\">To read this article in full or to leave a comment, please click here<\/a><\/p>\n<\/section>\n<\/article>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[11062,10643],"tags":[714,10525],"class_list":["post-9937","post","type-post","status-publish","format-standard","hentry","category-computerworld","category-independent","tag-security","tag-windows"],"_links":{"self":[{"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/posts\/9937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/comments?post=9937"}],"version-history":[{"count":0,"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/posts\/9937\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/media?parent=9937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/categories?post=9937"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.palada.net\/index.php\/wp-json\/wp\/v2\/tags?post=9937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}