Description

This document explains how to UNINSTALL MYOB ODBC / VERSION UPGRADES. This process is particularly important on a Terminal Server installation but can be useful on any computer that is having difficulty uninstalling the driver.

Detail Steps

The ideal way to deal with this particular error is to completely remove ODBC and all of its components followed by a clean reinstall. Below are some steps outlining how to ensure ODBC is completely removed before reinstalling:

1. Uninstalled MYOB ODBC form the Control Panel

2. Delete the MYOBODBC folder located in the C: directory

3. Remove all references and instances of MYOB_ODBC and MYOB ODBC

4. Remove all openrda.ini files which are generally located in the Windows and user's directory

5. Edit all ODBC.INI files and remove any references to DSN's using MYOB_ODBC and MYOB ODBC

6. Edit all ODBCINST.INI files and remove any references to MYOB_ODBC and MYOB ODBC

7. Reboot and Reinstall MYOB ODBC


In More Detail

The registry cleaner is a MYOB ODBC registry cleaner, so it will only clean the registries created during the install of the ODBC Driver. It will not remove registries created by the Administrative Data Sources tool. The removal of these data source registries will require the deletion of entire and partial registries key. Before the registries can be removed and manipulated, please follow the below steps:

1. Delete all DSN's

2. Uninstall all versions of MYOB ODBC

3. Delete the MYOBODBC folder located in the root directory

4. Delete all instances of the openrda.ini file

5. Create a Backup of the windows registry.

Below is a listing of where these registry keys can be found.

Hkey_Current_User/Software/ODBC/ODBC.INI

You will find in this location various registry keys which will use the MYOB ODBC driver. The driver string value of each DSN will reference odbcmyob.dll as it is a MYOB ODBC DSN. Please delete all registry keys which contain the driver string value as using the file odbcmyob.dll In the above location, there is also a key named ODBC Data Sources. This key contains string values which references the various DSN's, please delete the individual string values which reference the MYOB ODBC and/or MYOB_ODBC values.

Hkey_Local_Machine/Software/ODBC/ODBC.INI

Perform the same steps as mentioned above where all keys which represent a MYOB ODBC DSN are deleted and all driver string values which reference the MYOB ODBC, MYOB_ODBC and MYOBODBC are also deleted.

Hkey_Local_Machine/Software/ODBC/ODBCINST.INI

Delete all registry keys which reference the MYOB ODBC, MYOBODBC and MYOB_ODBC drivers Within the ODBC Driver registry key, delete all string values relating to MYOB ODBC, MYOBODBC and Article: KBA-01059 Page 1 of 2 http://crm/CS/articles/print.aspx?objectType=127&id=%7b246B9CA9-EF21-DB11-838F-000… 2/08/2006 MYOB_ODBC.

HKey_Users//Software/ODBC/ODBC.INI

Please perform the same steps as outlined above for the Hkey_Current_User/Software/ODBC/ODBC.INI location. Once you have performed the above operations, you should be able to search your entire registry listing for MYOB_ODBC, MYOBODBC, MYOB ODBC and odbcmyob.dll with no results returned. If any are found, then they will also need to be deleted. Once the editing of registries is complete, you will also need to edit some Window's config files. As these files are located in various locations such as C:/Windows and C:\Documents and Settings\%User Name%\Windows, it is recommended to search the entire machine for these files to ensure all are updated appropriately. The first file to search for is ODBC.INI. Once all copies of this file are found, open each file in NotePad and delete all DSN's which refer to the odbcmyob.dll. Below is an extract of what you will find in this file. The portion which needs to be deleted has been placed in BOLD. This bold portion includes the DSN name and the driver it uses.

[Excel Files]

Driver32=C:\WINDOWS\System32\odbcjt32.dll

[dBASE Files]

Driver32=C:\WINDOWS\System32\odbcjt32.dll

[test]

Driver32=C:\MYOB\Connectivity\MYOBODBC\bin\iwinnt\odbcmyob.dll

[TESTMYOB]

Driver32=C:\MYOB\Connectivity\MYOBODBC\bin\iwinnt\odbcmyob.dll

Once this is done for all files, perform another search for the file named ODBCINST.INI. Edit all instances of this file to remove all references to the MYOB ODBC, MYOBODBC, MYOB_ODBC and odbcmyob.dll. When all of the registry keys which reference MYOB ODBC, MYOBODBC, MYOB_ODBC, odbcmyob.dll and the ODBC.INI and ODBCINST.INI files are updated/removed, then this means that there are no longer any traces of the components created by the Administrative Data Sources function, so MYOB ODBC can be reinstalled.

Related Information

None