Does myODBC supports stored procedures with parameters?

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=gcdmo-myodbc@m.gmane.org

RE: [mysql] Does myODBC supports stored procedures with parameters?

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@gmail.com 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=martin.evans@easysoft.co m

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: [mysql] Does myODBC supports stored procedures with parameters?

Can I access them through VBA/Ms access?. Please help.
CPK

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: [mysql] Does myODBC supports stored procedures with parameters?

C K wrote:
> Can I access them through VBA/Ms access?. Please help.
> CPK
>

I theory, you should be able to use SPs from Access with the very latest
MyODBC ( link to driver is mentioned in a previous post on the topic -
it's not an official release yet ). However there are some critical bugs
at the moment - mainly that the driver causes Access to *constantly*
crash. Also keep in mind that if you install the latest driver and want
to uninstall it, you'll have to manually remove all traces of myodbc
dlls and stuff, as the uninstaller doesn't remove them, and if you leave
them lying around, you'll keep getting crashes.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org