Difference between revisions of "Troubleshooting the MYOB ODBC driver"

Jump to navigation Jump to search

Troubleshooting the MYOB ODBC driver (view source)

Revision as of 00:31, 18 June 2014

2,345 bytes removed ,  00:31, 18 June 2014
no edit summary
(Created page with "== Overview == In order for ExcelReportLink to connect to your MYOB data file correctly, the MYOB ODBC Driver must be installed and working correctly. This applies to MYO...")
 
Line 1: Line 1:
== Overview ==
== Overview ==


In order for ExcelReportLink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19.9 or lower but does not apply to MYOB AccountRight 2013 or higher.
In order for ExcelReportLink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19.9 or lower but does not apply to MYOB AccountRight Live 2014 or lower.


In order for the [[MYOB ODBC Driver]] to function correctly, some things must be configured correctly on your machine. In most situations, users do not experience any problems. The purpose of this guide is to assist those who have problems.
In order for the [[MYOB ODBC Driver]] to function correctly, some things must be configured correctly on your machine. In most situations, users do not experience any problems. The purpose of this guide is to assist those who have problems.


 
== Install the MYOB ODBC driver ==
== Installing the MYOB ODBC driver ==


The MYOB ODBC driver must be installed in order for third-party software to connect to your MYOB Classic data file. For more information, see [[Installing the MYOB ODBC driver]].
The MYOB ODBC driver must be installed in order for third-party software to connect to your MYOB Classic data file. For more information, see [[Installing the MYOB ODBC driver]].
=== Notes ===
* You must install the correct ODBC driver that matches your version of MYOB. For more information, see [[MYOB and MYOB ODBC Driver version compatibility]].
* It may help to reinstall / repair the installation of the MYOB ODBC driver if you cannot get it to work correctly. For more information, see [[Installing the MYOB ODBC driver]].


== Verify and Optimise your Data File ==
== Verify and Optimise your Data File ==


Most errors relating to the MYOB ODBC driver can be resolved by verifying and optimising your data file. You should always verify your data file before as it may raise errors that the optimize cannot repair, or that the optimize can only repair if the verify has detected it.
Most errors relating to the MYOB ODBC driver can be resolved by verifying and optimising your data file. For more information, see [[Verifying and Optimising your MYOB Data File]].
 
To verify and optimize your data file, follow these steps:
 
# Open your MYOB data file in MYOB
# From the '''File''' menu, select '''Verify Company File''' and wait for the process to complete;
# From the '''File''' menu, select '''Optimise Company File''' and wait for the process to complete;
 
 
== Testing the MYOB ODBC driver using the TestConnection tool from MYOB ==
 
[[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.
 
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 ===
== Test the MYOB ODBC driver using the TestConnection tool from MYOB ==


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


<br clear=all>
== Check File and Folder Access Requirements ==


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


== File and Folder Access Requirements ==
== Related Topics ==


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.
* [[Troubleshooting]]


* The folder containing your '''MYOB data file''';
[[Category:Troubleshooting]]
* The folder containing the '''MYOB ODBC driver''' (e.g. c:\MYOBODBCAU10\);
* The folder containing the '''MYOB application''' (e.g. C:\Premier19\);
* The folder containing '''ExcelReportLink''' (e.g. C:\ExcelReportLink v3.0.0.0\);
* The file '''ntdll.dll''' used for the SendMessage API (e.g. C:\Winnt\System32\ntdll.dll);
Nic
Write, Bureaucrats, Administrators
1,171

edits

Retrieved from "https://accountingaddons.com.au/wiki/excelreportlink/index.php?title=Special:MobileDiff/242"

Navigation menu