MySQL Bugs: #60404: Latest connector broken by final release of VS2010 SP1

Bug #60404	Latest connector broken by final release of VS2010 SP1
Submitted:	9 Mar 2011 13:58	Modified:	29 Mar 2011 9:32
Reporter:	Daniele Fusi	Email Updates:
Status:	Duplicate	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
Tags:	Connector/Net, SP1, vs2010

Description:
I've just upgraded my VS2010 Ultimate to VS2010 SP1 with the final release of SP1 published in MSDN, and connector/net 6.3.6, which was already installed on that machine together with the latest versions of MySql server and workbench, has stopped working. Before the upgrade it worked fine; now when I open the About box in VS2010 it says "The MYSQL connector net 6.3.6 package did not load correctly", and of course if I try to compile the solution using it fails with error "The specified store provider cannot be found in the configuration, or is not valid". 

I tried with a repair install of connector, but nothing changed.

I tried manually readding the references to MySql dll's in my solution: this way it compiles, but then it throws an exception at runtime during startup as the component is not properly registered.

How to repeat:
Just upgrading to SP1 should break the Connector. Upgrade, then open the About box.

I installed VS2010 SP1 yesterday. I get the same error with "Help -> About", but my project compiles and runs without any problems. 

(Win7 x64, .NET 4.0, EF Code First CTP5; project references MySql.Data and MySql.Data.Entity;)

I don't have any problems running MySql Workbench (ersion 5.2.32; I can't speak for MySql Server, as I haven't installed the VS service pack on that server yet.

Your "store provider not found" error could be related to Bug #53686 and Bug #53975, both of which are due to be fixed in version 6.3.3.

I just hit the same issue. My workspace has Windows 7 Professional x86 and VS2010 with SP1. MySQL connector 6.3.6 just stopped working after VS2010SP1 was installed:(

Thank you for a problem report.
I am not able to repeat this issue with Express Edition of Visual Studio.

Here's some details on my environment:
- Windows 7 Home Premium 64-bit 
- MySQL Connector Net v. 6.3.6
- VS 2010 Express
- .NET framework 4

After downloading and installing SP1 of VS, I did not get any error with the VS About box window and I am able to run / build demo project "TableEditor" with no problems.

This is the link from where I've downloaded the VS SP1: 
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=75568aa6-8107-475d-948a-ef2262...

Please note that there are some known issues when installing the VS SP1 on a machine where you previously installed the 'Microsoft Windows SDK for Windows 7 and .NET Framework 4 (Windows SDK v7.1)' and where you are using the x64 or IA64 compilers that were included in that download. 

I'm not sure this is the problem, but it could be somehow related: http://msdn.microsoft.com/en-us/visualc/gg697159
--

Richard, Miles, which Edition of VS are you using?

Thanks.

I'm using VS2010 Premium (10.0.40219.1 SP1Rel).

* Running VS as administrator doesn't help;
* Running VS with the "/ResetSkipPkgs" command-line parameter doesn't help;
* Repairing MySql Connector doesn't help;

Running with the "/log" command-line parameter logs the same error message as Bug #59298, Bug #55623 and Bug #55654:

> SetSite failed for package [MySQL Connector Net 6.3.6] 
> {79A115C9-B133-4891-9E7B-242509DAD272} 
> 80004003 - E_POINTER

As reported in Bug #55623, deleting the Design_????????.???.winprf file from the AppData\Roaming\Microsoft\VisualStudio\10.0 directory resolved the problem for one session. As soon as I restarted Visual Studio, the problem reappeared.

OK, this is bizarre:

If I open VS2010 and go straight to "Help->About", I get the error message. I am then unable to use Server Explorer to add a new connection to *any* database, or to connect to a MySql database. ("An unexpected error occurred in the .NET Framework Data Provider for MySQL. Please contact the provider vendor to resolve this problem.")

If I open VS2010, go straight to the Server Explorer, and either add a new MySql connection or open an existing one, then I don't get the error message from "Help->About", and the MySql provider works perfectly.

This workaround was suggested last December for VS LightSwitch and Connector v6.3.4:
http://social.msdn.microsoft.com/Forums/en/lightswitchgeneral/thread/79c9aef5-e961-41e8-bb...

I managed to let it work, but it seems that each computer config has its own issues; hope the next connector will fix this. Anyway here are my steps, may be they can help someone else: (1) uninstall connector; (2) ensure that the system is clean: I used ccleaner to remove old stuff from the computer; (3) install SP1 using Web platform installer; (4) start VS and ensure that everything is OK, also opening the Help/About box; (5) reboot the system (this is important); (6) reinstall connector. On some systems I had to do this twice, dunno why. All the systems I fixed this way have Win7x64 Ultimate and VS2010 Ultimate.

I had exactly the same problem with my VS2010, but it disappeared after I closed VS2010 and summoned the About box in VS2008 installed on the same machine.

Since then VS2010 has displayed no errors related to loading Connector/NET 6.3.6 package.

Setting the status to Verified

Launching the VS2008 "About" box didn't fix the VS2010 issue for me.

Same problem here, this worked for me:

"closed VS2010
and summoned the About box in VS2008 installed on the same machine."

+

"/ResetSkipPkgs"

Not sure which one was the correct, but seems to work now. 

Cheers

There is a workaround for the problem:

Start Visual Studio with /rootSuffix Exp (labeled in the Start menu as "Start Experimental Instance of Microsoft Visual Studio 2010 SP1"):

"C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /rootSuffix Exp

Now I am not sure if it is Connector/NET problem

Still doesn't work for me:

* Close VS2010;
* Open VS2008;
* "Help -> About";
* Close VS2008;
* Run "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /ResetSkipPkgs
* "Help -> About";
* "The 'MySQL Connector Net 6.3.6' package did not load correctly.

Richard, run it with "/rootSuffix Exp" to workaround the problem.

"C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /rootSuffix Exp

This bug is a duplicate of bug #55623.
I also provided details where it is broken and why.

I followed the instructions on the last post regarding running the IDE from the command line adding the /rootSuffix Exp. That blew away all of my settings in VS2010 so I had to start over. It also blew away my project list. Yes this worked and the connector was finally recognized.

However, when I launched the IDE as normal, everything was there with my project list and MySQL failed to load again.

Are you saying that in order to get this to work I have to run this from the command line every time I want to do anything with mysql other than code the data source in C#? I sure hope not.

Jon,

This bug is marked as duplicate.
Read this post to check the progress:

http://bugs.mysql.com/bug.php?id=55623