List:MySQL ODBC« Previous MessageNext Message »
From:Martin J. Evans Date:April 12 2006 10:41am
Subject:RE: [mysql] Does myODBC supports stored procedures with parameters?
View as plain text  
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
Thread
Does myODBC supports stored procedures with parameters?deer.chief12 Apr
  • RE: [mysql] Does myODBC supports stored procedures with parameters?Martin J. Evans12 Apr
    • Re: [mysql] Does myODBC supports stored procedures with parameters?C K12 Apr
      • Re: [mysql] Does myODBC supports stored procedures with parameters?Daniel Kasak13 Apr
Re: [mysql] Does myODBC supports stored procedures with parameters?deer.chief19 Apr