Hi,

I am trying to connect to database using Microsoft jet OLEDB provider. It says u need a version of MDAC 2.6 or higher. But MDAC 2.6 or higher doesnt include drivers for JET OLEDB. Can Anyone give me suggestions how I can do that.HEre is my code and the error. The application is at www.purch1.cmich.edu/sample.aspx

VB Code:
  1. <%@ Page Language="C#"%>

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

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

  4.  
  5. <SCRIPT LANGUAGE="C#" Runat="server">

  6.     OleDbDataAdapter dbCommandA;

  7.     OleDbCommand dbCommand;

  8.     DataSet ds;

  9.     static String pathinfo="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:/InetPub/wwwroot/database/Sample.mdb";

  10.     OleDbConnection con = new OleDbConnection(pathinfo);

  11.     String SQL;

  12.     void Page_Load(){

  13.         SQL = "Select * from sam Order by lastName";

  14.         dbCommandA = new OleDbDataAdapter(SQL,con);

  15.         ds = new DataSet();

  16.         dbCommandA.Fill(ds,"users");

  17.         users.DataSource = ds.Tables["users"].DefaultView;

  18.         users.DataBind();

  19.     }

  20. </SCRIPT>

  21. <HTML>

  22. <HEAD>

  23.     <STYLE TYpe="text/css"> 

  24.         TD{font-family:arial; font-size=

  25.         10pt"}

  26.     </STYLE>

  27. </HEAD>

  28.  
  29. <BODY>

  30. <asp:datalist width="100%" id="users" runat="server">

  31.     <HeaderTemplate>

  32.         <Table cellpadding="5" style="border-collapseLcollapse" border="1">

  33.             <tr>

  34.                 <td><b>LastName</b></td>

  35.                 <td><b>firstName</b></td>

  36.                 <td><b>City</b></td>

  37.                 <td><b>State</b></td>

  38.                 <td><b>Income</b></td>

  39.                 <td><b>Enter Date</b></td>

  40.             </tr>

  41.     </HeaderTemplate>

  42.     

  43.     <ItemTemplate>

  44.         <tr>

  45.             <td><%#DataBinder.Eval(Container.DataItem,"lastName")%></td>

  46.             <td><%#DataBinder.Eval(Container.DataItem,"FirstName")%></td>

  47.             <td><%#DataBinder.Eval(Container.DataItem,"City")%></td>

  48.             <td><%#DataBinder.Eval(Container.DataItem,"State")%></td>

  49.             <td align="right"><%#DataBinder.Eval(Container.DataItem,"AnnualIncome")%></td>

  50.             <td align="right"><%#DataBinder.Eval(Container.DataItem,"EnterDate")%></td>

  51.         </tr>

  52.     </ItemTemplate>

  53.     <FooterTemplate></Table></FooterTemplate>

  54.     </asp:DataList>

  55.     </BODY></HTML>