Use the Database VIs and function to access databases from LabVIEW.

With the Database VIs and function, you can perform the most common database tasks, including the following:

  • Work with any provider that adheres to the Microsoft ActiveX Data Object (ADO) standard.
  • Work with any database driver that complies with ODBC or OLE DB.
  • Maintain a high level of portability. In many cases, you can port your application to another database by changing the connection string you pass to the DB Tools Open Connection VI.
  • Convert database column values from native data types to standard LabVIEW Database Connectivity Toolkit data types.
  • Use SQL statements with all supported database systems, including non-SQL systems, using the default ADO ODBC provider.
  • Retrieve the name and data type of a column returned by a SELECT statement.
  • Create tables and select, insert, update, and delete records without using SQL statements.

The VIs and function on this palette can return general LabVIEW error codes.


icon