SQL Server cannot perform the query because some files are lost or not registered.
Data cannot be queried directly in the Enterprise Manager, but the data can be viewed using the query analyzer. It is useless to reinstall sqlserver2000.
Solution: register the following four DLL files
Regsvr32 "C: \ Program Files \ common files \ System \ ole db \ oledb32.dll"
Regsvr32 "C: \ Program Files \ common files \ System \ ADO \ msado15.dll"
Regsvr32 "C: \ Program Files \ common files \ System \ ole db \ sqloledb. dll"
Regsvr32 "C: \ windows \ system32 \ ATL. dll"
Or
Regsvr32 c: \ progra ~ 1 \ common ~ 1 \ System \ oledb ~ 1 \ oledb32.dll
Regsvr32 c: \ progra ~ 1 \ common ~ 1 \ System \ ADO \ msado15.dll
Regsvr32 c: \ progra ~ 1 \ common ~ 1 \ System \ oledb ~ 1 \ sqloledb. dll
Regsvr32 c: \ windows \ system32 \ ATL. dll
Solve this problem. However, I found the following possibilities on the Internet, but I did not
After the registration is completed, the following error occurs:Program. This program may not be correctly installed. Check the component everywhere and register the component again:
Regsvr32 "C: \ Program Files \ common files \ System \ ole db \ msdasql. dll"
After the registration is completed, the Enterprise Manager query again encountered the "no registered category" error. It seems that the system's database access component encountered a problem. The root cause is that when the system is installed, MDAC may have lost related files. Reload the file:
Go to c: \ windows \ INF, find MDAC. inf, right-click to install, and follow the prompts to finish the installation.