failed to open rowset - 0x80004002

[gcole]

I get the following errors when I try to run a report connected to SQL Server:
1. Failed to open a rowset
2. Not Implemented.
Details:Error Code: 0x80004002

I know this doesn't have anything to do with the DB as I created the reports on another PC. However, I initially had 8.5 installed. I uninstalled it and put 9.0 in. I have run the ServicePack 2. I am at a complete loss for ideas.
Thanks in advance,
Gail

 

[gcole]

I figured it out. I installed some vendor software for testing a few months ago. Uninstalled and worked from a different location. When I returned, Crystal didn't work. It turns out, the vendor software installed an old version of MDAC on my PC. I downloand and installed the latest version and it works great.