Re: Class not registered error when using Web

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

From: Chris Botha (chris_s_botha_at_AT_h.o.t.m.a.i.l.com)
Date: 06/06/04


Date: Sun, 6 Jun 2004 09:51:35 -0400

One of my clients using a .NET WinApp connecting to an MS Access database on
the client computer had the problem. After downloading and installing 2.6 it
worked. They were running a lower version of MDAC though. It is not an
ASP.NET issue, you should get the error from a .NET WinApp as well.
Now here is a funny. I've spent yesterday the whole day attempting to
install SharePoint (after upgrading to Win 2003 Server from 2000 the
previous night), and it kept bombing out with a SQL Server connect. It
turned out that MDAC 2.8 was broken.
In order to see if your MDAC 2.8 is broken, have a look at this article
http://myitforum.techtarget.com/articles/18/view.asp?id=7298
Re-installing MDAC 2.8 did not fix the problem, I had to manually copy a DLL
as per the article, though I've seen somewhere someone claimed re-install
worked on XP.

"Brian Johnston via .NET 247" <anonymous@dotnet247.com> wrote in message
news:OQkAXSzSEHA.3660@tk2msftngp13.phx.gbl...
All projects I have done up until now have been SQL Server based so I've
never seen this issue, nor has anyone I work with. The current project I'm
working on requires an Access backend db. When attempting to connect to the
database I get "Class not registered. Please install MDAC 2.6 or later."
This is a bogus error because I have MDAC 2.8 installed with Jet SP8. I
have no problems connecting to the same database using traditional
application forms; this is strictly and ASPNET issue.

Obviously I thought it was a permissions issue, but I gave ASPNET and IUSR
and IWAM full control permission on the project folder and subfolder but
still got the same error. I even tried giving Everyone full control to see
and nothing changed (as expected).

I also tried changing the machine config file to have ASPNET run as system
rather than machine but this didn't do anything either. I have re-installed
MDAC for the heck of it to no avail - again, everything is fine with
traditional apps connecting to the same database, only an ASPNET error so I
didn't expect anything to change.

I'm really at a loss here, any help would be <i>greatly</i> appreciated.

Thanks
--------------------------------
From: Brian Johnston

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>wFCirEKdlky9bYWju3A/Hg==</Id>



Relevant Pages

  • Re: DAO360.DLL - can I redistribute it?
    ... Your point about the only real advantage of ADO being its ability to ... My big worry about telling them to install MDAC is that when it installs the ... If the database is Jet/DAO, you'll still need Jet on the target ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Cant install SP1 database. error display and rollback.
    ... install the Xp Embedded Database Components. ... Apparently MantisSQLDB is what it is trying to install, ... Do you have the latest MDAC installed on your computer? ... Verify that you have the latest WSH installed there. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Requirements to Run ADO.NET Application
    ... No database engine is part of .net. ... It happens that jet is a part of MDAC and MDAC is installed with .net. ... It is a subset of real SQL Server, it is free and it is deployed by simpy including an assembly or two with your app - no deployment hassles at all! ... "The bottom line for me is that I want my application to install painlessly ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: does mdac conflict with .net framework?
    ... i had a problem updateing or inserting data into an access 97 database from ... due to the fact i was using a newer mdac version. ... updating into my old access 97 database. ... > If so then you may not have to install the 'older' MDAC at all. ...
    (microsoft.public.vb.database)
  • Re: Help! Cant connect via ODBC DSN file to SQL server 2005 if not considered a default database
    ... ODBC, just the original database. ... you connect to a SQL Server ... connecting to SQL Server. ... connecting to allows you to install a training or release version of the ...
    (microsoft.public.sqlserver.odbc)