ANSWER ID:11148When you upgrade to a new version of the MYOB ODBC Driverdriver, you need to take certain steps to enable it to connect with your existing Data Source Names (DSNs). If you receive errors when attempting to use or create a DSN with MYOB ODBC after upgrading, it is possible that something has been left behind from the previous installation and is conflicting with the new version installation. This support note explains how to overcome installation issues with MYOB ODBC Direct. Solution Summary - Backup the Windows registry.
- Delete all DSNs.
- Uninstall all versions of the MYOB ODBC driver.
- Delete the MYOBODBC folder located in the root folder.
- Delete all instances of the OPENRDA.INI file
- Delete all keys referring to MYOB_ODBC or ODBCMYOB.dll
I have just upgraded my ODBC driver. Why can't I connect to my existing Data Source Names (DSNs)?
When you update your ODBC Driver, if DSNs referencing the previous driver remain OR if components of the previous driver are still present, you will receive connection errors when you try to connect using the new driver. The most common message received in this scenario is SQLAllocHandle on SQL_HANDLE_ENV failed. To overcome this mismatch, before This support note explains how to overcome installation issues with MYOB ODBC Direct. Before installing the required version of MYOB ODBC, you must remove any MYOB ODBC Drivers and any Windows elements which reference MYOB ODBC drivers. This involves modifying the Windows Registryregistry. PLEASE NOTE If you accidentally or inadvertently delete or modify other windows | UI Text Box |
|---|
| Modifying your Windows registry If you accidentally delete or modify Windows registry entries or keys, you may experience issues with other programs or functionality on your computer. It is also possible your computer may fail to start |
windows, we strongly . We strongly recommend you |
ask your Consultant consultant for assistance before you modify the Windows registry if you are unfamiliar with this process. Before |
you beginMake sure you take completing any of the tasks below, take a back up of your Windows |
Registry.registry. Refer to your Windows help for instructions. |
| UI Expand |
|---|
| title | Which registry keys should I delete? |
|---|
| | Registry key | Details |
|---|
| Hkey_Current_User/Software/ODBC/ODBC.INI | In this location you will find various registry keys which referring to the MYOB ODBC driver. The driver string value of each DSN will reference odbcmyob.dll. Please delete all registry keys which have odbcmyob.dll as the driver string value. This section of the registry also contains a key named ODBC Data Sources which has string values for various DSNs. Please delete any individual string values which reference MYOB ODBC and/or MYOB_ODBC values. | | Hkey_Local_Machine/Software/ODBC/ODBC.INI | Once again, delete any keys which represent a MYOB ODBC DSN all driver string values which reference MYOB ODBC, MYOB_ODBC and MYOBODBC. | | Hkey_Local_Machine/Software/ODBC/ODBCINST.INI | Delete all registry keys which reference the MYOB ODBC, MYOBODBC and MYOB_ODBC drivers. | | HKey_Users/<User's SSID>/Software/ODBC/ODBC.INI | Please perform the same steps as outlined above for the Hkey_Current_User/Software/ODBC/ODBC.INI location. |
How can I make sure I haven't skipped any?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 |
you do find you find additional entries, |
simply delete How should I continue from here? | UI Expand |
|---|
| title | Edit Windows configuration files |
|---|
| Once you completed the registry changes described above, you must edit the following Windows configuration files. Use the Windows |
Search search feature to search the contents of the entire machine. Because these files are stored in different folders and sub-folders of the local hard disk, searching the whole machine is a way of making sure you update all relevant files. | Configuration file | Details |
|---|
| ODBC.INI |
|
The first file to search for is Search for the file named ODBC.INI. Once you found all copies of this file, open each file in |
|
NotePad Notepad and delete all DSNs which refer to the odbcmyob.dll. Below is an extract of what you will find in this file. The portion you need to delete appears in BOLD. It includes the DSN name and the driver it uses. [Excel Files] |
|
Driver32=C:\WINDOWS\System32\odbcjt32.dll |
|
Driver32=C:\WINDOWS\System32\odbcjt32.dll |
|
Driver32=C:\MYOB\Connectivity\MYOBODBC\bin\iwinnt\odbcmyob.dll |
|
Driver32=C:\MYOB\Connectivity\MYOBODBC\bin\iwinnt\odbcmyob.dll | | ODBCINST.INI |
|
Once you have done this on all files, perform another search 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 you have removed or updated 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 and you are ready to install the appropriate MYOB ODBC Driver. |
|
I am using MYOB | UI Text Box |
|---|
| If using MYOB ODBC in a Terminal Server environment |
. Do I need to take any additional action?You have just one step to go: Having installed the appropriate MYOB ODBC Driver, copy the OpenRDA.INI file from the C:\Windows directory to each user's Windows folder (C:\Documents and Settings\%User Name%\Windows). |
| 
