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:colin.shreffler@stripped]
> Sent: Tuesday, November 22, 2005 12:38 PM
> To: mysql@stripped
> 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/mysql?unsub=1
