MySQL Bugs: #44089: TableAdapter Configuration Wizard crashes with MySQL Connector/Net 5.2.5

Bug #44089	TableAdapter Configuration Wizard crashes with MySQL Connector/Net 5.2.5
Submitted:	4 Apr 2009 16:54	Modified:	7 Apr 2009 20:39
Reporter:	Leon B	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.2.5	OS:	Windows (XP Professional)
Assigned to:		CPU Architecture:	Any
Tags:	TableAdapter, Visual Studios 2008

Description:
I am trying to create a stonge-typed dataset for my .Net application, but I cannot add a TableAdapter to the dataset, as Visual Studios 2008's TableAdapter Configuration Wizard crashes with the following message:
An unexpected error has occurred.
Please record the following message when seeking support from Microsoft:

Source: Microsoft.VSDesigner
ErrorCode:-1
Additional Info:

When I uninstall the mySQL .Net connector 5.2.5 I can add the TableAdapter Configuration Wizard displays without a problem.

The following link shows someone else with the same issue in .Net (but he doesn't specify if he uses the mySQL connector):
http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=346383

I installed .Net Connector 6.1 to see if the problem still exists, but this wouldn't even load as per bug #44064

How to repeat:
create a new forms project (likely any project)
Add new Dataset to project
Open dataset and add tableadapter
The tableadapter object becomes visible, usually 'TableAdapter Configuration Wizard' becomes visble but instead a message box detailed in the description appears, upon clicking OK on the message box the TableAdapter object disappears.

OR
Open new project, Click Data then Add new Data source
Data Source Configuration Wizard comes up. 
Under 'Where will the application get data from?' select Database 
Click Next
Same message box appears

Suggested fix:
The problem is the TableAdapter Configuration Wizard, which is displayed upon adding a TableAdapter, cannot load/cope with the .Net Connector.

I suspect it is specifically when loading the contents for the selection box below 'Which data connection should your application use to connect to the database?' - it comes accross the mySQL .Net connector and fails.

Hi Leon and thanks for your report.

Unfortunately, I can not repeat this on my W2K8x64 box running both VS2005 & 2008 Pro versions against remote MySQL server 5.1.31 on OpenSolaris host.

Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
Microsoft .NET Framework Version 3.5 SP1
Installed Edition: Professional
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899)   KB944899
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282)   KB945282
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040)   KB946040
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308)   KB946308
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344)   KB946344
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581)   KB946581
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171)   KB947171
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173)   KB947173
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180)   KB947180
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540)   KB947540
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789)   KB947789
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127)   KB948127
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140)   KB945140
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888)   KB947888
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484)   KB948484
MySQL Connector/Net   5.2. Data design and management tools for MySQL.  Copyright © 2007 MySQL AB

Looking at provided link, I'd say it's something MS related as people have same problem not using MySQL c/NET so please contact Microsoft support and get back to me.

I installed SP1, after which it worked perfectly. 

Sorry for not catching that!

Bug reappeared in Visual Studio 2012 Professional Update 1. Any attempt to save configured TableAdapter query, even default one, results in a crash. Although everything works fine with default settings until configuration attempt.

Seems to reappear in Visual Studio 2013 Pro Update 4.

I can even test the altered query with 'execute query' button, get the expected result, but saving it throws 
"An unexpected error has occurred. Error message: The object has been deleted."