Child pages
  • Creating a Data Source Name (DSN) and test connection in ODBC Direct

This information applies to MYOB AccountRight version 19. For later versions, see our help centre.


 

 

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:

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

 

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

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 

  1. Download the TestConnection.exe file to your desktop. The file is located at the bottom of this support note.
  2. Double-click to run the application
  3. 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.

 

DSN Connection
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

  1. Click the Windows Start button and choose All Programs, then choose Administrative Tools then choose Data Sources.
  2. Click the User DSN tab then click Add.
    ODBC Data Source Administrator window with User DSN tab highlighted
  3. 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.
    ODBC Data Source Administrator window with drivers highlighted
  4. Click OK.
    ODBC MYOB Setup Configuration window

 

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. 

  1. Click OK.
  2. Click OK again.

 

Testing the Connection 

MYOB ODBC TestConnection window

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

MYOB ODBC TestConnection window

 

To test an ADO connection please follow the below steps:

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

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

  1. MYOB Executable, and
  2. 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

 

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

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

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.

  FAQs


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

  1. Click the Windows Start button and choose All Programs, then choose Administrative Tools then choose Data Sources.
  2. Click the User DSN tab select your existing DSN then click Configure.
  3. Ensure the Company File Path is correct.
  4. Click OK.
How do I troubleshoot a failed connection?
Check thisBy 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

 TestConnection.exe