I use devart dotconnect for mysql 5.70.120.
I using DevArt Linq to SQL model.
The DB is MySQL 5.1.x installed on windows server 2008 32 bit.
I have encountered this problem:
===
InnerException = {"Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'"}
===
This occur when i try to update an changed object (_model.SubmitChanges):
Code: Select all
public bool UpdateCustomHasAmbiente(cam_has_amb chaToUpdate)
{
bool addResult = true;
try
{
_model.SubmitChanges();
// _model.SaveChanges();
}
catch (Exception e)
{
addResult = false;
}
return addResult;
}
Best regards.
Max
P.S. * _model is the context.