The Database Connectivity API contains a set of nodes with which you can perform both common database tasks and advanced customized tasks.
- Works with any provider that adheres to the Microsoft ActiveX Data Object (ADO) standard.
- Works with any database driver that complies with Open Database Connectivity (ODBC) or Object Linking and Embedding Database (OLE DB) protocols.
- Maintains a high level of portability. In many cases, you can port an application to another database by changing the connection information you pass to the
Open Connection
node.
- Converts database column values from native data types to standard LabVIEW NXG data types, further enhancing portability.
- Permits the use of SQL statements with all supported database systems, even non-SQL systems.
- Creates tables and selects, inserts, updates, and deletes records without using SQL statements.