I am stuck in configuring SqlDataSource Object for MySQL Connector 6.8.3
(.Net Client). I have done the following so far.
<asp:SqlDataSource ID="SDS_Orders"
runat="server"
SelectCommand="SELECT * from eBayOrders"
ConnectionString="<%$ ConnectionStrings:mysql %>"
ProviderName="<%$ ConnectionStrings:mysql.ProviderName %>">
</asp:SqlDataSource>
Here is my web.config
<connectionStrings>
<add name="mysql" connectionString="server=myserverurl;user id=xyz; password=abc;database=mydb;" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
Your help in this regard will be highly appreciated.
Thanks
