0

I'm developing an application in ASP.NET VB 2010. My database is MySQL based. For that I have installed the MySQL version 5.0 and also SQLYOG IDE. I want to display the data from my database in a listview, so I use the sqldatasource1 but while choosing the datasource, it wont show the MySQL database name in the list. Then I installed net/connector 6.8.3 and added a reference to sql.data.dll. But it doesn't work.

My second question is: what is way to connect MySQL database through the Microsoft ODBC data source?

Stefan Over
  • 5,851
  • 2
  • 35
  • 61
firefly
  • 419
  • 1
  • 8
  • 18
  • 1
    you need to install [mysql Connector/Net](http://dev.mysql.com/downloads/connector/net/) then you can see `MySQL Database` in Data source list. http://dev.mysql.com/doc/refman/5.1/en/connector-net-visual-studio-making-a-connection.html – Damith Jan 02 '14 at 10:12
  • i installed mysql connector.. and your link is for adding the data source....my question is mysql database is not present in the data source list...while select other ...the mysql wont come in list.... – firefly Jan 02 '14 at 10:16
  • http://stackoverflow.com/questions/16879451/mysql-data-source-not-appearing-in-visual-studio – Nagaraj S Jan 02 '14 at 10:17
  • ok sir... i will check it first then back..... – firefly Jan 02 '14 at 10:24
  • now i have installed the net connector 6.5.4.... but it alsodoes not show the mysql databse – firefly Jan 03 '14 at 04:27
  • yeppee.... now it works................wow – firefly Jan 03 '14 at 04:31
  • firefly, how did you get it to work? – Jimmyt1988 Apr 29 '15 at 15:43

1 Answers1

0

Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows

refer

Nagaraj S
  • 13,316
  • 6
  • 32
  • 53