Problem
@VS2013
When you open the SSDT library, you jump out of the following messages
@SSMS
The exception to editing Table is the following:
Details are as follows:
===================================
Exception have been thrown by the target of a invocation. (sqleditors)
------------------------------
Program Location:
At System.RuntimeTypeHandle.CreateInstance (RuntimeType type, Boolean publiconly, Boolean NoCheck, boolean& Canbecached, runtimemethodhandleinternal& ctor, boolean& Bneedsecuritycheck)
At System.RuntimeType.CreateInstanceSlow (Boolean publiconly, Boolean Skipcheckthis, Boolean FillCache, StackCrawlMark & Stackmark)
At System.RuntimeType.CreateInstanceDefaultCtor (Boolean publiconly, Boolean Skipcheckthis, Boolean FillCache, stackcrawlmark& Stackmark)
At System.activator.createinstance[t] ()
At Microsoft.SqlServer.Management.DataTools.Providers.Common.CommonConnectionProperties ' 1..ctor ()
At Microsoft.SqlServer.Management.DataTools.Providers.Common.CommonProviderObjectFactory ' 3.CreateObject (Type ObjType)
At Microsoft.SqlServer.Management.DataTools.Providers.SqlServer.SqlProviderObjectFactory.CreateObject (Type ObjType)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataProvider.CreateObject (Guid dataSource, Type objType)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataProvider.CreateConnectionProperties (Guid DataSource )
At Microsoft.SqlServer.Management.DataTools.DataServices.DataProviderManager.CreateConnectionProperties (Guid Provider
At Microsoft.SqlServer.Management.DataTools.Providers.SqlServer.SqlDataSourceSpecializer.DeriveDataSource ( String connectionString)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataProvider.DeriveDataSource (String connectionString)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataConnection.SetConnectionStrings (String connectionString)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataConnection. ctor (Dataprovider provider, String connectionString, Boolean encryptedstring)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataConnectionFactory.CreateDataConnectionImpl (Guid Provider, String connectionString, Boolean encryptedstring)
At Microsoft.SqlServer.Management.Data.DataConnectionFactory.CreateDataConnection (Guid provider, String ConnectionString, Boolean encryptedstring)
At Microsoft.SqlServer.Management.DataTools.DataServices.DataConnectionManager.CreateDataConnection (Guid Provider, String connectionString, Boolean encryptedstring)
At Microsoft.SqlServer.Management.Data.DataConnectionManager.GetDataConnection (Guid provider, String ConnectionString, Boolean encryptedstring, Boolean update)
At Microsoft.sqlserver.management.datatools.dataservices.dataconnectionmanager.microsoft.sqlserver.management.data.interop.i Vsdataconnectionmanager.getdataconnection (guid& guidprovider, String bstrconnectionstring, Boolean fencryptedstring)
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner ()
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open ()
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.CreateDesigner (Urn Origurn, DocumentType EditorType, DocumentOptions aeoptions, IManagedConnection con, String fileName)
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Ed Itors. Isqlvirtualproject.createdesigner (Urn Origurn, DocumentType editortype, DocumentOptions aeOptions, IManagedConnection con, String fileName
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner (Urn Origurn, DocumentType EditorType, DocumentOptions aeoptions, IManagedConnection con, String fileName)
At Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow ( IManagedConnection MC, DocumentOptions options)
===================================
Unable to find the requested. Net Framework Data Provider. It May is not installed. (System.Data)
------------------------------
Program Location:
At System.Data.Common.DbProviderFactories.GetFactory (String providerinvariantname)
At Microsoft.SqlServer.Management.ConnectionUI.AdoDotNetConnectionProperties. ctor (String providerName)
At Microsoft.SqlServer.Management.ConnectionUI.SqlConnectionProperties. ctor ()
How to Solve
Find the machine.config of the. NET Framework
C:\Windows\Microsoft.NET\Framework\v4.0.30319\CONFIG\Machine.config
C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\Machine.config
Open Machine.config with administrator rights, search for the key dbproviderfactories, confirm if there are any dbproviderfactories, and then delete it, archive
Open SSMS again, and VS2013 SSDT will resume normal.
Article derived from: http://www.dotblogs.com.tw/yc421206/archive/2014/06/11/145502.aspx
If there is a absurdity, please inform the Novice, please forgive
[SSMS] [Visual Studio] resolved-Unable to find the requested. Net Framework Data Provider. It May is not installed