ADODB.Connection error '800a0e7a'

From: J L (anonymous_at_discussions.microsoft.com)
Date: 03/27/04 

Date: Fri, 26 Mar 2004 17:16:52 -0800

hello,
I have a problem on a Windows 2000 Server sp4 where any asp page that
tries to connect to a database (SQL or Access) get's the following eror:

-----
ADODB.Recordset error '800a0e7a'

Provider cannot be found. It may not be properly installed.

/TEST.asp, line 8
-----

Example lines-
Site 1: Rs.ActiveConnection = MM_dbconnection_STRING

Site 2: set br = server.CreateObject("ADODB.Connection")
        br.open application("BR_DATA_CONNECTION")

Site 3: set rsViews = Server.CreateObject("ADODB.Recordset")
        rsViews.ActiveConnection = shop_conection_STRING

And so on, and so forth. Previously, the server has MDAC v2.7
installed, but after experiencing this today, I've upgraded to MDAC v2.8
and hotfix Q832483, but that hasn't fixed the problem.

Any ideas? All are appreciated.

Relevant Pages

  • Re: ADODB.Connection error 800a0e7a
    ... I have a problem on a Windows 2000 Server sp4 where any asp page that ... the server has MDAC v2.7 ...
    (microsoft.public.inetserver.iis)
  • Re: overcome increase in virtual memory
    ... the latest MDAC which claims to have fixed this issue. ... > COM Exe connects to MS SQL Server 2000 database using dll. ... > The dll does all database operations referred by COM Service. ... > during insertion virtual memory increases continously by 8 kb. ...
    (microsoft.public.data.ado)
  • Re: I need Help On Basic
    ... > MDAC 2.8 ... > .NET Framework 2.0 ... What happens when you try to create a connection to a database in Database ... What do you see when you open SQL Express Manager and connect to your SQL ...
    (microsoft.public.dotnet.academic)
  • Database problems
    ... problems getting data into a Access database. ... Here's my setup: ... W2K Server SP4 ... the form fields match up to the data fields I want to store the data. ...
    (microsoft.public.frontpage.client)
  • Windows management instrumentation
    ... Does anyone know, why Windows management instrumentation ... service is generating twice as much page faults as SQL ... Server 2000 on my Windows 2000 Server SP4? ...
    (microsoft.public.windows.server.general)