When launching Create New Connection (File/New/Connection) gave the following error:
System.NullReferenceException: Object reference not set to an instance of an object.
Stack trace:
at Quest.Toad.DB2.ProviderCommon.DB2Utils.GetClientVersion()
at Quest.Toad.DB2.ProviderCommon.DB2Utils.ClientOK(String& message)
If the IBM Data Server component is installed, it will add a IBMDBCL1 registry key in the following registry path.
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\IBMDBCL1
(Note: For Windows 64-bit the registry is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBMBad\DB2\InstalledCopies\IBMDBCL1)
This registry key will interfere with the launching of the Create New Connection window.
STATUS: Waiting for fix in a future release of Toad for DB2
WORKAROUND:
Please uninstall the IBM Data Server component and verify that the following registry key is removed.
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\IBMDBCL1
(Note: For Windows 64-bit the registry is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBMBad\DB2\InstalledCopies\IBMDBCL1)
If the above registry key is still present, please remove them by the steps below:
1. Close Toad
2. Go to Start | Search (or Start | Run in Windows XP)
3. Type in "regedit"
4. Backup your registry
5. In the Registry Editor, go to HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\IBMDBCL1
(Note: For Windows 64-bit the registry is HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBMBad\DB2\InstalledCopies\IBMDBCL1)
6. Right-click on the key and rename IBMDBCLI1 to IBMCLI1_OLD
7. Restart Toad and the Create New Connection window should not give the error
If it is not possible to uninstall the IBM Data Server component please follow the steps below:
After Toad DB2 is installed successfully and the IBM data server component is re-installed again you can use this below work around to be able to use Toad DB2 v5.2.
Create a new PROFILES registry key under the InstalledCopies\IBMDBCL1 level as shown on the attached screesnshot
(assuming IBMDBCL1 is the name of your IBM Data Server Package DB2 name):
Also, please note that the 64-bit registry key is:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2\InstalledCopies\IBMDBCL1\PROFILES]
Disclaimer : Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 "Description of the Microsoft Windows registry": http://support.microsoft.com/default.aspx?kbid=256986
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center