SqlDataSource together with MySql ? RSS

• • Reply
  

  mcclausky

  Member

  23 Points

  29 Posts

  Re: SqlDataSource together with MySql ?

  Jun 24, 2009 02:58 PM|LINK

  Hi,

  This has worked for me.

  Inside the:

  <system.web>
        <pages>              section put:

              Change the Version to the exact version of your MySql.Data.dll file.
  

  Regards.
  

  mysql sqldatasource

• • Reply
  

  mascix

  Member

  26 Points

  14 Posts

  Re: SqlDataSource together with MySql ?

  Jun 25, 2009 06:34 AM|LINK

  I solve it. I forget to add assambly line at IIS6 and it was working fine there when I upgraded to IIS7 it started giving error. dont forget to add

  <add assembly="MySql.Data, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

  
  btw I must say I always clear version specific configurations because mysql develops this fast.

  BLOG
• • Reply
  

  vhkiran

  Member

  39 Points

  19 Posts

  Re: SqlDataSource together with MySql ?

  Aug 27, 2009 10:50 AM|LINK

  define connectionstring in ur web config file as follows....
  
  <add name="Conn"
    ConnectionString ="Driver={MySQL ODBC 3.51 Driver};Server=dbserver;Database=dbName;User=dbUser;Password=dbUserPass;"  ProviderName="System.Data.Odbc">
  
  
  In ur aspx page
  <%@ Import Namespace="System.Data.Odbc" %>
  
  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Conn %>" SelectCommand="SELECT country,city,event,date FROM shows" ProviderName="System.Data.Odbc"></asp:SqlDataSource>
  
  
  hope it helps.......