MYOB ODBC Driver v5

[A3gis]

Hi,
I'm aware there is a similar post in this category about the MYOB ODBC driver
and getting it to function correctly under MX, but as no useful answers have
been posted there in some time, I wondered if the date of the post was a
hinderance, so here we go again.

Problem: A client shelled out the ridiculous charge to MYOB to license a copy
of their ODBC driver for developers. Fair enough. I have got the driver running
on the CFMX server and accessing the datafile fine (connecting using the test
tools supplied with the MYOB v5 ODBC driver). The issue comes in when setting
up the datasource in CF. It just wont sodding connect!

I setup the datasource in cfadmin as an ODBC socket, the ODBC DSN I configured
in the standard windows ODBC panel shows up no troubles, so i select it, type
in the user name and password, hit submit, and BOOM!:

Connection verification failed for data source: sitac_MYOB
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][MYOB
ODBC] - Unable to launch MYOB - Database specified in the connection string is
already opened exclusively by another application.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][MYOB ODBC] - Unable to launch MYOB - Database specified in
the connection string is already opened exclusively by another application.

Now, to the best of my knowledge, there's no other MYOB products running on
the server. Can anyone shed any light on this, as i think it's the ODBC driver
itself locking any access out.

I've tried asking MYOB (australia) and their phone tech support guys forwarded
me on to [email]developers@myob.com[/email] from which I've had no reply in the past 2 weeks
(I qualified my request to them saying i would be happy getting ANY web
language - CF,ASP,PHP to connect to it). I've made several posts on their
forums to no avail also.

help!
Regards,
Aegis

[A3gis]

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!