MySQL Bugs: #23071: Add Connection Dialog of server explorer closes instantly when text is typed.

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:	Windows (Windows XP Professional SP2 OEM)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	.net, connector/net 6.7.4, MySQL Tools, Visual Studio

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.

Thank you for a problem report. What exact version of Connector/Net is used?

I have the exact same problem. I'm using the .Net connector version 1.0.7.30072

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.

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.

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

I forgot to tell that I have Connector/.NET 5.0.1 Beta installed.

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.

I never had Connector/.NET 1.0.7 or prior installed.

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.

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

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.

The downloaded file name is : mysql-connector-net-5.0.1-beta.zip
You decide its version :)

Fair enough :)

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.

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

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

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.

Hi Robert,

Thank you very much. Yes, it did work! Even though I uninstalled nothing (yet!)!

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

I have the same problem with 5.0.2 of the connector, and my machine.config file is correct according to the comment above.

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?

Notes have been added to the Connector/NET and Visual Studio plugins.

I have this problem. 

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

B.R.

Ivan Flaendsdal

I have this problem. 

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

B.R.

Ivan Flaendsdal

New report: Bug#38327.

I am seeing this issue now with the current 6.2.2 and Visual Studio 2008 sp1

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)

Have the same problem in VS 2010 and VS 2008, on a windows xp workstation.

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

My platform is 64 bit. What do you make?

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.

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.

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.

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

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.

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

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,

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

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,

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".