MYOB Integration: AccountRight 2011 ODBC connection error
Recently I was helping my development team to do some testing of our Salesforce-MYOB ReadyMade product to see if it is compatible with the latest ODBC driver “MYOB_AccountRight_2011” released by MYOB.
After installing the ODBC driver on my machine, I created a new System DSN with the ODBC driver. As soon as I clicked on the “Test Configuration” button to test the connection, I received a popup message as shown below:
The same error can also be found in the MYOB ODBC log file (the log file is located in <MYOB AccountRight 2011 installation folder>/ODBC_Inst/Logging/OpenAccessSDK60_Net_xxxxxxxx.log):
SQLDRV : [TID: 1EF8]:[Fri Aug 17 12:09:16.015 2012] ndam.cpp:2850: [IP] Error 0: There was no endpoint listening at https://localhost:6961/GatewayService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
SQLDRV : [TID: 1EF8]:[Fri Aug 17 12:09:16.015 2012] net_drv.cpp:560: Error from ipConnect()
SQLDRV : [TID: 1EF8]:[Fri Aug 17 12:09:16.016 2012] damdrv.c:615: sqldrv_connect(): IP connect() returned error while connecting to datasource:Test
I couldn’t find more information about this error on the Internet, but fortunately, I am able to find out the root cause. I realized that MYOB has installed a Windows service named “MYOB AccountRight Server 2011.1” in my machine during the installation. This Windows service acts as a communication bridge between the MYOB Application/ODBC driver and the company file and it has to be “Started” all the time. Otherwise, you will encounter the error mentioned above and you won’t be able to launch the MYOB AccountRight application correctly.
Hopefully, this helps those who encounter the same issue!