Difference between revisions of "Troubleshooting the MYOB ODBC driver"

no edit summary
Line 17: Line 17:
MYOB provides a TestConnection utility that can be used to test and see if the MYOB ODBC driver is installed and running correctly. For more information, see [[Testing the MYOB ODBC driver using the TestConnection tool from MYOB]].
MYOB provides a TestConnection utility that can be used to test and see if the MYOB ODBC driver is installed and running correctly. For more information, see [[Testing the MYOB ODBC driver using the TestConnection tool from MYOB]].


== File and Folder Access Requirements ==


[[File:MYOBTestConnectionTool.png|300px|thumb|right|The MYOB ODBC TestConnection.exe utility]]
The MYOB ODBC driver requires '''Read''' and '''Write''' access to specific folders in order to function properly. For more information, see [[Checking file and folder access requirements for the MYOB ODBC driver]].
 
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.
 
To use the TestConnection utility, simply 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''';
# 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]].
 
<br clear=all>
 
 
== File and Folder Access Requirements ==


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.
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.


* The folder containing your '''MYOB data file''';
* The folder containing your '''MYOB data file''';
2,725

edits