Stored procedures

[M Lambert]

Hi,

I have no problems executing queries by code. But I am not able to use stored procedures.

For example:

I have the following stored MySQL query called "MaReq1":

SELECT * FROM `table_medecins` WHERE ID_Medecin=2

No problem if I write and execute the same in VB code like the following:

'========================================================
Dim monReader As System.Data.Odbc.OdbcDataReader

OdbcConnection1.Open()

OdbcCommand1.CommandType = CommandType.Text
OdbcCommand1.CommandText = "SELECT * FROM `table_medecins` WHERE ID_Medecin=2"
monReader = OdbcCommand1.ExecuteReader

While monReader.Read()
Debug.WriteLine(monReader.GetInt32(0).ToString() + ", " _
+ monReader.GetString(1))
End While

OdbcConnection1.Close()
'========================================================

But if I try to call the same query, but the stored one, using code:

'========================================================
OdbcConnection1.Open()

OdbcCommand1.CommandType = CommandType.StoredProcedure
OdbcCommand1.CommandText = "MaReq1"
monReader = OdbcCommand1.ExecuteReader

OdbcConnection1.Close()

'========================================================

I get this error:

ERROR [23000] 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 'MaReq1' at line 1

Is there one of you who have succeeded with a stored procedure ? I use VB .Net but I suspect that the problem could be the same for other programming languages.

I am using myodbc3.dll version 3.51.11.0.

Thanks