Problem with MDAC version?

**cooldudeattitud** · Nov 19th, 2003, 11:53 AM

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>

**cooldudeattitud** · Nov 19th, 2003, 12:24 PM

Is there any other way to connect to access database other than OLEDB. I mean can we do that using ODBC.

Thread: Problem with MDAC version?

Thread Tools

Display

Problem with MDAC version?

Posting Permissions