MySQL Bugs: #60723: NET Connector 6.3.6 does not work with VS 2010 Professional

Bug #60723	NET Connector 6.3.6 does not work with VS 2010 Professional
Submitted:	1 Apr 2011 15:28	Modified:	26 Apr 2011 18:54
Reporter:	Malcolm Sparrow	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.3.6	OS:	Windows
Assigned to:	Julio Casal	CPU Architecture:	Any
Tags:	visual studio 2010

Description:
After using it successfully after installation, after some time the connector presented a dialog saying it was no longer working. I could no longer configure datasources, or refresh the schema on existing datasources which worked.

Uinstalling, reinstalling, rebooting - nothing has worked, VS2010 can no longer use MySQL connector to talk to my database. The database is still there and working, as the web-site I was building can still pull data using the last working version of the .aspx.

How to repeat:
Install, use and after "some time" then it breaks.

Additional - I've reproduced this problem on two machines now, both running Windows 7 Ultimate, and Visual Studio 2010 Professional.

Of note - both have XNA Game Studio 4.0, Visual Assist X installed.

Maybe you had installed SP1 for VS2010? Please, check.

I don't recall installing VS2010 SP1, and it's not listed in installed programs, nor in the About for VS 2010 - included below. Although I do have a hotfix - KB982218. Should I install SP1 to get rid of this problem? As it's cost me a days work so far trying to get what should "just work" to work...

Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRel

Installed Version: Professional

Microsoft Visual C# 2010   01018-532-2002102-70871
Microsoft Visual C# 2010

Microsoft Visual C++ 2010   01018-532-2002102-70871
Microsoft Visual C++ 2010

Microsoft Visual Studio 2010 Team Explorer   01018-532-2002102-70871
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Web Developer 2010   01018-532-2002102-70871
Microsoft Visual Web Developer 2010

Microsoft Windows Phone Developer Tools - ENU   01018-532-2002102-70871
Microsoft Windows Phone Developer Tools - ENU

Crystal Reports Templates for Microsoft Visual Studio 2010   
Crystal Reports Templates for Microsoft Visual Studio 2010

Hotfix for Microsoft Visual Studio 2010 Professional - ENU (KB982218)   KB982218
This hotfix is for Microsoft Visual Studio 2010 Professional - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/982218.

Microsoft XNA Game Studio   4.0
Microsoft XNA Game Studio 4.0
Build 4.0.20823.0

Visual Assist X   
For more information about Visual Assist X, see the Whole Tomato Software website at http://www.WholeTomato.com. Copyright (c) 1997-2011 Whole Tomato Software, Inc.

It seems that my issue is heavily related to the issues encountered by these other uses ; http://bugs.mysql.com/bug.php?id=60404

I've since installed SP1 on both my PC and Laptop where I've been encountering this issue. My PC now seems to be able to use the connector, my laptop does not.

On my laptop, I have been able to use the devenv.exe /rootSuffix Exp workaround  once only - which allowed me to use the connector. However, since then, even with this workaround it now fails to load.

Further, my PC which was "fixed" by applying SP1, no longer lets me use the connector after rebooting.

Sorry to pester, but this issue is costing my client and I money - is there a workaround for this problem? If not, then we'll have to move back to Microsoft-SQL.

I've also tried 6.2.4 of the connector, but it doesn't seem to integrate with VS2010.

Any help to stay with MySQL would be greatly appreciated!

Out of desperation - I've now installed VS2008, and reinstalled the connector (6.3.6) and it all works fine within VS2008, but still breaks using VS2010. So, it looks like you're installer/installation of 6.3.6 is faulty when applied to VS2010.

If you can patch this up for 6.3.7 so it works correctly, that would be appreciated.

This bug has been fixed in version 6.3.7.

Superb - thank you! Any idea on the release date? I note it's not yet downloadable from the mysql.com site.

Cheers!

Malcolm, 6.3.7 should be available by the end of May, although I can't provide an specific date.

Why do not release a patch for then vs2010 sp1 issue?

A lot people use vs2010 sp1 and for us is a big problem to wait to the end of may.

Regards

Very well. i guess we should wait for Connector/NET 6.3.7 but in the mean time: Are there any instructions as to how to integrate Connector/NET 6.3.6 this into Visual Studio Manually?

Until the next release is available, a workaround for this issue is:

1. Get the Connector/Net 6.3.6 source code.
2. Install the Visual Studio 2010 SP1 SDK.
3. Open the MySQLClient-VS2010 solution.
4. Remove the reference to Microsoft.VisualStudio.Shell from MySql.VisualStudio.VS2010 project.
5. Add references to Microsoft.VisualStudio.Shell.10.0 and Microsoft.VisualStudio.Shell.Immutable.10.0 to the MySql.VisualStudio.VS2010 project.
6. Rebuild the Installer.VS2010 project in Release mode.
7. Exit Visual Studio 2010.
8. Install Connector/Net.

Hope it helps.

Is there an update about the 6.3.7 release? We are facing the above mentioned problems and looking forward to download en install the new release!

Can somebody with the right tools installed provide a patched compiled version of 6.3.6 ? I've been trying to patch from the sources but the installer is missing from the downloadable src from the 6.3.6 GA.

Thanks a lot

Version 6.3.7 is now available for download.

Nice. Except that it still does not work. i have just installed Connector/NET 6.3.7 and i do not see a MySQL Database option despite the manual specifying it clearly, and there is no NET Framework Data Provider for MySQL either. i restarted the PC to check, and still nothing!

What's wrong???

Ok I solved it! you have to be logged in as Administrator for the ionstaller to do its job! BUT WHY ISN'T THERE A WARNING MESSAGE OR AN ERROR? HOW CAN THIS THING BE ALLOWED TO INSTALL IF ITS NOT GOING TO WORK IF YOU ARE NOT ADMINISTRATOR?

Please patch the installer so it cannot be installed if you are not admin, other wise it is useless!

Marco, could you give details on your OS version?