Error: 0x00001F9 When Using LabVIEW Database Connectivity Toolkit

Updated Jun 28, 2024

Reported In

Software

  • LabVIEW

Issue Details

I have a LabVIEW application that uses the LabVIEW Database Connectivity Toolkit to access a database. When I tried to close the connection to the database, I get the following error:
  • DB Tools Close Connection.vi->insertIntoDatabaseTables.vi->main.vi<ERR>ADO Error: 0x000001F9
    Open command object. Rollback database transaction.

Solution

The error message happens because when you close that connection another VI, a sub VI or possibly another program wants to use the connection. You have to make sure there is no other part in the code that still calls the database. 

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.