[en] This error message appears only on 64-bit Windows operating systems.
[en] In Automation:
[en] The error message pops up when you use any of the following in your Automation configuration to connect to the Microsoft Access database:
-
[en] Database trigger
-
[en] Action Execute SQL Statement
-
[en] Database connection on the label
[en] You are able to test your configuration in Automation Builder, but you see the error message in Automation Manager:
Error connecting to the database. Cannot connect to database
System error message: The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine.
[en] Automation Builder runs as a 32-bit application. Automation Manager is the user interface to Automation Service that does all processing in the background. The service runs as a 32-bit application on 32-bit Windows systems and as a 64-bit application on 64-bit systems.
[en] In Desktop Designer:
[en] You try connecting your label to Excel or Access database and get the error message above.
[en] 32-bit and 64-bit applications require appropriate drivers to access database sources. If you receive the error message above, your system doesn't have the necessary 64-bit database drivers installed. 64-bit service cannot open a connection to the database.
[en] The Microsoft.Jet.OLEDB.4.0 provider is not available as a 64-bit component, it was only developed as a 32-bit component.
[en] To solve the problem:
-
[en] Install 64-bit drivers to access your database. Microsoft Access 64-bit drivers are available for download from Microsoft Web site.
[en] For more information, see the NiceLabel Knowledge base article Connectivity to Office documents on 64 bit platforms.
-
[en] The package doesn't contain Microsoft.Jet.OLEDB.4.0 provider. Instead, it installs the OLE DB provider with the name Microsoft Office 12.0 Access Database Engine OLE DB Provider. This provider is available as a 32-bit and as a 64-bit component. You can use the same provider in NiceLabel Designer Pro and Automation Builder (both are 32-bit applications), and in Automation Service (64-bit application).
[en] Note: if you installed Microsoft Access 2013 Runtime, you see a newer version of the OLE DB provider, named Microsoft Office 15.0 Access Database Engine OLE DB Provider.
-
[en] Change the connection string in every database connection to the Microsoft Access database on your labels, in the database triggers, or in the Execute SQL Statement actions.
[en] Make sure that you use the Microsoft Office 12.0 Access Database Engine OLE DB Provider:
[en] Selecting the new database provider doesn't change any other setting made to the connection, such as the selection of the fields, or optional filter definition.