Visual Studio Adding Data Connections - Given Key not Present in the Dictionary

sql visual-studio connect server-explorer
BastanteCaro picture BastanteCaro · Jan 19, 2011 · Viewed 10.9k times · Source

I've read through a couple of previous similar questions and none seem to provide a fix. so i ask again. I'm using Visual Studio and am trying to connect to a DB in Server Explorer. Regardless of what database i try to connect to it gives a "Given Key not Present in the Dictionary" error. i have tried with SQL CE and SQL Express 2008 databases and each give the same issue.

I can connect quite easily with SQL Management Studio Express so i believe the Databases are the same.

Thanks in Advance.

Answer

BastanteCaro picture BastanteCaro · Jan 20, 2011

after a lot of time searching for the answer to this i found the solution here

this is not really a workaround but in fact a SOLUTION, how to get rid of the error, in case you have missed to remove all connections before removing the provider:

edit C:\Users...\AppData\Roaming\Microsoft\VisualStudio\10.0\ServerExplorer\DefaultView.SEView and remove the connection with the wrong Provider manually. If you do not know which of the provider is failing, simply delete the file :)

If this won't help try deleting also C:\Users...\AppData\Local\Microsoft\VisualStudio\10.0

PS: you have to quit all instances of visual studios first or the files will be re-created from memory ..

The second part only worked for me , deleting the whole folder.

Related questions

How can I do SELECT UNIQUE with LINQ?

I have a list like this: Red Red Brown Yellow Green Green Brown Red Orange I am trying to do a SELECT UNIQUE with LINQ, i.e. I want Red Brown Yellow Green Orange var uniqueColors = from dbo in database.…

Read More
DataSet panel (Report Data) in SSRS designer is gone

In the layout screen of an SSRS designer e.g. Visual Studio, I have lost the report data panel. It has disappeared and I can't remember what it is called in order to get it back. This usually lists the …

Read More
Update DataSet structure in Visual Studio to match new SQL Database Structure

After making some changes to my SQL database structure (using scripts in SQL Server Management Studio), how can I update my DataSet.xsd file in Visual Studio to match the new structure? Must I do this manually? I considered deleting …

Read More