Is the LabVIEW Database Connectivity Toolkit Compatible With IBM DB2?

Updated Aug 11, 2023

Reported In

Software

  • LabVIEW Database Connectivity Toolkit

Issue Details

I need to access my database (IBM DB2 server), with LabVIEW, but I don't know,if I can using the Toolkit connectivity database tools. Is this possible?

Solution

The best and easiest way to perform database connection and operations in LabVIEW is by using the LabVIEW Database and Connectivity Toolkit. This comes with a simple API that allows for the creation of routines that work with the most popular databases. These include:
  • Microsoft Access
  • SQL Server
  • Oracle
The Database and Connectivity Toolkit also provides a set of advanced functions to access low level operations. According to the LabVIEW 2020 Database Connectivity Toolkit Readme, this toolkit works with any database or data source that has ODBC or OLE DB drivers.

IBM DB2 is ODBC (Open Database Connectivity) compliant. Therefore, the LabVIEW Database and Connectivity Toolkit can be used to access IBM DB2.
 

Additional Information

Also, it looks like there is also ADO (ActiveX Data Objects) to connect to the database according to the IVM documentation: Using ADO to connect to an IBM DB2, Microsoft SQL Server or Oracle 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.