MYSQLConnector class¶
The MYSQLConnector class is developed by Tekniker to allow connections to MySQL and MariaDB servers. It runs on Windows and Linux in 32 and 64 bit modus using the C Connector DLL provided by MySQL. The only limit with this class is the use on RT targets, it slows down the performance too much to be useful.
GDataBase class¶
The GDataBase class is developed by Saphir to allow connections to MySQL and MariaDB from RT targets (PXI). It is solely LabVIEW based and initializes its own TCP connection to side-step the need of a connector DLL.
LSSTLayer class¶
The LSSTLayer is an universal (i.e. can run on Windows, Linux and LinuxRT) class, this gives an abstraction layer which acts as an intermediary between the LabVIEW cluster data and the SQL statement syntax. Several top-level methods are used to control the access to the database and adaptively format the SQL statements for the user.
Troubleshooting¶
The LSSTLayer class can generate the following errors:
Number |
Name |
Description |
---|---|---|
1901 |
No cluster detected |
The method expected a cluster input as a variant but did not receive one. |
1902 |
Empty input string |
A required input string is empty. |
1903 |
Empty MySQL Object |
Open failed to initialize a valid connection. |
The class also throws errors generated by the MYSQLConnector class (used in the EUI) and the GDatabase class (used in the PXIs).
LSSTLayer_RT class¶
The LSSTLayer_RT is a specific class for RT (PXI), this class is just a wrapper over the LSSTLayer class to provide an easier and faster interface with the settings from RT.