Report Viewer Error and Mysql: Visual Studio Enterprise 2017

Question

Report Viewer Error and Mysql: Visual Studio Enterprise 2017

Navigation

#1 by (0 votes)

0

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

Failed to open a connection to the database

Can not get the provider factory for the data provider named 'MySql.Data.MySqlClient'

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

mysql reportviewer

asked by anonymous 26.08.2017 / 20:19

1 answer

Android Chat Socket x Firebase How to find the coordinates of a click on the Babylon.js scene?

score 0 · Answer 1

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

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