Does anyone have experience calling MySQL stored procedures from LabVIEW. MySQL periodically closes the connection to my LV8 client after calling a Stored Procedure. Results from MySQL Stored Procedures have to be processed differently from simple queries. Not doing so violates the client-server protocol causing MySQL to "close" the connection. One way to reproduce the issue: Run a simple "select" query after calling a stored procedure, MySQL immediately closes the connection.
The MySQL documentation states that the CLIENT_MULTI_RESULTS flag must be set and that "mysql_more_results()" and "mysql_move_result()" must be used. I know how to do this in C. How do we implement this in LabVIEW?
Any help would be greatly appreciated.
CY