WaddoAus FWIW I raised this issue with the MYOB development team. This was their reply...
"...Thank you for reaching out. Unfortunately, we no longer support AccountRight v19 classic as this has been discontinued. This also applies to ODBC as we no longer support AccountRight classic we also discontinued ODBC. We have not turned the program off. As AccountRight v19 and earlier versions were only tested and supported for compatibility with 32bit Office applications, the ODBC driver is designed as a 32 bit driver. Currently we don’t offer a 64 bit option of the ODBC driver
The team that used to support ODBC no longer is available at MYOB for questions or support.
At this stage, we would recommend for the end-user to upgrade to our latest versions of AccountRight Live which uses the API not ODBC. This would require a separate integration though..."
So after much trial and error trying to do workarounds I eventually gave up.
Hi slim17 ,
Thanks for the reply..... :-( It did sound like Gavin had some success running the DSN on a 64bit machine (in 32bit mode)....but sounds like you and i were not so lucky. It makes no logical sense as the DSN is definitely created in 32 bit and both myob and in our case our myobintegration progam are 32 bit..... i'm sure there is a simple answer somewhere, but like you i think we have to give up as well.
Sam
