I receive the following error when running code using the 64-bit LabVIEW Database Connectivity Toolkit. The error does not occur when I use the 32-bit version of this toolkit.Error -2146824582 occurred at Database Connection.viPossible reason(s):ADO Error: 0x800A0E7AException occurred in ADODB.Connection: Provider cannot be found. It may not be properly installed.
The error is related to an incompatbility between the database provider and LabVIEW.LabVIEW 64-bit installs the 64-bit Database Connectivity Toolkit starting with the 2019 release. This is compatible with the Microsoft Office 12.0 Access Database Engine OLEDB Provider, which is not installed with Windows by default.You can obtain this provider by installing the External Link: Microsoft Access Database Engine 2010 Redistributable. Note you must first uninstall the 32-bit provider or uninstall the 32-bit Microsoft Office installation which contains this provider. Otherwise you may receive an error like the one shown below.
Collaborate with other users in our discussion forums
A valid service agreement may be required, and support options vary by country.