MySQL Bugs: #70953: Add connection screen close in Visual studio 2012

Bug #70953	Add connection screen close in Visual studio 2012
Submitted:	19 Nov 2013 12:45	Modified:	1 Jan 2016 13:19
Reporter:	lionel navetier	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S1 (Critical)
Version:	6.74	OS:	Windows (8)
Assigned to:	Gabriela Martinez Sanchez	CPU Architecture:	Any

Description:
In visual studio 2012 when i try to add a connection to MYSQL the screen close if i enter something in one of the following fielde (server, user, password).

Mysql - vusial studio plugin is installed and there are no error messages

If i click on "test the connection" it says "test successful" (although no user is indicated).

How to repeat:
in visual studio try to create a new connetion with mysql

Hi Lionel,
This error can be caused due to a bad registration of the Data Provider for MySQL. To fix this you need to install the MySQL for Visual Studio 1.0.2 or the 1.1.1-beta version.

The first one is only included with the MySQL Windows Installer and you can download it from: 

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

The beta can be downloaded from:
cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

If you choose to install the 1.1.1 beta version you need to uninstall the 1.0.2 from your machine.

Please let us know if this worked for you.

Hello,
I have remove Mysql for visual studio 1.0.2 and installed 1.1.1

No i can add a connection to my SQL and see the table in the server explorer.

But when i try to add a new data entity model, a screen prompt for the connection to work with. The existing connection to mysql  is not available in the combo list and i can only add connection to SQL server database (mysql data provider doesn't appear in the list).

many thanks for your help 

Lionel

In addition to what i have previously written,  when i try to add directly a binding component to a form i get the following error message after having selected the mysql connection / " Cannot obtain provide factory for data provider named mysqlDataMysqlClient"

An update to my current issue.

I can add a connection to the Mysql server and browes the tables of the server.
but when i try to add a datasource :  I can select the connection but then I get the message "Cannot obtain provider factory for data provider named mysqlDataMysqlClient".

Any help is welcome.

Hi Lionel,

MySQL for Visual Studio product is needed to have the Visual Studio integration in order to connect with any MySQL Database. Although it is not a data provider to work within applications neither with a ADO Entity Model that uses Entity Framework. You need a MySQL Data Provider in order to do so. You can download the MySQL Connector/Net. So you will have to install it besides the MySQL for VS. Then you can add your model.

You can download the Connector/Net product on this link

http://dev.mysql.com/downloads/connector/net/

Please let us know if this works for you.

works fine now
Thank you very much

i have the same problem
after choose the connection string http://prntscr.com/9kc3zh
and press "NEXT >" the dialog close.
And nothing happen.
i can't choose which tables i want to import.
the connection string is not created on the web.config.
i have the latest products installed:
MySQL for Visual Studio 1.2.5 X86
Connector/NET 6.9.8 X86

What's wrong there?
What can i do?
Thanks

i could'nt make it work, I have implemeted the connection directly the code

@lionel navetier it's that you have added the connection string directly.
But what about the designer of the model??
How did you create that?

Hello
I fact i can't remenber what i have done. if i look back to the project i can see that i have created a datasource (type dataset).