Bug #70078 Visual Studio Server Explorer Add Connection Wizard closes when entering data
Submitted: 18 Aug 2013 19:52 Modified: 14 Jul 2015 21:34
Reporter: David Harrison Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Visual Studio Integration Severity:S2 (Serious)
Version:6.7.4 OS:Windows (Win 7 Pro)
Assigned to: Luis Penunuri CPU Architecture:Any

[18 Aug 2013 19:52] David Harrison
Description:
I am using Microsoft Visual Studio 2010 as follows :
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

and mysql-connector-net-6.7.4 which supposedly installed correctly.

Whenever I try to Add a MYSQL connection in VS Server explorer, the window closes as soon as I try to enter anything.

I have seen similar, but much older reports of this in this forum, but this is using the bang up to date 6.7.4 MYSQL .NET connector.

How do I fix this?

How to repeat:
Open Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Create test C# Windows Forms project if necessary.

Show Server Explorer

Launch : Data Connections->Add Connection form.

Try to enter something - the form closes right away.

Suggested fix:
No idea.
[20 Aug 2013 15:30] Gabriela Martinez Sanchez
David,

This is not a bug but a misunderstanding about the changes that occurred in this last version of Connector/Net. From this version (6.7.4) and on the Visual Studio Integration functionality is placed into a new product called MySql for Visual Studio, the latest version of this tool is 1.0.2 and you can download it at 
http://dev.mysql.com/downloads/windows/installer/ 

as part of the MySql windows installer (since this product cannot be downloaded alone yet).

You can have more information regarding this here:

http://www.mysql.com/why-mysql/windows/visualstudio/

Please install it and you should be able to create any connection at the Server Explorer window, Routine debugging and Database first with Entity Framework.

Hope you can give us some feedback on this.
[20 Aug 2013 16:38] David Harrison
I installed it precisely the way you said -  the MySQL for Visual Studio 1.0.2 as part of the overall MySQL for Windows installer. I tried both 32 bit and 64 bit versions of MySQL for Visual Studio 1.0.2.

I still can't use the Add Data Connection wizard in VS 2010 Server explorer. It still disappears as I initially reported.

I am using VS 2010. The requirements say I need VS 2012 - is that the problem?

Does this mean that MySQL for Visual Studio 1.0.2 won't work on VS versions older than 2012?

Thanks.
[6 Sep 2013 15:03] Gabriela Martinez Sanchez
This product (MySql for Visual Studio) should work out of the box for the Visual Studio integration with 2008, 2010 or 2012, like in this case when connecting to a MySql database in the server explorer. Is your OS a 32 or 64 bit version?.. I wonder if that would make a difference. This error could be due to a corrupted installation. So it might be useful to make a repair. 
 
Please try this last option (repair) and let us know if that worked for you.
[7 Oct 2013 1: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".
[5 Nov 2013 7:45] Gregor Morris
Has this issue been resolved or a workaround proposed.
I too am having the same issue.  I'm using VS 2012 with update 3.  I have installed the MySQL Installer 5.6.14.0 and the mysql connector 6.7.4.
However when I try to add a connection, the dialog disapears on the first keypress.
This was working before I updated with VS update 3.  Since then I have uninstalled and reinstalled all MySQL s/w but nothing is working. Do I need to look for some un-removed dlls or tweak a config file?
[5 Nov 2013 14:31] Gabriela Martinez Sanchez
hi Gregor,
Have you installed the MySql for Visual Studio product? Besides the Connector/Net you also need this new product. This was a change since the 6.7.4.

Thanks for your feedback.
[6 Nov 2013 8:07] Gregor Morris
Hi Gabriela,
I installed everything in the 5.6.14.0 installation msi, including the MySQL for visual Studio 1.0.2.   I have just uninstalled all MySQL s/w (including manually removing some of the registry entries, especially for MySQL for Visual Studio (which reportedly failed to uninstall).
On reinstalling the 'developer' installation on the 5.6.14.0 msi, the MySQL for visual studio failed to install.
However before giving up, I tried an approach you recommended in another post (http://forums.mysql.com/read.php?38,589936,589991#msg-589991) and ran the installer directly.  This presented the components of the install separately, and I choose to set the 'EF Integration' to install on demand as it stated that it required 0 bytes.
The install ran correctly, and I have finally been able to add a connection to my db.
No idea why this worked, or failed, but am now back in business.
Regards

Greg
[14 Nov 2013 3:17] Carlos Torres
Please Gabriela, read the post "Try to enter something - the form closes right away." and you answer: NO BUG!!! please!!!!!! yo try to introduce, for example, the user name and when you type the fist letter the dialog close!! come on!!!! NO BUG????
[25 Nov 2013 16:53] Gabriela Martinez Sanchez
Hi Carlos,

Are you still having this issue?. This issue was due to a wrong registration of the Data Provider.

With Connector/net 6.7.4 there was a change on the product that is not doing the registration of the data provider. This process is covered by MySql For Visual Studio 1.0.2. 

Have you installed MySql for Visual Studio 1.0.2 yet?. You can download it from
http://dev.mysql.com/downloads/windows/installer/ 
since is part of the MySql Windows Installer.

Hope you can give us more information so we can identify what is causing you the issue.

Thanks in advance,
[27 Nov 2013 4:53] Bonnie Kirkpatrick
I am having this issue as well, and I HAVE INSTALLED MySql For Visual Studio 1.0.2
[27 Nov 2013 7:33] Bonnie Kirkpatrick
I figured out what the problem was in my case.  I have 64-bit Windows and run everything 64-bit, including MySQL.  Of course Visual Studio only comes in 32-bit.  So I uninstalled MySQL for Visual Studio and reinstalled it in 32-bit.  Problem solved. Not only does that window not disappear, I can successfully connect to MySQL databases.

I suggest you try the same.  I just uninstalled it in the Control Panel and then used the MySQL Installer to reinstall it, but made sure I chose the 32-bit version.  Why 64-bit is even available, I do not know.  There is no 64-bit Visual Studio.
[27 Nov 2013 16:55] Gabriela Martinez Sanchez
Hi Bonnie,
I'm not sure to what installer you are referring to? We only have the MySql for Windows Installer on 32 bits. MySql for Visual studio is part of this installer:

http://dev.mysql.com/downloads/windows/installer/

And it is only for 32 bits.

Did you download any other installer?

Thanks.
[27 Nov 2013 19:16] Bonnie Kirkpatrick
Right, the installer is 32-bit, but it says right there on the page you linked to that it will install both 32-bit and 64-bit binaries.  There is a drop-down that lets you choose  32-bit, 64-bit, or "Any."  My problem was resolved after uninstalling MySQL for Visual Studio and reinstalling it in 32-bit.
[26 Aug 2014 20:16] Gabriela Martinez Sanchez
Hi Bonnie,

We have a new standalone installer for the MySQL for Visual Studio product, so you can install it directly with out having to download MySQL for Windows Installer.

If you like to take a look you can download it from:

http://dev.mysql.com/downloads/windows/visualstudio/

Hope this works for you.

Thanks!
[27 Sep 2014 1: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".
[6 Feb 2015 7:40] Tanveer Ahmad
http://i.stack.imgur.com/sOxyV.png

How can I add mySQL Database to such dialog?

This is what I have done so far:

Installed mySQL Connector v.6.9.5
Installed mySQL server v.5.7.5
Installed mySQL for visual studio v.1.2.3
Restarted n-times my Windows 8.1 machine
Read all about how well mySQL Connector works on previous versions of Visual Studio

Please someone help me as i am the victim of frustration due to this issue.......
[14 Jul 2015 20:19] Javier TreviƱo
Hi Tanveer, the MySQL data provider should be appearing there after installing MySQL for Visual Studio without doing anything else.

What version of MySQL for Visual Studio did you install and what version of Visual Studio did you install it onto?

Thanks
[14 Jul 2015 21:34] Luis Penunuri
Hi.

I was unable to reproduce this issue.

These are the steps I did:
1. Install VS2010 - SP1 (Version 10.0.40219.1 SP1 Rel).

2. Download and install "mysql-connector-net-6.7.4.msi" and "mysql-visualstudio-plugin-1.0.2.msi"

* http://downloads.mysql.com/archives/get/file/mysql-connector-net-6.7.4.msi
* https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.0.2.msi

3. Open VS2010

4. Show "Server Explorer", and right click on "Data Connections" to select the "Add Connection ..." menu

5. The "Choose Data Source" popup window was shown. In there, I clicked on all the options, hit a lot of keys randomly and the window did not close. I was able to select "MySQL Database" provider, enter the server name, user name and password options, and the new connection was finally added to the "Data Connections" tree successfully.

Also, I tried the same steps as above, but using "MySQL Installer 5.6.25" (http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-5.6.25.0.msi) - which installed "mysql-connector-net-6.9.6" and "mysql-visualstudio-plugin-1.2.3" - and the error wasn't present either.