returning stored procedure results

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access

returning stored procedure results

Post by sam » Sat 09 Jul 2005 03:46

hi i am using unidirect trial edition to test connectivity between mysql and .Net(1.1). i have a stored procedure in my database which takes in two parameters. i am trying to use a uniSelectCommand within .Net(c#) to execute this stored procedure and return the results to a dataset.however whenever i try to execute the command, i get an error saying, PROCEDURE [ of the stored procedure..] can't return a result set in the given context.
could you tell me if this is as a result of a restriction with the trial edition of unidirect or i am overlooking something.
any help at all will be well appreciated

Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Mon 11 Jul 2005 08:10

To access MySQL database UniDirect .NET must be installed together with MySQLDirect .NET. Currently MySQLDirect does not support returning result set from stored procedures.