Is It Possible to Connect to Multiple Databases at Once Using LabVIEW?

Updated Mar 9, 2021

Reported In

Software

  • LabVIEW Database Connectivity Toolkit
  • LabVIEW

Issue Details

Is it possible to read/write data to multiple databases simultaneously using the LabVIEW Database Connectivity Toolkit?

Solution

The LabVIEW Database Connectivity Toolkit supports multiple simultaneous connections to a single database or to multiple databases. You can use the DB Tools Open Connection (VI) to establish the connection to a database. This can be done several times to connect to different databases, with the restriction that it will only allow one connection to the same database. If you try to use a database from multiple instances of the same application either on the same computer or on different computers you will receive an error message.

If you want to insert data to the databases using the DB Tools Insert Data (VI) you can use the same data but you would need to use separate VIs for each one of the databases, since the connection reference terminal can only be used with a single reference to the ADO Connection Object.