Below is my step to find out the version of MyODBC Connector :
- Go to Control Panel -> Administrative Tools and choose Data Sources (ODBC).
- Click the Add button and scroll to the end of the data source list and you will find out the version of your MyODBC Connector like shown in the image below.
The version of MyODBC Connector on my computer is 3.51.12.00 while the version on production server is 3.51.11.00. The MyODBC Connector version on production server come with the installation of Plesk 8.1.
This why i got the error PROCEDURE db_name.procedure_name can't return a result set in the given context when running MySQL stored procedures on the production server. And after i upgraded the MyODBC Connector to the latest version then the problem is solved.
In the general case, the server did not know if a procedure will return just one result set, or more. So, it has to assume the "worst" case, that several results sets might be returned.
Make sure we are using the latest ODBC version. And don't forget to restarting the server to takes an effect.
The support for the CLIENT_MULTI_RESULTS flag was added in 3.51.12.