Hi,
this works perfect for me:
Custom Connection field:
"Driver={MySQL ODBC 5.1 Driver}; Server=xxx; Database=xxx; User=xxx; Password=xxx; Option=3;" />
You need to make sure that the "Driver={MySQL ODBC 5.1 Driver}" is set correctly, you may need to ask your hosting company for the exact driver reference.
Good luck!
Ken