Some error messages when you use the Data Source Configuration Wizard in Microsoft Visual Studio 2008 Service Pack 1


After you install Microsoft Visual Studio 2008 Service Pack 1, in some situations, when you try to use Data Source Configuration Wizard to create a connection, you may see 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

These are due to an incomplete installation of Service Pack 1 or an incorrect installation of Microsoft Synchronization Services for ADO.net.

We have written a KB article (KB2001115) to explain the details and provide the solutions. Please see here if you met these issues,

http://support.microsoft.com/default.aspx/kb/2001115

If you need any further help, let us know.

Comments (2)

  1. Peter NItchie says:

    To Whom It May Concern:

      I learning Visual Basic and tried to connect to SQL Server in a Vb Project after making sure that I had SQL server running on my localhost and that I had copied and pasted the password to the connection string:  “A network-related or instance-specific error occurred while establishing a connection to SQL Server.   The server was not found or was not accessible.   Verify that the instance  name is correct and that SQL server is configured to allow remote connections.  (provider: Named Pipes Provider, error 40 – Could not open a connection to SQL server). ”  I even wondered whether there was something wrong with the Vb environment, so I tried connecting to an Access database—no problem.   What gives?   Thanks!

  2. Hi Peter,

    You need to make sure that when you’re connecting to your local server that you use the dot syntax (.) to identify the local machine. If you are running SQL Express (which is by default installed with Visual Studio) you would refer to it as .sqlexpress

    The easiest thing to do is add a new connection from Visual Studio’s Server Explorer and use the dialog and put a dot (.) in there for the server and see if you can browse the databases.

    http://msdn.microsoft.com/en-us/library/0wbea1ae.aspx

    Note that if you are using Visual Basic Express 2008, you can only work with local data files like Access, SQL Express detached MDF files and SQL Compact .SDF files.

    You may want to ask your question in the forums:

    http://social.msdn.microsoft.com/Forums/en-US/category/visualbasic

    HTH,

    -Beth