Bug #23071 Add Connection Dialog of server explorer closes instantly when text is typed.
Submitted: 7 Oct 2006 11:51 Modified: 25 Dec 2013 16:44
Reporter: Robert Blenkinsopp Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Visual Studio Plugin Severity:S1 (Critical)
Version:1.0.2 OS:Microsoft Windows (Windows XP Professional SP2 OEM)
Assigned to: Gabriela Martinez Sanchez
Tags: .net, connector/net 6.7.4, MySQL Tools, Visual Studio

[7 Oct 2006 11:51] Robert Blenkinsopp
Description:
When adding a new connection via the server explorer, the dialog appears correctly however the instance text is typed or pasted into one of the text boxes, the dialog closes, sometimes causing visual studio itself to spontaneously close.

This is occuring on multiple tested computers each installed with Visual Studio.net 2005 Professional Edition. This issue also occurs afrer a fresh install and multiple install attempts..

There is a MySQL 5.0 server running on the same machine and other mysql tools are also installed.

No error is shown/displayed.

How to repeat:
1. Open Server Explorer
2. Right Click Dataconnections and Click "Add Connection..."
3. In the dialog that appears select "MySQL Database"
4. Click "Continue"
5. In the "Add Connection" Dialog that appears, typing or pasting any text in any text box with make the dialog close and sometimes visual studio.

Suggested fix:
No Idea, - Look for a bug.
[7 Oct 2006 12:09] Valerii Kravchuk
Thank you for a problem report. What exact version of Connector/Net is used?
[8 Oct 2006 6:50] Lars Nikolajsen
I have the exact same problem. I'm using the .Net connector version 1.0.7.30072
[8 Oct 2006 9:17] Robert Blenkinsopp
hi,

My Version of Connecter/Net is 1.07 (Current on the downloads page)

My appologies, This is an issue with not usingt Connecter/Net 5.01 with Visual Studio Tools for MySQL. However this does highlight the fact that visual studio should give a meaningful error message and not completely close when this version of connector is not found.
[9 Oct 2006 15:30] Reggie Burnett
Robert

You are right.  I've made a note to have the plugin installer check to make sure the appropriate version of Connector/Net is installed.
[9 Oct 2006 15:35] Puiu Hrenciuc
I can confirm this bug. I also would like to add that this has nothing to 
do with Connetctor/.NET, but with MySQL Tools for VS 1.0.1 Beta. I have also
downloaded it, installed it and in VS.NET 2005, in Server Explorer, when
I am trying to create a MySQL connection it crashes without any error in 
the Server Explorer/Data Connections/Add Connection.../Choose Data Source (MySQL )/Add Connection dialog. It only crashes when you press a key ( for eg.
to write Server Name or User Name or whatever ) ...

Versions :

Windows XP SP 2 5.1.2600
VS.Net 2005 Pro 8.0.50727.51 (QFE.050727-5100)
.NET Framework 2.0.50727
MySQL Tools for VS 1.0.1-Beta
[9 Oct 2006 15:38] Puiu Hrenciuc
I forgot to tell that I have Connector/.NET 5.0.1 Beta installed.
[9 Oct 2006 15:48] Robert Blenkinsopp
That is interesting as I have encountered no further errors since I upgraded to Connector/Net 5.01, However I still also have Connector/NET 1.07 installed side by side.
[9 Oct 2006 15:54] Puiu Hrenciuc
I never had Connector/.NET 1.0.7 or prior installed.
[9 Oct 2006 16:02] Reggie Burnett
Puiu

Did you follow the instructions in the release announcement?  Connector/Net 5.0.1 has a flaw in its installer that causes this problem with the plugin.  We included instructios in the release announcement for plugin 1.0.1 beta on how to fix this.  Please review those steps and let us know if you have any questions.
[9 Oct 2006 16:25] Puiu Hrenciuc
Reggie,

Wierdly there was no such entry in machine.config, 
I have added 			
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,Version=5.0.1.0, Culture=neutral,PublicKeyToken=c5687fc88969c44d"/>

in the 
<system.data><DbProviderFactories> section

and it works just fine.

Thanks for you support,
Puiu
[9 Oct 2006 16:45] Robert Blenkinsopp
Puiu, are you sure your were using Connector/Net 5.01? Its just that 5.00 is know to not modifiy the machine.config file to add the provider.
[9 Oct 2006 16:48] Puiu Hrenciuc
The downloaded file name is : mysql-connector-net-5.0.1-beta.zip
You decide its version :)
[9 Oct 2006 17:00] Robert Blenkinsopp
Fair enough :)
[9 Oct 2006 23:55] Robert Blenkinsopp
This problem has now reoccured, with no changes made to my configuration. 

It would appear that something has happened to the data provider as visual studio is now throwing the error:

"Failed to find or load the registered .Net Framework Data Provider." 

when trying to modify exisiting connections.
[25 Oct 2006 21:48] Jim Arthur
This bug appears to be the result of not modify the machine.config file based upon the blog post found on this site with the announcement of the release of product. I do not have the site -- just encountered the same issue and fixed it with change to machine.config. Created a new bug though . . .
[28 Oct 2006 8:58] Thanassis Couloussias
Robert,
Could you please clarify what exactly to do in order to overcome this problem?
After a whole-morning struggle I only resulted in having installed
connector/Net versions 1.0.7, 1.0.8, 5.0.1 and still that damn (sorry!) thing
is not working...

Thanx in advance.
Thanassis Couloussias
[28 Oct 2006 10:20] Robert Blenkinsopp
Hi, 

Sorry for the delay in responding, the email account my MySQL accoutn is tied to is experiancing difficulties.

For a while I was back in the same boat as everybody else as my installed decided to randomly stop working again without any changes made. However I have fixed it again by unistalling all MySQL/Connector and VS.net Plugin for MySQL installs and I have then reinstalled just Connector/.NET 5.01 and MySQL Tools for visual studio 1.01.

However this still does not work due to the error in the machine.config file:

the line in the dbproviders section:

<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data"/>

Should read (thanks Puiu):

<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,Version=5.0.1.0,
Culture=neutral,PublicKeyToken=c5687fc88969c44d"/>

Once this change was made everything seamed to work again.

So far I have not experianced anymore problems.
[28 Oct 2006 10:53] Thanassis Couloussias
Hi Robert,

Thank you very much. Yes, it did work! Even though I uninstalled nothing (yet!)!
[27 Nov 2006 19:39] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/15882
[10 Dec 2006 20:04] Robin Wheeler
I have the same problem with 5.0.2 of the connector, and my machine.config file is correct according to the comment above.
[10 Dec 2006 20:26] Robin Wheeler
I notice in the patch description above that the fix is simply to check if connector 5.0.2 is installed. So I assume this problem is supposed to be fixed in 5.0.2. I'm still seeing the same symptom in 5.0.2, so does anyone have any idea what other issus may cause this prob?
[14 Dec 2006 14:40] MC Brown
Notes have been added to the Connector/NET and Visual Studio plugins.
[1 Sep 2007 16:37] Ivan Flændsdal
I have this problem. 

I have install versin 5.1.2 on a Vista machine...

B.R.

Ivan Flaendsdal
[1 Sep 2007 16:37] Ivan Flændsdal
I have this problem. 

I have install versin 5.1.2 on a Vista machine...

B.R.

Ivan Flaendsdal
[24 Jul 2008 6:37] Tonci Grgin
New report: Bug#38327.
[27 Feb 2010 17:28] Tim Odell
I am seeing this issue now with the current 6.2.2 and Visual Studio 2008 sp1
[28 Jun 2010 20:50] Alexander Wagner
I have the same problem with version 6.3.2 an VS2010 / VS2008.

Can somebody tell me the PublicKeyToken for this version (for the <add /> -line)
[10 Nov 2010 9:36] Jakob Andersson
Have the same problem in VS 2010 and VS 2008, on a windows xp workstation.
[30 Nov 2010 1:15] Heath Higgins
I am experiencing this issue on VS 2008 Professional SP2 with the latest Connector/NET 6.3.5.  For me, it seems that the Entity Data Model Wizard is causing the disappearance of the machine.config entries and related crashes, errors, etc.  Here are the steps to reproduce from a clean install:

 1. Use the Server Explorer to add a connection to the MySQL database using MySQL data provider.  It will connect successfully and expand out to show the database content.
 2. Add a new ADO.NET Entity Data Model object to the project (I was using a C# class library targeting the .NET 3.5 Framework).
 3. On the first page of the wizard, select "Generate from database" and click Next.

When the wizard transitions to the "Choose Your Data Connection" page, the previously created connection is not listed.  Also, if I have the machine.config files open in an editor such as Notepad++, I can see that the files are immediately modified, and the MySQL Data Provider entries are removed. If I click "New Connection...", I d not see the MySQL Data Provider.  

From here on, when I try to connect to the database that I already created in the Server Explorer,  I will receive the following error: 

"Unable to find the requested .Net Framework Data Provider. It may not be installed."

If I try to add a new connection through the Server Explorer, I can still select "MySQL Database" as a data source, using the ".NET Framework Data Provider for MySQL" (it is listed here but not in the wizard).  As described above, though, as soon as I enter a server name, Visual Studio crashes with no error.

After this occurs, I can go back into the machine.config and re-enter the <DbProviderFactories> entries that were added on a clean install, and then I can use the database connection again until I repeat the process listed above.  

Is this a problem with the Entity Data Model Wizard or the "Choose Your Data Connection" page, and can anyone else reproduce this behavior?  What all is going on during this wizard, and how does it interface with the MySQL Data Provider?  It is as though it fails and then automatically removes the data provider, maybe because it sees it as invalid, not registered properly, or the like.  Other wizards, such as the DataGridView's Data Source Configuration Wizard work fine.

For reference, here are the entries that were added by the Connecter/NET 6.3.5 installer:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config:
<system.data>
    <DbProviderFactories>
	  <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>

C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Config\machine.config:
  <system.data>
    <DbProviderFactories>
	<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>

Alexander, if you are still looking for your PublicKeyToken, it seems that it has not changed since the 5.0.1.0 version listed above, but if you watch your machine.config files after a clean install you should be able to confirm.

I am still unsure of exactly what is going on, but maybe this will help narrow it down.  Thanks for any help you can provide.

-Heath
[12 Mar 2012 19:57] Wilson Braun
My platform is 64 bit. What do you make?
[11 Jul 2012 6:10] sajid jebran
Hey Guys,
If anyone has found the solution to this problem, Good luck. and the others just listen, i had the same problem in Win7 64x, with VS 2010 and VS 2008. i installed all the versions of mysql connectors available on the site, but no success. finally i installed the final version 6.4.x and during the installation i choose complete install and now the problem is finished, so you guys try this it may work. Good Luck bros.
[3 Oct 2012 23:51] John Steele
I had saw this bug also with Connector/Net version 6.5.4 on Windows XP sp3 and Visual Studio 2010 Pro. I had been doing a "Typical" install until I read that a 'Complete' install fixed this. When I did a 'Complete' install, that resolved the problem.
[10 Dec 2012 17:13] richard cohen
I just tried installing and re-installing the newest MySQL Connector 6.6.4 using a complete install. I am having the same issue as everyone else. VS2010, WIN7.
[22 Apr 2013 15:46] Salman Malik
i have same problem, please someone provide the solution, i am trying to create connection through server explorer in VS2012 but when i try to write in text box  the dialog box diapers
[21 May 2013 17:02] Travis Stewart
I have this problem as well, using Connector 6.6.5, Visual Studio 2010, and Windows XP. It is a bit disheartening to see this problem has been around since 2006 but still seems to rear its ugly head.
[20 Nov 2013 22:11] Hans-Peter Martini
Same same: Connector 6.7.4; Visual Studio 2012 Ultimate Update 4; Windows 8.1

It's really great to see, that you're working on this issue, Oracle. Thank's a lot...
[21 Nov 2013 15:23] Gabriela Martinez Sanchez
Hi Hans,

This issue was caused by an incorrect registration of the Provider in the machine.config file. And it has been fixed. You can try 6.6.6 version. If you're working with Connector/Net 6.7.4 you also need to install the MySql for Visual Studio product. Have you installed it already? You can download it from  http://dev.mysql.com/downloads/windows/installer/

Since this product can be installed only with the MySQL Installer for Windows.

Can you please give it a try and let us know if this works for you?

Thanks in advance,
[21 Nov 2013 18:12] Hans-Peter Martini
Hi Gabriela,

thank you for the advice. Now I've installed only "MySql for Visual Studio", witch provides the connector in version 6.6.5. It's working for now. So I won't touch the config until I have to.

Yesterday I tried the 6.7.4 connector together with "MySql for Visual Studio". But VS than wanted to use the 6.6.5 version, unable to find it. Me for myself couldn't find any evidence of that old reference or why VS used it instead of what I configured in the web.config/reference-manager. Neither in VS, the GAC nor the regestry.

Greets and thanks a lot!

hpm
[25 Nov 2013 16:44] Gabriela Martinez Sanchez
hi Salman, Travis

Are you still having this issue?.. I would suggest you both to install Connector/net 6.6.6. It can be downloaded from: http://dev.mysql.com/downloads/connector/net/

Please let us know if it helped.

Thanks in advance,
[26 Dec 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".