Asp.net Connection To Mysql Database With Odbc.net

funkster · Apr 28, 2012

Hi I have recently start to dabble with asp.net and will like to know how i connect to a mysql database using odbc.net or ado.net does not matter.i have tried but i always get a error telling me that the odbc connection type is not supported or invalid.i did include the odbc namespace but even that it does not want to load I also tried to add the arrangement name but not even that wants to load can someone help please. Here is My odbc connection code <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.ODBC" %> <%@ Page Language="VB" Debug="true" %> <html> <script language="vb" runat="server"> Sub Page_Load(sender as Object, e as EventArgs) BindData() End Sub Sub BindData() Dim strConnString As String = "Dsn=dsnname;Uid=username;Pwd=password;database=dbn ame" Dim strSQL As String = "select * from smallholding" Dim myConn As New OdbcConnection(strConnString) 'error is here with the OdbcConnection End Sub </script> <body> <asp:datagrid id="dgPopularFAQs" runat="server" BorderWidth="0" CellPadding="2" Width="100%" Font-Name="Verdana" Font-Size="Smaller" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True" HeaderStyle-BackColor="Navy" HeaderStyle-ForeColor="White" AlternatingItemStyle-BackColor="#dddddd"> </asp:datagrid> </body> </html> Make note of the first line. The Microsoft.Data.Odbc.dll file should be in a directory called c:inetpubwwwrootin ----------------------------------------------------------------- <%@ Assembly Name="Microsoft.Data.Odbc" %> <%@ Page Language="VB" Debug="True"%> <%@ OutputCache Duration="120" VaryByParam="none" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> <script runat="server"> Sub Page_Load(obj As Object, e AS EventArgs) lblMessage.Text = "Connecting to MySQL under .NET" Dim Conn as New OdbcConnection("Driver={MySQL};server=???;uid=???;pwd=???;database =???;option=NUM") 'Open Connection Dim objCmd As New OdbcDataAdapter("Select Semester, Course_Code FROM errcecourse", Conn) Fill Dataset Dim ds As DataSet = new DataSet() objCmd.Fill(ds, "errcecourse") Repeater1.DataSource = ds.Tables("errcecourse").DefaultView Repeater1.DataBind() Conn.Close() End Sub </script> <html> <body> <asp:Label id="lblMessage" runat="server" /> <ASP:Repeater id="Repeater1" runat="server"> <HeaderTemplate> <table> <tr> <td bgcolor="#CCCC99" width="200">Semester</td> <td bgcolor="#CCCC99" width="200">Course Code</td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td> <%#Container.DataItem("Semester")%> </td> <td> <%#Container.DataItem("Course_Code")%> </td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr> <td bgcolor="whitesmoke"> <%#Container.DataItem("Semester")%> </td> <td bgcolor="whitesmoke"> <%#Container.DataItem("Course_Code")%> </td> </tr> </AlternatingItemTemplate> <FooterTemplate> </table> </FooterTemplate> </ASP:Repeater> </body> </html> -----------------------------------------------------------------Oops, in my code there should be a comment on the line: 'Fill DatasetYou have to download the ODBC component from Microsoft which isn't included in the default .NET framework. The default only contains components for OLEDB and SQL. You can download the ODBC component here http://www.microsoft.com/downloads/release.asp?ReleaseID=35715&area=search&ordinal=3

Asp.net Connection To Mysql Database With Odbc.net

funkster

New Member