'Microsoft.Jet.OLEDB4.0' provider not registere

satyag · June 15th, 2004, 03:59 PM

hi,
   I am new to ASP.net. I am trying out an example of using Access database from ASP.net. But when I am trying to access the page, I am getting the following error.

[OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).]

[InvalidOperationException: The 'Microsoft.Jet.OLEDB4.0' provider is not registered on the local machine.]
   System.Data.OleDb.OleDbConnection.CreateProviderEr ror(Int32 hr) +83
   System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString constr) +107
   System.Data.OleDb.OleDbConnection.Open() +203
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState) +44
   System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
   ASP.datacontrol1_aspx.Page_Load(Object Sender, EventArgs E) in C:\BegASPNET\Ch01\datacontrol1.aspx:21
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731

If anyone can help me with this error, it would be great.

thank you,
Satya.

Hal Levy · June 15th, 2004, 04:06 PM

Id' move this question to the Access forum... or the ASPX forum...

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

melvik · June 16th, 2004, 04:36 AM

If u use Access fro ur ASP pages asa DataSet u r in right place!
but about ur question, can u plz send ur Code insted of error!

Always:),
Hovik Melkomian.

satyag · June 16th, 2004, 04:29 PM

hi,
  Here's the code for my program.

<%@ Page Language="vb" debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="vb" runat="server">
Sub Page_Load(Sender As Object, E as EventArgs)

    Dim objConnection as OleDbConnection
    Dim objCommand As OleDbDataAdapter
    Dim strConnect As String
    Dim strCommand As String
    Dim DataSet1 As New DataSet

    strConnect = "Provider=Microsoft.Jet.OLEDB4.0;"
    strConnect += "Data Source=C:\BegASPNET\Ch02\grocertogo.mdb;"
    strConnect += "Persist Security Info=False"

    strCommand = "SELECT ProductName, UnitPrice FROM products"
    objConnection = New OleDbConnection(strConnect)
    objCommand = New OleDbDataAdapter(strCommand, objConnection)
    objCommand.Fill(DataSet1, "products")
    DataGrid1.DataSource=DataSet1.Tables("Products").D efaultView
    DataGrid1.DataBind()
End Sub
</script>

<html>
<head>
<title> Data Grid Control example </title>
</head>

<body>
<asp:DataGrid id="DataGrid1" runat="server" />
</body>
</html>

thank you,
Satya.

Imar · June 17th, 2004, 02:08 AM

Hi there,

I think you're missing a dot between OleDb and 4.0:

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect += "Data Source=C:\BegASPNET\Ch02\grocertogo.mdb;"
strConnect += "Persist Security Info=False"

When in doubt with your connection strings, check out this page:

http://www.able-consulting.com/ADO_Conn.htm

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

melvik · June 17th, 2004, 03:10 AM

Yes Exactly u r right Imar! it should be

Code:

"...Provider=Microsoft.Jet.OLEDB.4.0;..."

In other hand I suggest to use

Code:

[u]Server.MapPath</u>

Always:),
Hovik Melkomian.