EXTERNAL DATA DRIVE ERROR
 
Some of the Windows updates are causing problems in Sage Evolution. This results in trouble exporting and importing journals and could cause problems in Sage BIC. Troubleshoot whether this is the error and follow the steps described in the article to rectify.

TROUBLESHOOTING THE ERROR

The error will contain the following error if this issue is causing the problem - 

Unexpected error from external database driver (1)

To fix the error, uninstall the following Windows updates:

Windows 7 SP1 and Windows Server 2008 R2 SP

  • KB4041681
  • KB4041678

 

Windows 8.1 and Windows Server 2012 R2

  • KB4041693 :
  • KB4041687

 

Windows 10 and Windows Server 2016

  • KB4041691
  • KB4041676

For more information, have a look at the following article - 

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