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

Issue Details

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.vi
Possible reason(s):
ADO Error: 0x800A0E7A
Exception occurred in ADODB.Connection: Provider cannot be found. It may not be properly installed. 

 

Solution

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.

 

Additional Information

This error also occurs if you install a Database component with a different bitness compared to that of LabVIEW. The following examples show this: 

1. If you use LabVIEW 32-bit to access Oracle, install OLE DB Provider for Oracle in 32-bit (NI recommends using the Oracle Provider for OLE DB 8.1.6.2.0 or later).
2. If you use LabVIEW 32-bit to access a SQL database, please install SQL Server Native Client in 32-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.