-
Title
DB2 connection causes "Unable to load one or more of the requested types. Retrieve the LoaderExce -
Description
I'm getting the following error message when connecting to a DB2 database only.
System.Reflection.ReflectionTypeLoadException
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
Stack Trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.Control.Invoke(Delegate method)
at Quest.Toad.Util.Facility.Load()
at Quest.Toad.Util.Facility.get_ImplementationType()
at Quest.Toad.DB2.DB2Provider.CreateProviderConnection(ConnectMediator mediator)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
There are no other DB2 clients installed except TACOM11. -
Cause
The error is related to the DB2 configuration on the system, if the ExceptionTrace.log, generated with the Support Bundle, shows this entry:
Stack trace:
at Quest.Toad.DB2.Common.DB2Utils.EnumerateClients(ClientInfo& defaultClient)
at Quest.Toad.DB2.DB2Provider..ctor()
This indicates an error with EnumerateClients which hints a DB2 catalog issue. -
Resolution
1. Locate your machine.config. It's typically a located in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config. Note, if you have .NET 3.0, it still uses the one in .NET 2.0.
2. Make a back up of your machine.config and keep it somewhere safe just in case.
3. Make sure Toad is not running.
4. Open the current machine.config with notepad.
5. Look for the tag <runtime> to </runtime>.
6. Delete everything between those lines INCLUDING the tags.
7. Save the file and restart TDA.