Error -2147318113 when opening a connection with LabVIEW Database Connectivity Toolkit

Updated Apr 2, 2019

Reported In

Software

  • LabVIEW
  • LabVIEW Database Connectivity Toolkit

Operating System

  • Windows

Issue Details

When trying to access a Microsoft Access database (.mdb) in LabVIEW using the Database Connectivity Toolkit the following error shows at the moment of opening a connection:
 



The error source can be traced to an ActiveX invoke node inside of the subVI DB Tools Open Connect (String) which is inside of the VI DB Tools Open Connect

Solution

When oppening a database connection to Microsoft Access multiple details have to be fed to the open VI "Open Connect". One of those details is the driver that will be used to access the database. To fix this issue you will need to change the driver being used in the UDL or DSN file. Switch from:
 

Microsoft Access Driver (*.mdb, *.accdb)

to

Microsoft Access Driver (*.mdb)


One detail of this workaround is that it is necessary to change any .accdb database to .mdb for it to work correctly.


 

Additional Information

This is an ODBC driver issue that is related to the Microsoft Access Database Engine and it has been reported in isolated cases when using versions between 12.0 and 16.0 of the driver. To find out what ODBC driver is currently installed go to the Windows resource ODBC Data Sources (32-bits). When open head over to the drivers tab and look for the version under Microsoft Access Driver.

 

WAS THIS ARTICLE HELPFUL?

Not Helpful