Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 27, 2009 10:50 AM by vhkiran
Member
23 Points
29 Posts
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
26 Points
14 Posts
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.
39 Points
19 Posts
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.......
define connectionstring in ur web config file as follows....<add name="Conn"
<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.......
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
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
btw I must say I always clear version specific configurations because mysql develops this fast.
vhkiran
Member
39 Points
19 Posts
Re: SqlDataSource together with MySql ?
Aug 27, 2009 10:50 AM|LINK