I too am trying to use an odbc connection to access MYOB lookup info, I managed to use ODBC direct to set up a connection on the clearwater MYOB sample database, however, even though I could select the connect, infopath would not accept it.
I would also appreciate any help.