Knowledge Base

Connectivity to Office documents on 64 bit platforms

Problem

Before you can use data from Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files in NiceLabel software, you must have installed appropriate database drivers to access data. If you have Microsoft Office already installed, you should be fine, because the drivers have been installed with the product.

If you don't have Microsoft Office installed, you must install database drivers yourself. Microsoft offers the "runtime/redistributable" packages for download. Microsoft Access Database Engine 2010 Redistributable for download. The same redistributable packages are available on NiceLabel DVD. Installing this software will add the necessary ODBC and OLE DB drivers. The redistributable package exists in two flavors, as 32-bit and 64-bit installation. The version you would install depends on the application that will connect to the Office data files.

You can download the database drivers from Microsoft:

Solution

When to choose 32-bit or 64-bit version of Microsoft Access Database Engine 2010 Redistributable?

If you have 32-bit system, all NiceLabel products will run in 32-bit mode. You can only install 32-bit version of Database Engine.

If you have 64-bit system, then majority of NiceLabel applications will still run in 32-bit mode, but same switch to 64-bit mode. For example, NiceLabel Automation service will run as 64-bit application. This is important for database connectivity. Automation Builder (the application to configure your trigger) always runs as 32-bit application, while Automation service auto-determines the Windows system version and runs as 32-bit or 64-bit. When you test your triggers in Automation Builder, they might not function the same in Automation service, because service will use 64-bit database drivers. All other NiceLabel applications will still run in 32-bit mode.

For this reason, you must install 64-bit version of the Database Engine on the machine that has NiceLabel Automation service installed. Please also read the following questions.

What can I do to use NiceLabel designers and Automation service on the same machine?

When you use the same machine to design your labels in NiceLabel Pro, configure triggers in Automation Builder and execute triggers in Automation service, you must have installed support for 32-bit and 64-bit database drivers. Designers always run as 32-bit applications, while Automation service runs as 64-bit process in 64-bit Windows.

In other words, designers need 32-bit database drivers, while Automation service needs 64-bit database drivers.

In order to have both database drivers installed on the same system, you must have Microsoft Office installed. It doesn't matter which version of Microsoft Office you have, it can be 32-bit or 64-bit. The key point is that you install Microsoft Access Database Engine 2010 Redistributable of the opposite "bitness". If you have 32-bit Microsoft Office, then install Microsoft Access Database Engine 2010 Redistributable 64-bit and vice-versa.

Make sure to install Microsoft Access Database Engine 2010 Redistributable with the command-line parameter /passive, such as:

AccessDatabaseEngine.exe /passive
AccessDatabaseEngine_X64.exe /passive

Also read the next question.

Can I install Microsoft Access Database Engine 2010 Redistributable 32-bit and 64-bit on the same machine to bypass need to install Microsoft Office?

No, you cannot have Microsoft Access Database Engine 2010 Redistributable 32-bit and 64-bit installed on the same machine.

To have support for 32-bit and 64-bit Office database drivers, you must install Microsoft Office and Microsoft Access Database Engine 2010 Redistributable of the opposite "bitness".

I have Microsoft Office 2013 installed. Can I couple it with Microsoft Access Database Engine 2010 Redistributable?

While it is technically possible to install Office 2013 and Database Engine 2010, the drivers will install with different versions.

When you use 32-bit designers to create labels or Automation configuration, the connection string also encodes the version of data provider. For example, database drivers for Office 2007 install as version 10.0, for Office 2010 they install as version 12.0, for Office 2013 they install as version 15.0.

If you have Office 2013 32-bit installed, the designers will encode version 15.0 in the connection string. If you install Database Engine 2010 64-bit, the Automation service will seek provider version 15.0, but only 12.0 will be available as 64-bit provider.

Print document   Email document

Feedback

Did this article help you? *