Error Report Viewer and Mysql: Visual Studio Enterprise 2017

Asked

Viewed 566 times

0

In this case did not appear in the Report Viewer list the Mysql database after I was able to install Mysql to Visual Studio 1.27 in the case at the end of the table connection process with the database with the following error:

Failure to open a database connection

Unable to get the vendor factory for the data provider named 'Mysql.Data.Mysqlclient'

What solution to this case? in this case there is another free program to generate reports such as report Viewer and Crystal Reports for Mysql and C# (Visual Studio)

mysql report reportviewer

1 answer

0

I have installed the extension "Mysql for visual studio version 1.2.6 by Oracle inc" here in my visual studio and it is working perfectly. Probably what is happening is that you are passing wrong or insufficient information to make the connection to the database, because I use reportviewer and mysql as well.

Here is my connection string : Public Stringconnection As String = "Driver={Mysql ODBC 5.1 Driver};" + "Server=" & me.enderServitor & ";Database=" & me.Databasename & ";uid=user;pwd=password;option=3"

Browser other questions tagged mysql report reportviewer

You are not signed in. Login or sign up in order to post.