I receive error -2146824582 when running code using the 64-bit LabVIEW Database Connectivity Toolkit. The error message says an "Exception occurred in ADODB.Connection: Provider cannot be found." I never received this error when using the 32-bit version of this toolkit.
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.