In Microsoft Visual Studio 2008 Service Pack 1 installations, you try to use Data Source Configuration Wizard to create a connection to Access or a SQL data source. When the wizard reaches the Choose Database objects page, you may receive one of the following error messages.
Error message 1:
Could not load type 'Microsoft.VisualStudio.DataDesign.SyncDesigner.SyncFacade.SyncManager' from assembly Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage, Version = 18.104.22.168, Culture=neutral, PublicKey Token=b03f5f7f11d50a3a
Error message 2:
The type initializer for 'Microsoft.VisusalStudio.DataDesign.SyncDesigner.SyncFacade.SyncTableConfigManager' threw an exception
The first error message is caused due to an incomplete installation of Service Pack 1 for Visual Studio 2008 which could result in a mismatch between the file versions of Microsoft.VSDesigner.dll and Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage.dll. The former is updated to Service Pack 1 version and the latter will have the RTM version. This problem is more likely to happen in environments wherein you install different edition of Visual Studio side by side and you upgrade one edition and not the other. For example, you have an installation of Visual Studio Express release version and Visual Studio Team Suite release edition installed side by side and then you only upgrade the express edition to Service Pack 1 but leave the Team edition at RTM level, you will get the first error discussed in the symptoms section
The second error message occurs when Microsoft Synchronization Services for ADO.net is not properly installed.
- To resolve the first error message, install Service Pack 1 for all the Visual Studio 2008 editions on the affected system.
- To resolve the second error message, remove the Microsoft Synchronization Services for ADO.net program through Add/Remove programs applet in control panel and reinstall the same from the following link.
Article ID: 2001115 - Last Review: Aug 16, 2009 - Revision: 1