Brian reported back to me by email that the updated dll I sent fixed the problem for him.
I have update the download for the MySql Data layer so if anyone else has this issue they can download it again to get the fix. It was a syntax compatibility problem with MySql 4.x, the syntax has been fixed to be compatible. Users of MySql 5.0 don't need to worry about it because the previous syntax worked fine in MySql 5.0.
Thanks,
Joe