{"id":3286,"date":"2017-10-13T07:53:30","date_gmt":"2017-10-13T07:53:30","guid":{"rendered":"http:\/\/www.csidata.com\/?p=3286"},"modified":"2017-10-13T12:41:14","modified_gmt":"2017-10-13T12:41:14","slug":"ua-excel-unexpected-error-from-external-database-driver-1","status":"publish","type":"post","link":"https:\/\/www.csidata.com\/?p=3286","title":{"rendered":"UA Excel Unexpected error from external database driver (1)"},"content":{"rendered":"<p>One or more of the latest Microsoft Windows Security Updates has interfered with the<br \/>\nfunctioning of the Microsoft Excel ODBC Driver that is used by UA to manage Excel export<br \/>\nfiles. We have confirmed this is an issue with Microsoft, and that they&#8217;ve been<br \/>\nnotified. The only way for us to handle this for now is to uninstall their security update.<br \/>\nThis can be done from your Control Panel&#8217;s <strong>Program and Features<\/strong> interface.<br \/>\nGo there and click<strong> View Installed updates<\/strong>. Locate one of the following updates,<br \/>\nselect it and click <strong>Uninstall<\/strong>. Your system will run through the uninstall process and<br \/>\nprompt you to reboot.  After this is done, your Excel export files can then again<br \/>\nbe managed properly. <\/p>\n<p>Security Update for Microsoft Windows<br \/>\n<strong>KB4041681<\/strong> &#8212; Windows 7 and Windows Server 2008 R2<br \/>\n<strong>KB4041693<\/strong> &#8212; Windows 8.1 and Windows Server 2012<br \/>\n<strong>KB4041691<\/strong> &#8212; Windows 10 Version 1607 and Windows Server 2016<br \/>\n<strong>KB4041676<\/strong> &#8212; Windows 10 Version 1703<\/p>\n<p>Hopefully Microsoft will not issue this problem back into our systems.<br \/>\nFollow this link to see more on the Microsoft Developer Network:<br \/>\n<a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/en-US\/2feac7ff-3fbd-4d46-afdc-65341762f753\/odbc-excel-driver-stopped-working-with-unexpected-error-from-external-database-driver-1?forum=sqldataaccess\">MSDN Topic of Discussion<\/a><\/p>\n<p>A new upgrade to UA will be forthcoming that uses a newer OLEDB driver that is not susceptible to this problem.  Check our upgrade page for release Build 408: <a href=\"http:\/\/www.csidata.com\/?p=2651\">UA Upgrades<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>One or more of the latest Microsoft Windows Security Updates has interfered with the functioning of the Microsoft Excel ODBC Driver that is used by UA to manage Excel export files. We have confirmed this is an issue with Microsoft, and that they&#8217;ve been notified. The only way for us to handle this for now [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/posts\/3286"}],"collection":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3286"}],"version-history":[{"count":10,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/posts\/3286\/revisions"}],"predecessor-version":[{"id":3296,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/posts\/3286\/revisions\/3296"}],"wp:attachment":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}