Yes, Some of us still have some legacy apps out there and they still need support. If you are one of those that use Crystal Reports 8.5 you may be cringing on setting up that development machine again. Here are the steps involved with installing Crystal Reports 8.5. Crystal Reports will alter registry permissions incorrectly and damage your registry. But what this really does it to create problems in your registry so when other programs attempt to read certain registry entries, they cannot and will fail. This is very true with some programs that use some ODBC connections. You also may not be able to add any new ODBC connections because of Crystal Reports.
- Create a System Restore Point name it Before Crystal Reports(Just in case)
- Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI (64bit)
- Right click on the key (ODBCINST.INI), then select Permissions. You will see that all permissions exist and are OK
- Install Crystal Reports 8.5 in the normal process but DO NOT CLOSE THE REGEDIT!!!
- After installing CR 8.5, switch to RegEdit, go to the menu to select View->Refresh or press F5 to refresh RegEdit
- Re-open the permissions on ODBCINST.INI and you will see that ALL the permissions have been deleted!
- We will need to put all the permissions and security back and re-take Ownership of ALL the keys beneath. The permissions, security and Ownership will be the same as on the ODBC key
- Checkmark Replace all child object permissions with inheritable permissions from this object select Apply
- After Adding the security and permissions back on ODBCINST.INI we will now need to change ownership
- Select the advanced button on the permissions screen.
- Make sure you delete all the entries that do not have inheritance!!! (marked <not inherited>)
- To change the ownership, go to the Owner tab
- Checkmark Replace owner on subcontainers and objects then Apply
- Do the same to the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI key (32bit)
- You should now have regained complete access to ODBC
We have tested with installing CR 8.5 first then attempting to use the Registry Editor but that did not work out. It maybe because since we already have the registry Editor open we still have the old permissions to the keys before Crystal reports 8.5 changes them so we are able to change them back. If you get something wrong, just do a System Restore back to the pre-installation of Crystal Reports 8.5 and try again.
Attached are some screenshots and a complete list of all the registry entries that Crystal Reports 8.5 will attempt to alter or create.