I downloaded the trial version of MySQLDirect .NET Data Provider (Version 2.70, MySQL 4.20). As soon as I trying to access a table with blob data types, I get a "Lost connection to MySQL server during query" exeption.
Is this a limitation of the trial edition?
See the code example below.
Notice: If I remove the "blob" part, the method works.
Code: Select all
public void UploadBlob(string name,uint version, byte[] data) {
MySqlBlob myBlob = new MySqlBlob(data);
MySqlCommand myCommand = new MySqlCommand("INSERT INTO template (name,version,data) VALUES(name,version,:MyData)",mySqlConnection);
myCommand.Parameters.Add("MyData",myBlob);
mySqlConnection.Open();
try {
myCommand.ExecuteNonQuery();
}
finally {
mySqlConnection.Close();
}
}
Toni