Log in screen appears when accessing a Database with ZebraDesigner Pro

Article ID: 13708341

Issue / Question

When you use ZebraDeasigner to connect to Excel .XLS type data files, ZebraDesigner 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 files are not affected.

The following would happen in the ZebraDesigner software:

You would see the "Database Login" dialog box, prompting you for the user name and password.

Windows updates from October 10, 2017 are the cause of this issue.

Applicable To

ZebraDesigner Software being connected to database

Resolution / Answer

Symptom

User is prompted to login when connecting to a Database in ZebraDesigner Pro. If the login dialog is closed and user tries to progress through the wizard, an error may occur stating that the table cannot be opened


If you cancel the login window you get the following error


Solution

Workaround 1

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:
1.      Open Control Panel.
2.      Navigate to Programs and Features>Installed Updates.
3.      Find the update with the KB number in its description.
4.      Click Uninstall.
Then make sure to temporary disable automatic updates, or Windows will install the update again at next update check.


Workaround 2

Open the .XLS file and save it as a .XLSX file type and connect to that file as that file type does not use the affected JET database driver.

The database driver for the .XLSX file type is installed with Microsoft Office products, but can also be installed separately, if needed.
Download Microsoft Access Database Engine 2016 Redistributable

Download Microsoft Access Database Engine 2010 Redistributable

 

Cause or Overview

This issue is typically caused by the system not having appropriate drivers to facilitate data transfer between Microsoft Office System files and non-Microsoft Office applications (in our case ZebraDesigner). The likely scenario is that 64bit version of MS Office is installed on a 64bit OS and therefore no 32bit drivers exist on the system to support ZebraDesigner which is a 32bit application

Solution

The solution is to install 32bit drivers on the system. This is done by installing the Microsoft Access Database Engine Redistributable files.
The redistributable files can be downloaded from the following link Read More>>

Install them using the /passive switch to allow the 32bit drivers on the 64bit system:

Steps

1.  Get to a DOS prompt

2.  Navigate to the directory where you saved the AccessDatabaseEngine.exe file

3.  At the DOS prompt type - 

               AccessDatabaseEngine.exe /passive

Once the installation completes, you should then be able to connect to the Database successfully in ZebraDesigner Pro. The login dialog should not appear. 

Note:  Microsoft Access Database Engine 2013 Redistributable files are not currently available but will be in the future. Installing Microsoft Access Database Engine 2010 Redistributable will work for MS Office 2013.

Note:  The steps above have also been tested and proven to work for anyone using Office 2016

Helpful information

ZebraDesigner Pro v2 Connecting to Database  Read More>>