What Connector is Needed by LabVIEW to Communicate with MySQL Server?

Updated Aug 30, 2024

Reported In

Software

  • LabVIEW
  • Database Connectivity Toolkit

Issue Details

I would like to have my LabVIEW communicate with MySQL server. What connector or driver is needed to establish communication between LabVIEW and MySQL server?

Solution

MySQL drivers such as MySQL ODBC <version> ANSI Driver and MySQL ODBC <version> ANSI Driver can be used to establish communication between LabVIEW and MySQL Server. Below is an example of the connection string needed to have LabVIEW communicate with a MySQL server installed locally with a username of root and password of admin:
Driver={MySQL ODBC 9.0 Unicode Driver}; Server=localhost; User=root; Password=admin;
image.png