Hi
I converted from SQL server to mysql after recommendation from Microsoft?
I had change all references to
Imports System.Data.SqlClient to be Imports MySql.Data.MySqlClient
I then changed the Web.config to be
<connectionStrings>
<add name="SchoolDataConnectionString" connectionString="server=localhost;Initial Catalog=SchoolData; User Id=root; Password=########" providerName="MySql.Data.MySqlClient" />
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data" />
<add name="dotConnect for MySql" invariant="Devart.Data.MySql" description="Devart dotConnect for MySql" type="Devart.Data.MySql.MySqlProviderFactory, Devart.Data.MySql, Version=8.19.1985.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</DbProviderFactories>
</system.data>
Added References
MySql.Data Runtime version - v4.0.30319 Version - 8.0.31.0
MySql.Data.EntityFramework Runtime version - v4.0.30319 Version - 8.0.30.0
MySql.Web Runtime version - v4.0.30319 Version - 8.0.31.0
MySqlBackup Runtime version - v4.0.30319 Version - 2.3.6.1
MySqlBackupNet.DevartExpress Runtime version - v4.0.30319 Version - 2.3.6.0
MySqlBackupNet.MySqlConnector Runtime version - v4.0.30319 Version - 2.3.6.0
MySqlConnector Runtime version - v4.0.30319 Version - 1.0.0.0
If I add a system.web.ui.WebControls.SqlDataSource goto configure data source I get Error
The data provider MySql.Data.MySqlClient could not be found in the system configuration
Unable to find the requested .Net Framework Data Provider. It may not be installed.
If I go to the .aspx and edit the code
<asp:SqlDataSource ID="dsStaff" runat="server" ConnectionString="<%$ ConnectionStrings:SchoolDataConnectionString %>" SelectCommand="SELECT id, FirstN, LastN FROM StaffMaster ORDER BY FullN " ProviderName="<%$ ConnectionStrings:SchoolDataConnectionString.providerName%>"></asp:SqlDataSource>
