MySQL/ASP Error - PROCEDURE % can't return a result set in the given context?

  • Thread starter Thread starter arbpen
  • Start date Start date
A

arbpen

Guest
I am able to run this stored procedure on my local machine (WInXP SP3/MySQL 5.0.51b-community-nt) but I am getting an error on line 5 - "PROCEDURE sp_master_getstate can't return a result set in the given context" when running on the production server (MySQL 5.0.67-community).

Procedure:
CREATE PROCEDURE sp_master_getstate()
BEGIN
SELECT state_abbr FROM states ORDER BY id;
END

ASP code (line numbers added for clarifcation only):
1 set oconn = Server Createobject("ADODB.Connection")
2 oconn.open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver; DATABASE=mydb; UID=myuid; PASSWORD=mypw; OPTION=3"
3 sql = "CALL sp_master_getstate()"
4 set rs = createobject("ADODB.Recordset")
5 rs.open sql, oconn
6 rsarr = rs.getrows()
7 rs.close
8 set rs = nothing
9 oconn.close
10 set oconn = nothing
11 for i = 0 to ubound(rsarr,2)
12 response.write rsarr(0,j) & "<br>"
13 next
 
Back
Top