I just tested with MySQL's Connector/Net and it works fine.
Code: Select all
using (var conn = new MySqlConnection("server=192.168.1.9; port=3306; user id=joe; password='...'; database=Test; pooling=false"))
{
conn.Open();
using (var cmd = new MySqlCommand("call test()", conn))
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandTimeout = 300;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
Console.WriteLine(String.Format("{0}", dataReader.GetValue(0)));
}
dataReader.Close();
dataReader.Dispose();
}
conn.Close(); // <-- Hangs until command timeout reached.
}
Code: Select all
select * from Test.Item limit 2;
Please advise.
Thanks,
Lars
Ps. The reason I turned off pooling was to debug a similar problem where ExecuteReader intermittently hangs until command timeout reached (again, only when calling an SP returning a recordset).