When you upgrade to a new version of the MYOB ODBC driver, 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. The most common message received in this scenario is SQLAllocHandle on SQL_HANDLE_ENV failed.
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 registry.
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. We strongly recommend you ask an IT consultant for assistance before you modify the Windows registry if you are unfamiliar with this process.
Before completing any of the tasks below, take a back up of your Windows registry. Refer to your Windows help for instructions.
|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 find additional entries, delete them.
Once you completed the registry changes described above, you must edit the following Windows configuration files. Use the Windows 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.
Search for the file named ODBC.INI. Once you found all copies of this file, open each file in 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 [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
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.
If using MYOB ODBC in a Terminal Server environment
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).