Bug #65588 MySQL Connector 6.5.4 fails to register as a DataProvider in registry and VS2010
Submitted: 11 Jun 2012 20:36 Modified: 23 Jun 2016 6:06
Reporter: Alexander Alexandorov Email Updates:
Status: Can't repeat Impact on me:
Category:Connector / NET Severity:S1 (Critical)
Version:6.5.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: workaround

[11 Jun 2012 20:36] Alexander Alexandorov
After installing MySQL Connector/Net 6.5.4 with Entity Framework and Visual Studio integration, it register in machine.config but no registry changes and cannot see MySQL database both in Server Explorer / Connect to Database and Entity Framework create a new Entity Model - simply MySQL does not show in the "Choose Data Source" menu.

How to repeat:
Install MySQL Connector/Net on any Visual Studio 2010 SP1.
[6 Jul 2012 18:33] Rob Haden
I encountered the same problem recently. I was able to resolve the issue simply by uninstalling the MySQL Connector and reinstalling it. I think the issue is caused by the MySQL Connector being installed before Visual Studio is installed.
[1 Aug 2012 7:39] Mandar Damodare
Same problem. I have installed Visual Studio 2005 professional and then connector 6.5.4 on Windows XP SP3. But not able find Mysql Data Provider in "Choose DataSource" option.
[2 Aug 2012 19:21] Alexander Alexandorov
I was able to work around the issue by installing Visual Studio on a virtual machine, install MySQL Connector Net 6.5.4 on it, then copying the folder "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions\Oracle" from the virtual machine to the "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions" folder on the machine experiencing the issue. After restarting Visual Studio, I was able to see the connector and everything worked as expected ever after.
[9 Aug 2012 0:37] Fernando Gonzalez.Sanchez
Thank you for this bug report. 

This sounds like a permission error when installing, can you provide the installer log, by installing Connector/NET in the problematic environment using this line:

msiexec /l* log.txt /i mysql-connector-net-6.5.4.msi

Once run, please upload the log.txt file.

[4 Nov 2012 22:21] Todd Booth
log file output from -> msiexec /l* log.txt /i mysql-connector-net-6.5.4.msi

Attachment: log.txt (text/plain), 102.13 KiB.

[4 Nov 2012 22:22] Todd Booth
I just uploaded the log.  I have the same exact problem, but with Windows 8 RTM and VS 2012 release.  Thanks!  Todd Booth
[6 Nov 2012 9:14] Todd Booth
I've reproduced the problem, as follows.
1) Clean install of Win 8x64
2) Clean install of VS 2012
3) Clean install of 6.5.4

Same exact problem.  

I then tried the above hack to copy the Oracle folder into the programs areas. 

Same exact problem.

Please immediate confirm that you have reproduced the problem, thanks!
[6 Nov 2012 14:34] Fernando Gonzalez.Sanchez

Connector/NET 6.5.4 is not compatible with VS2012, only the version 6.6.x (current one is 6.6.4).

The question is to reliable reproduce this with 6.6.4 with VS2012/VS2010 or with 6.5.4 and VS2010.

[4 Mar 2013 20:54] Dominique PASCAL

I have the same problem with :
 - Windows 7 x64 SP1
 - Visual basic 2010 express SP1
 - Connector .Net 6.6.5

I try uninstall Connector, reboot and install : no change.
In the machine.config, dbprovider mysql is present

I'll try on another machine asap.

[4 Mar 2013 21:00] Fernando Gonzalez.Sanchez
Hi Dominique,

Thanks for your report, please bear in mind that Connector/NET integration with Visual Studio will not work with any Visual Studio Express editions.

[5 Apr 2013 20:25] Andre Dublin
Verbose log of failed 6.5.6 install

Attachment: log.txt (text/plain), 45.47 KiB.

[5 Apr 2013 20:32] Andre Dublin
Actually meant to make a comment also.

OS: Windows 7
IDE: Visual Studio 2012
MySQL: 5.6

I've had this same problem, even though I can successfully install MySQL Connecter 6.4.4, it does not register as a Dataprovider when I want to either update my model from the database or create a new Entity Data Model Object.

Now I've attached a log file of my attempt to install 6.5.6 after I had unisntalled 6.4.4 via the msi executable and cleared my registry.  But it fails and reports that there is a version of Connector Net already installed and I have to remove it manually.

If anyone knows or can decipher what the log is telling me, where do I manually remove this.

I've already searched through and remove the appropriate files from 
C:\Program Files\MySQL
C:\Program Files (x86)\MySQL
C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\Extensions\Oracle
C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen

I've even attempted to install the necessary files maunally by extracting them from the msi executable first.

Thanks in advance, and I'll be going through the log file also.
[5 Apr 2013 20:33] Andre Dublin
And the IDE is 
Visual Studio 2012 Ultimate
[5 Apr 2013 20:46] Andre Dublin
For good measure here is a log of the successful 6.4.4 install

Attachment: log2.txt (text/plain), 405.03 KiB.

[5 Apr 2013 21:03] Fernando Gonzalez.Sanchez

First neither Connector/NET 6.4.4 or 6.5.4 are compatible with VS2012 (they only work with VS2008/VS2010).
You need to try Connector/NET 6.6.5 (which is also GA and works with VS2008/VS2010/VS2012).

Secondly as I understand, you cannot install a latest connector because 6.4.4 somewhat didn't uninstalled correctly.

So, please try this before installing 6.6.5

1) In a Visual Studio DOS prompt, with admin privileges run this commands
gacutil -u mysql.data
gacutil -u mysql.data.entity
gacutil -u mysql.web
gacutil -u mysql.visualstudio
(just to make sure they were also removed from the GAC).

2) Now check this registry key does not exist, if so delete it (is used to check for an installation of 6.4.4).

(there's also this one used for 6.3.8 in case you could have it too

The sole presence of any of the above keys will make cnet installer fail with

"A previous version of Connector/Net is installed that cannot be automatically uninstalled.  You will need to remove it manually first."

3) Now you should be able to install 6.6.5
(as usual avoid having Visual studio instances opened).

Let me know if that works.
[5 Apr 2013 21:47] Andre Dublin
Thank you Fernando that worked perfectly.
dev.mysql.com/downloads doesnt have the current version that you told me to get
I have to go to http://mysql.ntu.edu.tw/Downloads/Connector-Net/
[9 Jun 2013 16:57] Chinmay Kulkarni
Same thing happened with me 

os: win8
IDE: visual basic 2010 sp1
MySQL 5.6 
connector 6.6.5

I was unable to find MySQL server in Choose Data Source dialog.

I have searched and tried many a thing. Please help me.
[23 Jun 2016 6:06] Chiranjeevi Battula
Hello Chinmay Kulkarni,

Thank you for your feedback.
I could not repeat the issue at our end using with Visual Studio 2013, Connector/NET 6.9.8 and MySQL for Visual Studio 1.2.6.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Could you please try with latest versions Connector/NET and  MySQL for Visual Studio

Thank you for your interest in MySQL.