PROCEDURE can't return a result set in the given context

调用存储过程失败！出现如下错误：PROCEDURE ipbx.qu_ery can't return a result set in the given context，

ipbx是数据库，
qu_ery是自己写的存储过程的名字；

 

原因：连接数据库的方式不正确。

导致报错的连接方式： 

       if(!mysql_real_connect(&mysql,"localhost","root","123456","ipbx",0,NULL,0))
        {
                printf("mysql_real_connect() failed!/n");
                mysql_close(&mysql);
                return 0;
        }
正确的连接方式：

         if(!mysql_real_connect(&mysql,"localhost","root","123456","ipbx",0,NULL,CLIENT_MULTI_STATEMENTS))
         {
                printf("mysql_real_connect() failed!/n");
                mysql_close(&mysql);
                return 0;
        }
修改一下连接数据库的方式的参数就OK了！