"Provider cannot be found" appears in SQL Server 2000"

Today, when SQL Server 2000 is used to open all tables in the Enterprise Manager and select to return all rows, "Provider cannot be found" appears.

. It may not be properly installed .". In the same case, each table cannot view the data, but the data can be viewed in the query analyzer. I have never encountered such a problem before, and it is very strange. So I checked it online and said that it was necessary to install the SQL Server 2000 sp3 patch to solve the problem. In this case, download the patch and install it on the Microsoft homepage. However, after the installation, the problem still cannot be solved. After searching for half a day, I finally found a solution, I .e. re-register

Oledb32.dll file, the method is as follows:

Cancel registration in the command line:

Regsvr32.exe/u "% ProgramFiles % \ Common
Files \ System \ Ole DB \ oledb32.dll"

Re-register:

Regsvr32.exe
"% ProgramFiles % \ Common Files \ System \ Ole DB \ oledb32.dll"

Everything is OK! I don't know why. That's all. (My system is Windows XP sp3)