I am not able to make a Report Viewer connection with Mysql, it does not appear in the "Choose Data Source" list. I believe the problem is in the "app.config" which is unconfigured could someone pass me the whole code from the "app.config" to the Mysql Connector / NET 6.9.12 Visual Studio Community 2017
The code for my entire app.config is:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="Gold_Business.Properties.Settings.bgmysqlConnectionString"
connectionString="server=localhost;user id=root;database=bgmysql"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
</startup>
</configuration>
When replacing the code below in the above code the problem persists because the other parts of the code are not correct with the error below the code. How should get the entire "app.config" to the for the MySQL Connector / NET 6.9.12?
<connectionStrings>
<add name="myDatabaseConnection" connectionString="server=localhost;user=root;database=mydatabase;port=3306;password=mypassword;" />
</connectionStrings>