Mysql Data Adapter Problem Asp.Net

Question

User1418733979 posted

I did try to create Crystal report in Asp.net but i can't create Mysql dataset through the data adapter sample picture bellow 

I have used localhost database connection 

After click Finish button data fields not view in data set

Answer 1

User-707554951 posted

Hi hewawasam,

From the information in Wizard Results  in first picture you provide, I suppose that two MySql.Data.ddl files exist in your application. The two MySql.Data.ddl.files have different version. However, type A originates from version=6.9.8.0, type B originates from version=6.9.9.0, which leading to conflict between them. In other words, we couldn’t convert type A to Type B.

The links below provide a solution for the issue similar to your problem, you could refer to Diego and Roberto or usr-local-ΕΨΗΕΛΩΝ’s answer

http://stackoverflow.com/questions/8605158/amysql-data-mysqlclient-mysqlconnection-cannot-be-cast-to-bmysql-data-mysqlc

http://stackoverflow.com/questions/23254507/invalidcastexception-in-windows-azure-connecting-to-mysql-db

http://stackoverflow.com/questions/28172859/switching-between-mysql-sql-server-in-ef6

Hope this can help you. If you have any question and confusion about the problem. Please don't hesitate to let me know.

Best regards
Cathy