Problem solved...

Once you've got the ODBC v5.whatever driver installed, the DSN setup and
tested with the MYOB connection tester, go to [url]http://rmijdbc.objectweb.org/[/url] and
download the rmijdbc driver (there's a windows service version of it too)
follow the installation instructions for it (note, detail is on the site with
the details needed to configure the driver when using CFAdmin, basics are:

JDBC URL = jdbc:odbc:<DSN NAME HERE>
Driver Class = sun.jdbc.odbc.JdbcOdbcDriver

Seems to work quite nicely, kudos to MYOB Australia's Developers for pointing
me in the right direction there.

Hope this helps!