Troubleshooting an MYOB ODBC connection

If you have installed MYOB ODBC Direct and have defined your company file as a data source but you are unable to connect from Zed Axis to your company file, review the following troubleshooting list:

  • Test that the MYOB company file that you want to connect to is activated
  • Ensure the DSN you created matches the name you selected in the MYOB ODBC TestConnection utility. To check the DSN, see ‘To define a company file as an ODBC data source.
  • Ensure the company file that you have defined as a data source is located in the correct folder. To check the folder path, go to the ODBC Data Source Administration window select the DSN you are testing and then click Configure. Click Browse and verify that the company file is still located in the selected path. If not, locate the file and then click OK.
  • Check the version of the MYOB ODBC Direct driver. You may have upgraded your MYOB company file and not your MYOB ODBC Direct driver. Locate the latest version of the MYOB ODBC Direct driver and upgrade your version to this one.
  • When running Zed Axis you will need to run it with elevated permissions, right click over the Axis icon and select the option to Run As Administrator

If you are still having problems connecting to your MYOB company file, please raise a ticket with Zed Systems support describing the steps you have taken.

Article ID: 160, Created On: 10/21/2011, Modified: 1/13/2012