-
Title
Error launching SQL Optimizer: "Could not load file or assembly 'AxInterop.QExplain2'". -
Description
After upgrading Optimizer with the Toad for Oracle package, trying to launch SQL Optimizer gives the following error:
"Unhandled error has occurred:
Could not load file or assembly ‘AxInterop.QExplain2'
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=8a20902d6bc5eb79’ or one of it’s dependencies. The
located assembly’s manifest definition does not match the assembly
reference. (Exception from HRESULT:0x80131040)"After the clicking OK to the error, some of the Optimizer window is open but it is not displayed completely and cannot work in it.
-
Resolution
Steps to completely uninstall SQL Optimizer for both Oracle and SQL Server do the same:
1. Uninstall Toad for Oracle and SQL Optimizer using the Quest Installer from the Start | All Program | Quest Software | Quest installer or Uninstall Quest Product menu. Follow the wizard and select product to remove.
2. Remove the previous installation directories, check the following locations and remove the folder "Quest SQL Optimizer for Oracle" or "Quest SQL Optimizer for SQL Server", if it exists:
For Windows XP:
C:\Documents and Settings\All Users\Application Data\Quest Software\Quest SQL Optimizer for Oracle
C:\Documents and Settings\<your username>\Application Data\Quest Software\Quest SQL Optimizer for Oracle
C:\Program Files\Quest Software\Toad for Oracle 11\Quest SQL Optimizer for Oracle
C:\Program Files\Quest Software\Quest SQL Optimizer for Oracle
For Windows 7:
C:\Users\all_user\AppData\Local\Quest Software\Quest SQL Optimizer for Oracle
C:\Users\user_name\AppData\Local\Quest Software\Quest SQL Optimizer for Oracle
C:\Program Files(x86)\Quest Software\Toad for Oracle 11\Quest SQL Optimizer for Oracle
C:\Program Files(x86)\Quest Software\Quest SQL Optimizer for Oracle
3. Go to Start | Run | regedit | Delete or rename the following registry entries:
Registry: HKey_Current_User\Software\Quest Software\Quest SQL Optimizer for Oracle
Registry: HKey_Local_machine\Software\Quest Software\Quest SQL Optimizer for Oracle
4. Reinstall SQL Optimizer for Oracle