Testing the MYOB ODBC driver using the TestConnection tool from MYOB
Jump to navigation
Jump to search
Overview
MYOB provides a TestConnection utility that can be used to test and see if the MYOB ODBC driver is installed and running correctly. This applies to MYOB AccountRight v19 or lower but does not apply to MYOB AccountRight Live.
The TestConnection Tool can be found at the following location on your machine: C:\MYOBODBCAU10\bin\iwinnt\TestConnection.exe.
To use the TestConnection utility, follow these steps.
- Locate and start the TestConnection.exe utility;
- Select the correct Driver Name from the list. For most users, this will be MYOAU1001;
- If a Compatible Driver does not exist then Install the ODBC Driver before moving to step 3.
- Enter Administrator as the User Name;
- Enter the associated Password;
- Click the first Browse button and select your data file;
- Click the Test button and see what error messages display.
If an error occurs, we recommend you perform the following two task and then try again.
- 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.
Notes
- 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.