Bug #38327 Add Connection Dialog of server explorer closes instantly when text is typed.
Submitted: 24 Jul 2008 5:11 Modified: 29 Jul 2008 9:38
Reporter: Joakim Westin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.2.2 OS:Windows (Vista 32-bit with SP1)
Assigned to: CPU Architecture:Any
Tags: "Visual Studio 2008" Connector Crash

[24 Jul 2008 5:11] Joakim Westin
Description:
I have a freshly installed machine with Visual Studio 2008 Professional, MySql GUI tools and the MySql Connector 5.2.2.

When I try to add a new connection using Visual Studio I have the same crash as explained in the previous Bug #23071.

I will try to overcome this by fixing the machine.config file.

But I want this to be fixed so the installer doesn't do a faulty installation.

My version of Windows Vista is Business 32-bit Swedish.

/Joakim

How to repeat:
Please see Bug #23071

Suggested fix:
Please see Bug #23071
[24 Jul 2008 5:38] Joakim Westin
I tried to do as follows:

added this to the 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=5.1.2.2, Culture=neutral,PublicKeyToken=c5687fc88969c44d"/>
    </DbProviderFactories>
</system.data>

I also verified that the MySql.Data.dll is inthe global assembly cache.

Unfortunately it still does not work. 

Any suggestions?
[24 Jul 2008 6:37] Tonci Grgin
Hi Joakim and thanks for your report.

As I was about to say, this report is probably not a duplicate of Bug#23071. Finding someone with VS2008Pro to check this out properly.
[28 Jul 2008 19:35] Reggie Burnett
This is because for some reason the installer wasn't able to update the registration of the assembly.  I know this is not a bug in 5.2.2 in general because many are using 5.2.2 just fine.

Also, in your snippet where you tried to manually register in machine.config you listed the version as 5.1.2.2.  It should be 5.2.2
[29 Jul 2008 5:50] Joakim Westin
So I should try to re-register the assembly. Will try that, since I still can not use the provider within VS 2008.

Thanks for pointing me to the error in the macine.config section.

/Joakim
[29 Jul 2008 5:54] Joakim Westin
I manually added the MySql.Web DLL to the global assembly cache and now it works fine.

Thanks for the tip.

/Joakim
[29 Jul 2008 9:38] Tonci Grgin
Joakim, glad it works now. Closing the report.