Bug #59599 Unable to add data connection. The given key was not present in the dictionary.
Submitted: 19 Jan 2011 2:22 Modified: 19 Jan 2011 2:30
Reporter: Rami Abughazaleh Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:6.3.6 OS:Windows (Windows 7 Ultimate x64)
Assigned to: CPU Architecture:Any

[19 Jan 2011 2:22] Rami Abughazaleh
Description:
Windows 7 Ultimate x64
Visual Studio 2010 Premium
MySQL Connector/Net 6.3.6
MySQL Server 5.5.8

Trying to add a data connection to an existing MySQL database in "Server Explorer" causes the error "Unable to add data connection. The given key was not present in the dictionary."

No errors during installation

How to repeat:
1. Install MySQL Server 5.5.8 and configure the service
2. Install MySQL Workbench 5.2.31
3. Launch MySQL Workbench, connect to the local instance, and create a new database schema (test123)
4. Launch Visual Studio 2010 > Server Explorer > Right-click Data Connections > Add Connection... > Data source: MySQL Database (Data Provider: .NET Framework Data Provider for MySQL) > Continue > Server name: localhost, User name: root, Password: password, Database name: test123 > Test connection > (Test connection succeeded.) OK > OK
5. Notice the error message:
"Unable to add data connection. The given key was not present in the dictionary."
[19 Jan 2011 2:23] Rami Abughazaleh
This issue was also previously reported here:
http://forums.mysql.com/read.php?38,371461,371461
[19 Jan 2011 2:30] Rami Abughazaleh
Sorry, this was an issue with my environment.

See this post for a solution:
http://connect.microsoft.com/VisualStudio/feedback/details/552006/unable-to-create-data-co...

Hint: Click on the Workarounds tab.