Error using EM to view data
From: David Howard (reply_at_to.group)
Date: 03/25/04
- Next message: HarryArchibald: "Cascade Delete Not Working Correctly?"
- Previous message: Dan Guzman: "Re: msdb renamed to msbd"
- Next in thread: DH: "Re: Error using EM to view data"
- Reply: DH: "Re: Error using EM to view data"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Mar 2004 15:02:12 GMT
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
- Next message: HarryArchibald: "Cascade Delete Not Working Correctly?"
- Previous message: Dan Guzman: "Re: msdb renamed to msbd"
- Next in thread: DH: "Re: Error using EM to view data"
- Reply: DH: "Re: Error using EM to view data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
