ssms error

Question

ssms error

Eskandari

Ten Centuries

Points: 1078
More actions
June 24, 2014 at 2:13 am

#396954

In SSMS When I Right Click on a table and select 'Edit TOP 200 ROWS'
I See this Error:
SQL SERVER 2012 x64 and Windows 8.1 x64
===================================
Exception has been thrown by the target of an 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.IVsDataConnectionManager.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.Editors.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 not be 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()

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Keith Tate SSCrazy Eights Points: 9938 More actions · Answer 1

Have you tired to reinstall SSMS? If not, you might want to try that.

The other question I have is why are you using "Edit Top 200 Rows"? Why not use the UPDATE statement? That way you will update all of the rows that need to be updated (based on a WHERE clause). If you need help coming up with the UPDATE statement read the first article in my signature and post the table structure and sample data along with the desired output and someone will be able to help you.

Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Eskandari Ten Centuries Points: 1078 More actions · Answer 2

Eskandari

Ten Centuries

Points: 1078

June 24, 2014 at 1:36 pm

#1724455

i re install ssms but the error is exists

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Eskandari (6/24/2014)
i re install ssms but the error is exists

I agree with Keith. Forget that menu option exists. You should use an update statement instead of using a databound grid. It might take you a little bit longer today but it won't be long until you are able to do it WAY faster with code.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

This is the part the jumped out at me:

Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data)

I'd look to see if the .Net framkwork is properly installed and at the appropriate version and patch levels.

3r8gfjdn Newbie Points: 1 More actions · Answer 5

I had the same issue

It turns out in some of my

C:\Windows\Microsoft.NET\XXXXX

See AL

Framework\Config

and

Framework64\Config

machine.Config files

had malformed System.data XML

<system.data>

</system.data>

the bold < was missing

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 6

I have fixed this several times due to IBM I Client Software installs adding a bogus line in the .net machine.config file:

SSMS will receive the following error when trying to edit a table:

The DbProviderFactories Section Can Only Appear Once Per Config File. (System.Configuration) Exception has been thrown by the target of an invocation. (SQLEditors)

Save a copy of the machine.config file.

Edit the machine.config file with word pad and search for “dbproviderfactories”.

The file is usually located in the following location (for 32 bit). Note: For 64-bit systems look in the Framework64 folder:

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

The start of the section is:

The end of the section is:

</DbProviderFactories>

Here is a correct section of code with a begin tag and an end tag (highlighted):

You will need to delete one bogus line that looks like this:

Save the edited machine.config file and restart SSMS.

Here are some "hits" on the issue from the .net and stackoverflow forums:

http://forums.asp.net/t/1693277.aspx

http://stackoverflow.com/questions/13822312/the-dbproviderfactories-section-can-only-appear-once-per-config-file

WaIIy Ten Centuries Points: 1387 More actions · Answer 7

All my config files are clean and I still have this issue - Any other ideas?

[font="Verdana"]-- Wally
-- Reluctant DBA[/font]

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 8

I have fixed about 10-15 users with this resolution as it's a pain to correct this issue. Check all of the config files (32 and 64 bit) and be sure to restart SSMS after making any changes to the config file(s).

WaIIy Ten Centuries Points: 1387 More actions · Answer 9

DeWayne_McCallie (9/20/2016)
I have fixed about 10-15 users with this resolution as it's a pain to correct this issue. Check all of the config files (32 and 64 bit) and be sure to restart SSMS after making any changes to the config file(s).

Yeah I did - Even restarted the machine - Not sure what I am missing - All my configs have just these entries:

<system.data>

</DbProviderFactories>

</system.data>

And on upper definition:

[font="Verdana"]-- Wally
-- Reluctant DBA[/font]