Error Trying to VIew data in table

When I try to view the data in a table on my SQL SErver 2000 Enterprise
manager, I get the following message
"Provider cannot be found. It may not be properly installed. I have SQL
2000 installed on my PC for the last 8 months and I have had no problems.
All of a sudden I get this
Any help
IMHO, you should view/manipulate your data in SQL Server's Query Analyzer.
At the very least, this will tell you whether the problem is with Enterprise
Manager, or more deeply rooted.
http://www.aspfaq.com/
(Reverse address to reply.)
"dfoote" <dfoote@.napcosecurity.com> wrote in message
news:#bRWbQJrEHA.2788@.tk2msftngp13.phx.gbl...
> When I try to view the data in a table on my SQL SErver 2000 Enterprise
> manager, I get the following message
> "Provider cannot be found. It may not be properly installed. I have SQL
> 2000 installed on my PC for the last 8 months and I have had no problems.
> All of a sudden I get this
> Any help
>
|||Thanks Aaron
I tried this and I am able to retrieve data via the Query Analyzer. So I
know it is Enterprise manager? Any more suggestion?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOTc6BLrEHA.2764@.TK2MSFTNGP11.phx.gbl...
> IMHO, you should view/manipulate your data in SQL Server's Query Analyzer.
> At the very least, this will tell you whether the problem is with
> Enterprise
> Manager, or more deeply rooted.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "dfoote" <dfoote@.napcosecurity.com> wrote in message
> news:#bRWbQJrEHA.2788@.tk2msftngp13.phx.gbl...
>
|||Have you installed SP3a? Have you updated MDAC recently? If not, have you
considered doing these things?
And have you considered just using Query Analyzer?
http://www.aspfaq.com/
(Reverse address to reply.)
"dfoote" <dfoote@.napcosecurity.com> wrote in message
news:uz$P$RLrEHA.3080@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> I tried this and I am able to retrieve data via the Query Analyzer. So I
> know it is Enterprise manager? Any more suggestion?
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:eOTc6BLrEHA.2764@.TK2MSFTNGP11.phx.gbl...
Analyzer.[vbcol=seagreen]
SQL
>