Bug #60462 Mysql connector missing when trying to add reference
Submitted: 14 Mar 2011 16:27 Modified: 6 Mar 2012 23:26
Reporter: Robert Gebis Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.3.6 OS:Windows (XP x32)
Assigned to: Gabriela Martinez Sanchez CPU Architecture:Any
Tags: VS 2010

[14 Mar 2011 16:27] Robert Gebis
Description:
I just installed fresh XP x32 in VirtualBox 4.0.4. After updating all service packas I installed VS2010. Then I proceeded with installation of MySQL .Net connector 6.3.6. While as reported in other thread, framework 4.0 is required to successfully install 6.3.6. After everything was installed I checked out my existing project from svn. My project is build with framework 3.5. I see that MySQL is distributed with 2.0 and 4.0 versions. This is my first attempt to build this project under VS2010. Before I was building it with 2008 and 6.3.6 on other machine and it was all fine. VS2010 now complains that it can't reference Mysql .net connector. So I try to remove it from references and re-add it. When Add References Dialogbox was opened I do not see Mysql under .NET tab. This is strange because my friend that is working with me on this project also is using VS2010 and he has Mysql under .NET tab.  I tried to uninstall and reinstall 6.3.6 and same deal. HE also have VS 2008 installed where I do not. Not sure if that make difference to installer but I just want to point this out. Also since my install is clean I did not have any previous versions of mysql dot-net connector installed. Where hi did. Perhaps this also makes difference to installer? I am able to manually browse to mysql dll and add it to project. My friend confirmed that on his other x64 Win7 dev box he still sees Mysql under .NET tab even he is targeting 3.5.

How to repeat:
Install clean XP x32 under VirtualBox (I do not think this is related to virtual box)
Install VS2010 only with all updates
Install Mysql Connector 6.3.6
Create C# project (targeting 3.0 or 3.5) and try add reference.
If Project is targeting 2.0 or 4.0 all it good. Just problem when 3.x is targeted.

Suggested fix:
Manually browse to mysql dll and add it to project. Problem is that if working under x32 vs x64 project references c:\Program Files (x86)\ vs c:\Program File\ causing each person to manually add himself and possibly checking it in messing others projects.
[14 Mar 2011 16:53] Valeriy Kravchuk
Looks like a duplicate of Bug #60404. Please, check.
[14 Apr 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[4 Nov 2011 21:34] Dave Adams
I don't think this is a duplicate -- it seems like a separate issue.

I have two machines; one that exhibits the problem, and one that doesn't.  The one with the problem has only VS2010 installed.  The one without the problem has both VS2008 and VS2010 installed.  I think there's some hidden dependency on the .NET 3.5 framework.  Can you test on a machine that has only ever had VS2010 installed?
[14 Nov 2011 13:03] Bogdan Degtyariov
Verified with Connector/NET 6.4.4.
The assembly has not been displayed in the references.
However, this bug is not S2-critical as the workaround is pretty obvious and easy. Setting verified as S3.
[6 Mar 2012 23:26] John Russell
Added to changelog for 6.3.8, 6.4.5, 6.5.4: 

When creating a project in VisualStudio using a .NET framework such
as 3.0 or 3.5 (anything less than 4.0), the Connector/Net library
(MySql.Data.dll) was not listed in the Add References dialog box. The
workaround was to browse to the library and add it manually.