Troubleshooting the MYOB ODBC driver - Revision history

Nic at 00:45, 25 May 2017

2017-05-25T00:45:46Z

← Older revision		Revision as of 19:45, 24 May 2017
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight ~~19 or lower~~ but does not apply to MYOB AccountRight Live ~~2017 or lower~~.		In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to [[MYOB AccountRight Classic]] but does not apply to [[MYOB AccountRight Live]].

	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.

Nic at 00:08, 25 May 2017

2017-05-25T00:08:43Z

← Older revision		Revision as of 19:08, 24 May 2017
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19 or lower but does not apply to MYOB AccountRight ~~2013 (~~Live) or ~~higher~~.		In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19 or lower but does not apply to MYOB AccountRight Live 2017 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.

Jeff: /* Install the MYOB ODBC driver */

2017-05-05T03:11:21Z

Install the MYOB ODBC driver

← Older revision		Revision as of 22:11, 4 May 2017
Line 7:		Line 7:
	== Install the MYOB ODBC driver ==		== Install 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.

			If installed '''MYOB ODBC Direct v10 AUS''' will appear in Programs and Features in the Windows Control Panel

			To install / repair it see [[Installing the MYOB ODBC driver]].

	== Test the MYOB ODBC driver using the TestConnection tool from MYOB ==		== Test the MYOB ODBC driver using the TestConnection tool from MYOB ==

Jeff at 03:03, 5 May 2017

2017-05-05T03:03:06Z

← Older revision		Revision as of 22:03, 4 May 2017
Line 1:		Line 1:
	== Overview ==		== Overview ==

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

	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.

Jeff at 03:02, 5 May 2017

2017-05-05T03:02:05Z

← Older revision		Revision as of 22:02, 4 May 2017
Line 8:		Line 8:

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

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

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

	== Test the MYOB ODBC driver using the TestConnection tool from MYOB ==		== Test the MYOB ODBC driver using the TestConnection tool from MYOB ==
Line 20:		Line 16:

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

			== Verify and Optimise your Data File ==

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


	== Related Topics ==		== Related Topics ==

Jeff at 01:28, 24 July 2015

2015-07-24T01:28:45Z

← Older revision		Revision as of 20:28, 23 July 2015
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19 or lower but does not apply to MYOB AccountRight Live ~~2015~~ or lower.		In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19 or lower but does not apply to MYOB AccountRight Live 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.

Jeff at 01:13, 24 July 2015

2015-07-24T01:13:08Z

← Older revision		Revision as of 20:13, 23 July 2015
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19~~.10~~ or lower but does not apply to MYOB AccountRight Live 2015 or lower.		In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19 or lower but does not apply to MYOB AccountRight Live 2015 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.

Nic at 03:38, 16 February 2015

2015-02-16T03:38:46Z

← Older revision		Revision as of 22:38, 15 February 2015
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19.10 or lower but does not apply to MYOB AccountRight Live ~~2014~~ or lower.		In order for ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19.10 or lower but does not apply to MYOB AccountRight Live 2015 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.

Nic at 22:26, 23 June 2014

2014-06-23T22:26:30Z

← Older revision		Revision as of 17:26, 23 June 2014
Line 1:		Line 1:
	== Overview ==		== Overview ==

	In order for ODBClink 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 ODBClink to connect to your MYOB data file correctly, the [[MYOB ODBC Driver]] must be installed and working correctly. This applies to MYOB AccountRight 19.10 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.

Nic at 05:36, 18 June 2014

2014-06-18T05:36:24Z

← Older revision		Revision as of 00:36, 18 June 2014
Line 5:		Line 5:
	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 '''ODBClink''' (e.g. C:\ODBClink v3.0.0.0\);
	* The file '''ntdll.dll''' used for the SendMessage API (e.g. C:\Winnt\System32\ntdll.dll);