MySQL Forums
Forum List  »  Connector/NET and C#, Mono, .Net

Advanced Search
New Topic

Re: Does anyone call stored procedure successfully in MS dotnet platform?
Posted by: Owen Ni
Date: November 18, 2004 10:47AM

I have installed the mysql-connector-net-1.0.2-gamma on my computer and tested it. It still does not work. The error message is "Exception trying to retrieve parameter info for usp_CountryAll: Invalid attempt to access a field before calling Read()"

I tested using the CommandType.Text to call the stored procedure, but it only works for the stored procedures without any parameter. When I tested the stored procedure with parameter, I got the error message like this "#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usp_ExpensesGetMById(3)' at line 1"

Owen Ni

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.