Chester Yeum Posted January 22, 2009 Report Share Posted January 22, 2009 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 Quote Link to comment
Michael Aivaliotis Posted January 22, 2009 Report Share Posted January 22, 2009 The only way I know to set the CLIENT_MULTI_RESULTS flag is via the ODBC driver. If you set the CLIENT_MULTI_STATEMENTS flag then this flag will be set too. Watch the video below to see how I enable the CLIENT_MULTI_STATEMENTS flag. I'm using ODBC driver version 5.1: Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.