Virtual Merchant
Australia
MYOB ODBC Direct

ODBC Direct connects programs like Virtual Merchant to your MYOB business information. 
If you're using MYOB Premier v12 or newer, MYOB Premier Enterprise v6 or newer then skip this step and go to Configuring an ODBC Data Source below. Premier v10 and v11 users must install ODBC.

To Install MYOB ODBC Direct:

  1. Go to the Windows Start Menu and choose All Programs; choose MYOB Premier v10; choose MYOB Tools; choose MYOB ODBC; and click Install MYOB ODBC Direct v6.
  2. The MYOB ODBC Driver Setup window is displayed, click Next to progress to the License agreement and click Yes to accept.
  3. Click Next to accept the default installation location (C:\MYOBODBC this is the recommended location).
  4. Click Next, the Start Copying Files window is displayed, click Next to begin installation.
  5. When installation is complete, click Finish.

Configuring an ODBC Data Source

With the installation of MYOB ODBC Direct complete, the next step is to configure an ODBC data source - in other words, connect MYOB ODBC Direct to your MYOB Company information.

  1. From the Windows Start Menu choose Control Panel; choose Administrative Tools and click ODBC Data Sources(32bit).  The ODBC Data Source Administrator window appears.


     
  2. Click Add, the Create New Data Source window appears


     
  3. Scroll down and locate MYOB_ODBC click it to select it, then click Finish.  The ODBC MYOB Setup Configuration window appears.


     
  4. Enter MYOB in the Data Source Name field. Important: The Data Source Name must be MYOB for Virtual Merchant to locate it.
     
  5. Click the Browse button and navigate to your MYOB data file (usually in your MYOB installation folder C:\Premier10).


     
  6. Select your MYOB data file and click Open.


     
  7. In the User Name field enter the administrator for your company file. If you have not renamed the administrator user name when you created the company file the default user name is Administrator.  Enter the administrator password (if you've defined one - otherwise leave the password field blank) and click OK to close the ODBC MYOB Setup Configuration window.
  8. Click OK to close the ODBC Data Source Administrator window.

Testing your installation

The TestConnection utility checks that you have correctly installed the MYOB ODBC Direct driver and that you have correctly connected to a company file.

  1. From the Windows Start Menu choose All Programs; choose MYOB ODBC Direct v6; choose MYOB ODBC TestConnection - the MYOB ODBC TestConnection window appears.


     
  2. Choose DSN Connection type and MYOB from the MYOB Data Source Name (DSN) drop down list box and click Test.

If the connection has been tested successfully, your company name will appear as shown above.

If you have subscribed to a support plan for your MYOB software, MYOB can help you install the MYOB ODBC Direct driver and perform a successful test connection to your company file.  Call MYOB Customer Service at 1300 555 151 for registration enquiries.

 
E-mail Notifications