MySQL Bugs: #65588: MySQL Connector 6.5.4 fails to register as a DataProvider in registry and VS2010

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:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.5.4	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	workaround

Description:
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.

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.

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.

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.

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.

Thanks.

log file output from -> msiexec /l* log.txt /i mysql-connector-net-6.5.4.msi

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

I just uploaded the log.  I have the same exact problem, but with Windows 8 RTM and VS 2012 release.  Thanks!  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!

Hi,

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.

Thanks.

Hello,

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.

Thanks

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.

Thanks

Verbose log of failed 6.5.6 install

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

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.

And the IDE is 
Visual Studio 2012 Ultimate

For good measure here is a log of the successful 6.4.4 install

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

Hi,

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).
HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall\{2DDC7E93-29AB-4260-A9DB-697F7FA88157}

(there's also this one used for 6.3.8 in case you could have it too
HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall\{E720BB76-38AA-43EF-A638-508DDE124FE0}
)

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.

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/

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.

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
https://dev.mysql.com/downloads/connector/net/
https://dev.mysql.com/downloads/windows/visualstudio/

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.