Connection to Excel .XLS data sources fails when using Microsoft Jet 4.0 OLE DB Provider
Article ID: 293 - Updated: Oct 17, 2017 - Version: Any - Category: Fixed Issues
When you use NiceLabel to connect to Excel .XLS type of data files, NiceLabel will use database driver "Microsoft Jet 4.0 OLE DB Provider" by default. After October 10, 2017, you might not be able to connect to such data sources anymore.
NOTE: Connection to .XLSX type of Excel file is unaffected.
The following would happen in NiceLabel software:
- NiceLabel V2017. You would see the system error message "Unexpected error from external database driver (1)."
- NiceLabel V6. You would see the "Database Login" dialog box, prompting you for the user name and password.
Windows updates from October 10, 2017 are a culprit for this problem.
We have reported the problem to Microsoft and are working with them to resolve the problem.
This workaround is applicable in NiceLabel V2017 and NiceLabel V6.
Remove the Windows update that causes the problem. Find the update id for your Windows system in the list below and remove it.
- Windows 10 1703: KB4041676
- Windows 10 1607 and Windows Server 2016: KB4041691
- Windows 10 1507: KB4042895
- Windows 8.1 and Windows Server 2012 R2: KB4041693
- Windows Server 2012: KB4041690
- Windows 7 and Windows Server 2008 R2: KB4041681 and KB4041678
To remove the update, do the following:
- Open Control Panel.
- Navigate to Programs and Features>Installed Updates.
- Find the update with the KB number in its description.
- Click Uninstall.
Then make sure to temporary disable automatic updates, or Windows will install the update again at next update check. If you do now know how to change the update mode, read this article for details.
This workaround is applicable only in NiceLabel V2017.
By default, NiceLabel uses JET provider as default provider for .XLS data sources. You can also use ACE provider to get data from .XLS files and circumvent the problem.
Change the driver from "Microsoft Jet 4.0 OLE DB Provider" (JET) to "Microsoft Office XX.0 Access Database engine OLE DB Provider" (ACE) (XX represents a version number of your database provider).
You will have to open all labels using .XLS Excel data sources and reconnect to them using ACE provider. This will require more time investment from your side, based on the number of label templates you have.
The ACE provider is installed with Microsoft Office products, but can also be installed separately, if needed (you can download it from Microsoft). You can install either 32-bit or 64-bit ACE provider, NiceLabel 2017 will use the one you have installed.