Error -2146824582 When Using LabVIEW Database Connectivity Toolkit 64-Bit

Issue Details

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.

 

Solution

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.

 

Additional Information

This error also occurs if you install a Database component with a different bitness compared to that of LabVIEW. If you are going to use Oracle and install OLE DB Provider for Oracle, the bitness of the provider should be the same as that of LabVIEW regardless of your operating system bitness. For example, if you are using LabVIEW 32-bit, then the bitness of OLE DB Provider for Oracle you have to install is 32-bit version even if the operating system is 64-bit.

The 32-bit Database Connectivity Toolkit uses the Microsoft Jet 4.0 OLEDB Provider. This provider is typically installed with Windows by default. There is no 64-bit version of this provider.