Need more help?

HTML Wrap

class	section group

HTML Wrap

class	col span_3_of_5

ANSWER ID:11365

This support note describes how to create a Data Source Name (DSN) and then ensure a test connection is successful.

What is MYOB ODBC Direct?

MYOB ODBC Direct is an ODBC (Open Database Connectivity) driver designed to enable an ODBC connection to an MYOB company file.

The driver is a Windows-compatible component with functionality that enables access to your MYOB business information. When you install the driver, it acts as an interface between the MYOB database and other applications, interpreting requests to, and providing information from, the database using the most popular database industry standard, ODBC.

Before using the MYOB ODBC Direct driver:

Register the MYOB ODBC Direct driver.
Perform a test connection, using the TestConnection utility.

UI Expand

title	1. Register the ODBC Direct driver

With an unregistered installation of MYOB ODBC Direct, you have access only to the MYOB Clearwtr sample company file. Registering MYOB ODBC Direct enables unlimited access to any of your company files.

If you've purchased a 3rd party add-on (Australia | New Zealand), the develop will provide you with an Activation Number. You'll need this number, and your AccountRight serial number, to register your ODBC Direct driver.

For any other use you'll need to call us to register the MYOB ODBC Direct driver (call 1300 555 111 in Australia or 0800 606 962 in New Zealand).

UI Expand

title	2. Perform a test connection

The TestConnection Utility tests the connection between the MYOB ODBC driver and the MYOB data file. If you receive a successful connection it confirms:

The MYOB ODBC driver is installed and working correctly, and
The data file you are connecting to has been registered for use with the ODBC driver.

Download the TestConnection Utility

Download the TestConnection.exe file to your desktop. The file is located at the bottom of this support note.
Double-click to run the application
Follow the below steps on Using the TestConnection Utility

Using the TestConnection Utility

The TestConnection utility allows you to test two types of connections.

We recommend testing the ADO Connection, as this will ensure that the ODBC driver is functional.

If you need to also confirm that a particular DSN is also functional with the MYOB ODBC driver, then we would recommend testing the DSN Connection.

UI Expand

title	DSN Connection

UI Expand

title	Create a DSN

If you are using a 64-bit operating system and have installed the MYOB ODBC Direct driver, you will not be able to see the driver in the Drivers tab of the ODBCData Sources Screen (ODBC Data Source Administrator). This is because the MYOB ODBC Direct driver is not a 64-bit driver.

MYOB's ODBC driver is a 32-bit driver and is therefore found in C:\WINDOWS\syswow64\odbcad32.exe. You need to go to this location in order to create the DSN to connect to your company file.

To create a DSN

Click the Windows Start button and choose All Programs, then choose Administrative Tools then choose Data Sources.
Click the User DSN tab then click Add.
Select the appropriate MYOB ODBC driver according to the version of MYOB you are using. If you are unsure as to which MYOB ODBC driver to choose, please refer to the ODBC Driver table.
Click OK.

Developer Access

If you are testing a DSN connection that has 'Developer Access' enabled, with an MYOB datafile that is not clearwtr, then you must always include the key file. The Key File is used for Developer Access, and is obtained by your third party developer.

If you want to become a registered third party developer, please refer to https://developer.myob.com for more information.

Click OK.
Click OK again.

Testing the Connection

MYOB ODBC TestConnection window

Connection Type = DSN
Driver Name = Choose the same driver name used in Step 4 of Creating the DSN.
MYOB Data Source Name (DSN) = <DSN Name>
Click the Test button.

UI Expand

title	ADO Connection

MYOB ODBC TestConnection window

To test an ADO connection please follow the below steps:

Connection Type = ADO
Driver Name = MYOAU0801 - please see below table for other drivers
User Name = <User Name for your MYOB datafile>
Password = <Password>
Database = Browse to the relevant MYOB datafile.
Click on the Test button.

The following fields are only required when creating a Read and Write connection.

MYOB Executable, and
Key File - If you are testing a read and write ADO connection with an MYOB datafile that is not clearwtr, then you must always include the key file. The Key File is used for Developer Access, and is obtained by your third party developer.

If you want to become a registered third party developer, please refer to https://developer.myob.com for more information.

Driver versions and documentation

UI Expand

title	MYOB ODBC driver versions

Region	Release Year	Release Version	ODBC Version	Driver Name
AU	2010+	AccountRight Enterprise v19+ AccountRight Premier v19+ AccountRight Plus v19+ AccountRight Standard v19+	10	MYOAU1001
	2009	Premier Enterprise v6.5 Premier v12.5 Accounting Plus v18.5 Accounting v18.5	9	MYOAU0901
	2008	Premier Enterprise v6 Premier v12 Accounting Plus v18 Accounting v17	8	MYOAU0801
	2007	Premier Enterprise v5 Premier v11 Accounting Plus v17 Accounting v17	7	MYOB_ODBC
	2006	Premier Enterprise v4 Premier v10 Accounting Plus v16 Accounting v16	6	MYOB_ODBC
NZ	2010+	AccountRight Enterprise v19+ AccountRight Premier v19+ AccountRight Plus v19+ AccountRight Standard v19+	9	MYONZ0901
	2008	Premier Enterprise v6 Premier v12 Accounting Plus v18 Accounting v18	8	MYONZ0801
	2007	Premier Enterprise v5 Premier v11 Accounting Plus v17 Accounting v17	7	MYOB_ODBC
	2006	Premier Enterprise v4 Premier v10 Accounting Plus v16 Accounting v16	6	MYOB_ODBC

UI Text Box

type	note

If you're using a third party application and you're unsure as to which MYOB ODBC driver you should use, please contact your third party developer. If you do not use a third party application and you are unsure as to which ODBC driver you should use, please contact MYOB Technical Support (Australia 1300 555 123 or New Zealand 0508 328 283).

UI Expand

title	ODBC documentation

For more information on the ODBC Direct driver's functionality, see the documentation found within the Help subdirectory of the relevant region and version ODBC installation directory. For example, documentation on the Australian ODBC v10 driver can be found in: C:\MYOBODBCAU10\Help

The user_guide.pdf includes information on Installing, How to Read, Read tables (i.e. Read Data Dictionary), How to Write, and Write tables.

HTML
<h2><i class="fa fa-comments"></i>  FAQs</h2><br>

UI Expand

title	How do I edit an existing DSN?

If you are using a 64-bit operating system and have installed the MYOB ODBC Direct driver, you will not be able to configure the existing data source in the ODBCData Sources Screen (ODBC Data Source Administrator). This is because the MYOB ODBC Direct driver is not a 64-bit driver.

MYOB's ODBC driver is a 32-bit driver and is therefore found in C:\WINDOWS\syswow64\odbcad32.exe. You need to go to this location in order to configure the existing data source.

To edit a DSN

Click the Windows Start button and choose All Programs, then choose Administrative Tools then choose Data Sources.
Click the User DSN tab select your existing DSN then click Configure.
Ensure the Company File Path is correct.
Click OK.

UI Expand

title	How do I troubleshoot a failed connection?

Check this	By doing this
Ensure the MYOB Data Source Name (DSN) matches the name you selected in the Test connection utility.	Check the DSN by selecting ODBC Data Sources from the Control Panel and reviewing the list of entries displayed in the ODBC Data Source Administration window for your MYOB data sources.
Ensure the path of the company file is still correct for the DSN.	From the ODBC Data Source Administration window select the MYOB DSN you are testing, then select Configure. Select the Browse option and verify that the company file is still located within the path. If not, locate the file and click OK.

Still having problems?

If you're still having trouble connecting to your MYOB company file and DSN, check with your local consultant. Or, if you're installing MYOB ODBC Direct as part of a business solution, contact your provider via their support email or telephone.

UI Text Box

Attachment

TestConnection.exe