ODBC Driver for MYOB

Build 22.0.8462

Windows DSN Configuration

Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Connecting to MYOB:

See to connect with the driver's embedded credentials and skip creating a custom OAuth app.

These properties are required when connecting to a company file (both for Cloud and On-Premise instances).

  • User: The username associated with your company file.
  • CompanyFileId:The ID of the company file. If not specified, the ID of the first returned company file will be used. You can find this by querying the CompanyFiles view:
    SELECT Id FROM CompanyFiles

Connecting to an On-Premise instance:

When connecting to an on-premise instance, you will need to set the following connection property in addition to those above:

  • Url: The Url of your MYOB instance.
  • Password: The password associated with your company file.

Connecting to a Cloud Instance

Establish a connection to MYOB without setting any additional connection properties using the driver's Embedded Credentials.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462