The following error dialog may be displayed when using the Data Access Tool (DAT) included with Host Integration Server 2006 to create or edit a Universal Data Link (UDL):Note: This can also occur when using the Data Access Tool included with the Microsoft OLEDB Provider for DB2 versions that are bundled with Microsoft SQL Server 2005 Feature Pack and Microsoft SQL Server 2008 Feature Pack.
Data Access ToolUnhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.Method not found: 'System.Windows.Forms.DialogResult Microsoft.HostIntegration.DataAccessLibrary.DataAccessControl.DisplayDataSourceWizard(System.Collections.ArrayList, Boolean, Microsoft.HostIntegration.DataAccessLibrary.DataSourcePlatform ByRef, Microsoft.HostIntegration.DataAccessLibrary.IConnectionString ByRef, Boolean, System.String ByRef, Boolean ByRef, Boolean ByRef, Boolean ByRef, Boolean ByRef, Boolean ByRef)'.
The error occurs when there are multiple instances of the Microsoft.HostIntegration.DataAccessLibrary.dll registered in the Windows Global Assembly Cache (GAC). In order to resolve the problem, you need to remove the extra instances of Microsoft.HostIntegration.DataAccessLibrary.dll from the GAC. You should uninstall all of the instances that do not match the version of the Microsoft.HostIntegration.DataAccessLibrary.dll that exists in the %SNAROOT% folder.
Once the extra Microsoft.HostIntegration.DataAccessLibrary assemblies are uninstalled, run the DAT to verify the you can edit and create UDLs without error.
This problem is most likely to occur when multiple versions of the Host Integration Server data providers (including the standalone DB2 provider included in the SQL Server 2005/2008 Feature Packs) have been installed and removed over time. In such instances, one or more instances of the Microsoft.HostIntegration.DataAccessLibrary.dll may not be properly removed from the GAC.