I could never get ODBC syntax to work with myodbc
i.e.
{ call proc(args) } always gave a syntax error but
call proc(args) works
I do call procedures with in and out parameters with myodbc fine.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 12-Apr-2006 deer.chief@stripped wrote:
> Hello,
>
> I'm having a lot of troubles accessing a stored procedure in my MySQL
> database via ASP.NET 2.0 and ODBC.
> I've installed connector/ODBC 3.51.12 and when I try to call the stored
> procedure I get te following error:
>
> "You have an error in your SQL syntax; check the manual that corresponds
> to your MySQL server version for the right syntax to use near '{ call
> sp_GetData('Params')); }' at line 1"
>
> I've read in a post in the MySQL "Stored Procedure" forum that
> connector/ODBC does not yet supports stored procedure.
>
> Is that true?
>
> Thanks for your help.
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=1
