Error message when you try to use the Data Source Configuration Wizard to create a connection to a SQL or an Access data source in Visual Studio 2008: Could not load type 'Microsoft.VisualStudio.DataDesign.SyncDesigner.SyncFacade.SyncManager'

Symptoms

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 = 9.0.0.0, Culture=neutral, PublicKey Token=b03f5f7f11d50a3a

Error message 2:

The type initializer for 'Microsoft.VisusalStudio.DataDesign.SyncDesigner.SyncFacade.SyncTableConfigManager' threw an exception

Cause

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.

 

Resolution

  • 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.

Microsoft SQL Server Compact 3.5 Service Pack 1 and Synchronization Services for ADO.NET version 1.0 Service Pack 1 for Windows Desktop

 

 

 

Microsoft Internal Support Information

Steps to reproduce.

Product Bug Number: Content maintenance:118210
Author ID (email alias):yangcao
Writer ID(email alias):ramakoni
Tech Review ID (email alias): sqlprev
Confirm Article has been Tech Reviewed: Yes/No
Confirm Article released for Publishing: Yes/No
Properties

Article ID: 2001115 - Last Review: Aug 16, 2009 - Revision: 1

Feedback