[Mono-dev] help with mysql connection

Sat Jan 28 09:58:29 EST 2006

Hi,

I am trying to connect to Mysql from an example running under xsp2

here is my code:

<%@ Page Language="C#" %>
<%@ Import Namespace="System" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.Odbc" %>

<html>
<head runat="server">
  <title>GridView Bound to SqlDataSource</title>
</head>
<body>
  <form id="form1" runat="server">
    <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1"
runat="server" />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"   
     ConnectionString="DRIVER={MySQL ODBC
3.51Driver};SERVER=localhost;DATABASE=XXXXX;USER=root;PASSWORD=XXXXX;OPTION=3;"

      ProviderName="System.Data.Odbc" SelectCommand="XXXXXXXXXXXXXXXXXX">

</asp:SqlDataSource>

  </form>
</body>
</html>

I am having this error:

System.ArgumentException: Keyword not supported :DRIVER

I have been looking for a solution in google for some  days  and  I
couldn't  find anything.

Can someone help me ?

Thanks in advance !