Re: using connector/net

[Emanuele Scozzafava]

Reggie

I tryed with "old syntax=yes", but the result doesn't change.
This is the code:
MySqlConnection cn = new MySqlConnection();
cn.ConnectionString = "Data Source=localhost;database=controllodocumenti;old syntax=yes;";
cn.Open();

MySqlCommand cm = new MySqlCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.Connection = cn;
cm.CommandText = "sp_test";

cm.Parameters.Add("par0", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 3;
MySqlDataReader dr = cm.ExecuteReader(CommandBehavior.SingleResult);

This is the stored procedure:
CREATE PROCEDURE sp_test (par0 int)
begin
select * from table0;
end

The cm.ExecuteReader generates this error message:
#42000Incorrect number of arguments for PROCEDURE sp_test; expected 1, got 0

I debugged the code and cm.Parameters is correctly populated!