Bug #62176 MySQL Website Configuration Tool does not show in VS10
Submitted: 16 Aug 2011 11:08 Modified: 10 Oct 2013 23:54
Reporter: David Newcomb (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Documentation Severity:S2 (Serious)
Version:6.4.3 OS:Windows
Assigned to: Daniel So CPU Architecture:Any

[16 Aug 2011 11:08] David Newcomb
Description:
My set up:
----
Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRel

Installed Version: Professional

Microsoft Office Developer Tools   01018-532-2002102-70796
Microsoft Office Developer Tools

Microsoft Visual Basic 2010   01018-532-2002102-70796
Microsoft Visual Basic 2010

Microsoft Visual C# 2010   01018-532-2002102-70796
Microsoft Visual C# 2010

Microsoft Visual C++ 2010   01018-532-2002102-70796
Microsoft Visual C++ 2010

Microsoft Visual F# 2010   01018-532-2002102-70796
Microsoft Visual F# 2010

Microsoft Visual Studio 2010 Team Explorer   01018-532-2002102-70796
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Web Developer 2010   01018-532-2002102-70796
Microsoft Visual Web Developer 2010

Crystal Reports Templates for Microsoft Visual Studio 2010   
Crystal Reports Templates for Microsoft Visual Studio 2010

Hotfix for Microsoft Visual Studio 2010 Professional - ENU (KB2542054)   KB2542054
This hotfix is for Microsoft Visual Studio 2010 Professional - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2542054.

Microsoft Visual Studio 2010 SharePoint Developer Tools   10.0.30319
Microsoft Visual Studio 2010 SharePoint Developer Tools

MySQL Connector/Net   6.4.3
Data design and management tools for MySQL.  Copyright © 2007-2011 Oracle, Inc.

Security Update for Microsoft Visual Studio 2010 Professional - ENU (KB2251489)   KB2251489
This security update is for Microsoft Visual Studio 2010 Professional - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2251489.
----

It never saw it in 6.3.7 either which is why I upgraded to 6.4.3.

I've been going through all the bug reports and can see that this is something that breaks on a fairly regular basis and depends (somewhat) on service packs etc.

On page: http://dev.mysql.com/doc/refman/5.5/en/connector-net-visual-studio.html
It says that there are new versions of: mysql.data.ef.dll and mysql.visualstudio.dll.
I could find mysql.visualstudio.dll but couldn't find mysql.data.ef.dll

While you are fixing it, perhaps you could update the documentation to list the options that can be used for those people who want to edit the web.config by hand or for when it breaks next!

How to repeat:
Uninstall previous mysql-connector-net version.
Install mysql-connector-net-6.4.3.msi
Start Visual Studio 10
[16 Aug 2011 11:08] David Newcomb
Tried creating several different kinds of projects but couldn't get the icon to appear on any of them.
[23 Sep 2011 17:15] Gabriela Martinez Sanchez
Recommendation: Please try installing VS 2010 SP 1 and let us know if the bug still happening.
[23 Oct 2011 23: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".
[25 Oct 2011 10:08] David Newcomb
I installed SP1 and it didn't make any difference.

I suspect that there is something wrong with my PC as it is having unknown security errors with IIS/NET modules. I don't know what the problem is so I won't be able to retry until I re-image the PC (which won't be for ages).
[25 Oct 2011 10:09] David Newcomb
I did ask for an update to the documentation. So if you do that then you can close this bug.

I'll start a new bug if the VS10 still doesn't work after a re-image.
[14 Feb 2012 18:04] Gabriela Martinez Sanchez
Thank you for this bug report, Could you please tell us if the problem is still happening?
[15 Feb 2012 11:08] David Newcomb
Have you updated the documentation to list the options that can be used for those people who want to edit the web.config by hand?
[15 Feb 2012 18:49] Gabriela Martinez Sanchez
Hi David, I found a post in one of the official documentation pages which looks pretty complete about it. Please check it out and let us know if this helps for the web configuration without using the web config tool of the Connector. Here's the link http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-roles.html
[16 Feb 2012 12:23] David Newcomb
Not really.

The following page covers all the options you need if you were using a connectionString:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html

So we would need something similar for your implementation of Session State Provider, Membership provider, etc
In fact the following page gives a few nice examples, but the examples don't provide an inclusive list of all the options (only the ones you need to use Devart).
http://www.devart.com/dotconnect/mysql/articles/aspproviders.html
[16 Feb 2012 20:42] Gabriela Martinez Sanchez
Hi David, I did some research about this subject and I found a lot of documentation that includes really good information on it. Also in our site there are a couple more resources besides the one I mentioned. We as developers don't have direct access over the documentation that is published on the site but we do have a really good resource that is the blogs for the product. This could be the place were we can put together all the information regarding the providers model that could be more helpful for the users.

Here are the others links:

http://dev.mysql.com/doc/refman/5.0/en/connector-net-programming-asp-provider.html

http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-provider-session-state....

http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-provider-profile.html

Hope you can find this helpful.

Regards.
[17 Feb 2012 10:16] David Newcomb
Well perhaps you understand my problem. I too, had to do an awful lot of research to find the answers. There are plenty of forums filled with questions about how one configures this driver; this information really ought to be centralised on your website.
http://dev.mysql.com/doc/refman/5.1/en/connector-net.html
In fact I was originally looking for documentation when I found your plugin!

When MySQL was run by MySQL all the developers could update the documentation. Would if help if we change the category to "MySQL Connector/Net -Documentation"?
[4 May 2012 14:47] Gabriela Martinez Sanchez
Bug Category changed to Documentation since this is a documentation issue.

The user requested to centralize the documentation for the options available to set the web.conf file; either by using the Connector Web Configuration tool or by hand, which is the information that he sees less completed. We as developers don't have access to update the official documentation, that's why  we're forwarding it to the documentation team. 

Please email us if you need any further information.
[10 Oct 2013 23:54] Daniel So
As requested, pages with information for manually editing the web.config file are now referenced on http://dev.mysql.com/doc/refman/5.6/en/connector-net-website-config.html.
[10 Oct 2013 23:58] Daniel So
Posted by developer:
 
Changed this into a documentation bug, as per discussions in the ticket.