Problem Connecting To Access Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I created some very simple ASP.NET applications - form data is entered into
an Access database. There are 4 of these apps - all similar in nature and
even connect to the same database just different tables via stored queries.

All of the apps were working fine on the web server. Then I recently noticed
that a few all of the sudden stopped working. I checked thru the code on my
local machine - where I originally created them, but didn't see any
differences between the ones that worked and the ones that didn't. However
when I attempted to run in debug mode on my local system I started receiving
the same error message for all of them. If I rebuild and copy back to the
server some of them run fine, while others still do not. - there doesn't seem
to be an rhyme or reason.

Here is the error message I receive for one that works on the web server, but
not locally.

Exception Details: System.Data.OleDb.OleDbException: No error information
available: REGDB_E_CLASSNOTREG(0x80040154).

Source Error:


Line 90: // try
Line 91: //{
Line 92: oleHr.Open();
Line 93: oleInsert.Parameters["firstName"].Value = txtFirstName.Text;
Line 94: oleInsert.Parameters["lastName"].Value = txtLastName.Text;


Source File: c:\inetpub\wwwroot\con020\default.aspx.cs Line: 92

Stack Trace:


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

[InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not
registered on the local machine.]
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr)
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString
constr)
System.Data.OleDb.OleDbConnection.Open()
con020.WebForm1.cmdSign_Click(Object sender, EventArgs e) in c:\inetpub\
wwwroot\con020\default.aspx.cs:92
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.
RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain() +1292


Does anyone know what could be causing this inconsistent behavior?

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200511/1
.

Relevant Pages

  • Re: Access Database Synchronizer (ADS)
    ... I don't mind sharing my code, but it's very specialized to the apps that use and I haven't taken the time to prepare it for general use. ... > that you can't use ADS if the Access database is going to be on a Vista ... > hook-up the PDA to the cradle. ...
    (microsoft.public.sqlserver.ce)
  • Hardware? Software? Both? Strange spontaneous reboots; repeatable
    ... Everything functions re apps, so - that leaves OS, HW, or ME! ... Messy, like the power cord was pulled - black screen, ... -- The Serious Error message already men tioned above, ... -- Sometimes partial rearrangement of desktop icons and/or Quik ...
    (microsoft.public.windowsxp.hardware)
  • Hardware? Software? Both? Strange spontaneous reboots; repeatable
    ... Everything functions re apps, so - that leaves OS, HW, or ME! ... Messy, like the power cord was pulled - black screen, ... -- The Serious Error message already men tioned above, ... -- Sometimes partial rearrangement of desktop icons and/or Quik ...
    (microsoft.public.windowsxp.general)
  • Re: 16-bit processes wont start
    ... Have you run sfc.exe (System File Checker)? ... >>DOS mode apps? ... > same error message and won't execute. ...
    (microsoft.public.win2000.applications)
  • Re: Parameter problem..help is needed please
    ... > connection with an Access database is established through ... > parameter and an output parameter. ... The user inputs a value in textbox1 to ... > Why do I get this error message: ...
    (microsoft.public.sqlserver.programming)