Error using EM to view data

Hi,
I have a rather annoying problem with enterprise manager. When I select
Open Table, then Select All Rows . or Select Top . I get the following error
from EM:
Provider cannot be found. It may not be properly installed.
This started a few days ago for no apparent reason. The problem seems to be
limited to my machine, and happens if I access the local data store (MSDE)
or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
(SP4) and the client tools I'm running are from SQL Server 2000 enterprise
edition (SP3).
All other functions seem to work in EM (such as creating / modifying tables,
etc), and I can access data through other applications on this machine (such
as Query Analyzer, VS.Net, etc).
Things I have tried include reinstalling the latest MDAC (2.8), uninstalling
and reinstalling SQL Server client tools + sp3, and using regsvr32 to
reregister some DLLs suggested in other postings.
One last thing - using Profiler and a different workstation, I noticed that
the Open Table, Select all rows. function starts a new application with a
separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
anyone know anything about this?
TIA for any help anyone can provide.
-DHI found the solution for this and I am posting it for the common good...
Using filemon and regmon (from sysinternals, nice products), I saw that MMC
was trying to use an old version
of the file msdasql.dll in winnt\system32 rather than the version MDAC
installed in
Program Files\Common Files\System\Ole DB
Using regsvr32 to unregister then re-register the newer file fixed the
problem. Since this file is part of MDAC, I would
have thought that reinsalling MDAC should have fixed the problem, but it
didn't. Ditto for SP4 for Win2k.
I hope this helps someone somewhere someday. -DH
"David Howard" <reply@.to.group> wrote in message
news:UvC8c.290$yN6.61@.newsread2.news.atl.earthlink.net...
> Hi,
> I have a rather annoying problem with enterprise manager. When I select
> Open Table, then Select All Rows . or Select Top . I get the following
error
> from EM:
> Provider cannot be found. It may not be properly installed.
>
> This started a few days ago for no apparent reason. The problem seems to
be
> limited to my machine, and happens if I access the local data store (MSDE)
> or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
> (SP4) and the client tools I'm running are from SQL Server 2000 enterprise
> edition (SP3).
>
> All other functions seem to work in EM (such as creating / modifying
tables,
> etc), and I can access data through other applications on this machine
(such
> as Query Analyzer, VS.Net, etc).
>
> Things I have tried include reinstalling the latest MDAC (2.8),
uninstalling
> and reinstalling SQL Server client tools + sp3, and using regsvr32 to
> reregister some DLLs suggested in other postings.
>
> One last thing - using Profiler and a different workstation, I noticed
that
> the Open Table, Select all rows. function starts a new application with a
> separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
> anyone know anything about this?
>
> TIA for any help anyone can provide.
> -DH
>|||It helped me, today.
Thanks a lot for your effort to solve this.
Andrew Arace