Error -2147287037 Using LabVIEW Database Connectivity Toolkit

Updated Feb 26, 2020

Reported In

Software

  • LabVIEW
  • LabVIEW Database Connectivity Toolkit

Issue Details

I am trying to connect to my database via LabVIEW.
I can use the shipping example called Database Connection VI. but if I change the parameters to connect to my database, I get the error -2147287037

Solution

This error is due to a bitness difference between the Operating Sytem/ LabVIEW version and the provider. To resolve this, you need to :
  1. uninstall the chosen provider (eg: I you have LabVIEW 32b and Provider=Microsoft.ACE.OLEDB.12.0 64b)
  2. Install the right provider with the corresponding bitness (eg: Provider=Microsoft.ACE.OLEDB.12.0 32b)

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.