Colin Currently executing a stored procedure also requires select permissions on the mysql.proc table. This is a current implementation requirement. This should disappear when we have INFORMATION SCHEMA support.
Reggie > -----Original Message----- > From: Colin Shreffler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 22, 2005 12:38 PM > To: mysql@lists.mysql.com > Subject: calling procedures from the .NET provider > > I've seen a few posts out there regarding this subject, but no solutions > that I could understand. > > I am unable to execute a stored procedure from the MySql data provider. > I get a message that says: > > '42000 SELECT command denied to user' etc. > > Can anyone tell me what I need to do to enable my procudure to be called? > > Furthermore, is there a way to call a stored procedure and get a DataSet > in return? > > I also tried the MySqlHelper class as it appears to have methods that > allow you to pass parameters to a command. But this does not work when I > try to execute a stored procedure. Has anyone been able to get this to > work? > > Thanks, > Colin > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
