enterprise manager "return all rows" error

in enterprise manager, when i select a table and "return all rows" or "query" , SQL returns an error "provider cannot be found". I can successfully run a query in query analyzer. I've reinstalled SQL and it's still not working. It seemed to be working fine a couple weeks ago when i was working on crystal reports.Hi,
It could be an MDAC problem. Try loading the MDAC for the version of SQL
you are using.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx . Free icon extraction
program
http://www.ag-software.com. Free programming tools
"az" <anonymous@.discussions.microsoft.com> wrote in message
news:8E3D5D69-C0E8-43D6-BE2C-8D24DE519A6D@.microsoft.com...
> in enterprise manager, when i select a table and "return all rows" or
"query" , SQL returns an error "provider cannot be found". I can
successfully run a query in query analyzer. I've reinstalled SQL and it's
still not working. It seemed to be working fine a couple weeks ago when i
was working on crystal reports.
>