Difference between revisions of "Troubleshooting the MYOB ODBC driver"

[[File:MYOBTestConnectionTool.png|300px|thumb|right|The MYOB ODBC TestConnection.exe utility]]

 

MYOB provides a TestConnection utility that can be used to test and see if the MYOB ODBC driver is installed and running correctly. This can be found at the following location on your machine: C:\MYOBODBCAU10\bin\iwinnt\TestConnection.exe.

 

 

# Enter the associated '''Password''';

# Click the first '''Browse''' button and select your data file;

# Click the '''Test''' button and see what error messages display.

 

# Verify and Optimise your MYOB data file. This ensures that the data file is in such a state that it can be read.

# Reinstall the MYOB ODBC Driver. For more information, see [[Re-installing the MYOB ODBC Driver]].

 

 

* You must use the correct ODBC driver test connection utility that matches your version of MYOB. For more information, see [[MYOB and MYOB ODBC Driver version compatibility]].

 

 

 

The MYOB ODBC driver requires '''Read''' and '''Write''' access to specific folders in order to function properly. This is typically a problem when running third-party software from a Terminal Server environment. In those environment, IT Administrators typically lock things down to ensure nothing breaks. As a first step, we recommend you get your IT Administrator to verify your permissions and grant you '''Full Control''' to the following locations.