This information applies to MYOB AccountRight version 19. For later versions, see our help centre.
https://help.myob.com/wiki/x/tgKc
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.
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 contact us to register the MYOB ODBC Direct driver.
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.
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
- 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.
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
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 |
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.
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.
FAQs
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.
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.
Attachment