That's the only way I can get here is to click on 'Discussions' on the green menu bar. I found the answer while posting here while waiting for some discussion on the topic. I do think I will make it a Tips/Trick thing - thanks.
I have a button in my form and on click of that button I am writing this code....
OdbcCommand cmd ;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error..
ERROR  [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 'abc()' at line 1.
So plz sort out the problem as soon as possible...
ExecuteNonQurey should only be used for inserts, updates and deletes, if your preforming a select you should be saying ExecuteReader to return what ever you want, hope this helps, need any more help just ask.
Like I said yesterday, the exception message is reasonably clear that there is a problem in your stored procedure abc(). If you cannot figure out what is wrong with it then post it here so an SQL expert can help.
Sorry, but as I said that was an uneducated guess, but your error message is definitely complaining about that line.
You could start a new thread in the MySQL[^] forum, to see if any expert sees the question. I would suggest you post your C# code and your stored procedure and the full exact text of the error message.