Problem with MDAC version?
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:
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<SCRIPT LANGUAGE="C#" Runat="server">
OleDbDataAdapter dbCommandA;
OleDbCommand dbCommand;
DataSet ds;
static String pathinfo="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:/InetPub/wwwroot/database/Sample.mdb";
OleDbConnection con = new OleDbConnection(pathinfo);
String SQL;
void Page_Load(){
SQL = "Select * from sam Order by lastName";
dbCommandA = new OleDbDataAdapter(SQL,con);
ds = new DataSet();
dbCommandA.Fill(ds,"users");
users.DataSource = ds.Tables["users"].DefaultView;
users.DataBind();
}
</SCRIPT>
<HTML>
<HEAD>
<STYLE TYpe="text/css">
TD{font-family:arial; font-size=
10pt"}
</STYLE>
</HEAD>
<BODY>
<asp:datalist width="100%" id="users" runat="server">
<HeaderTemplate>
<Table cellpadding="5" style="border-collapseLcollapse" border="1">
<tr>
<td><b>LastName</b></td>
<td><b>firstName</b></td>
<td><b>City</b></td>
<td><b>State</b></td>
<td><b>Income</b></td>
<td><b>Enter Date</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#DataBinder.Eval(Container.DataItem,"lastName")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"FirstName")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"City")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"State")%></td>
<td align="right"><%#DataBinder.Eval(Container.DataItem,"AnnualIncome")%></td>
<td align="right"><%#DataBinder.Eval(Container.DataItem,"EnterDate")%></td>
</tr>
</ItemTemplate>
<FooterTemplate></Table></FooterTemplate>
</asp:DataList>
</BODY></HTML>