SQL 2000 cannot execute query because some files are missing or unregistered "workaround _mssql

To a friend installed a demo machine, the system is Windows Server 2003, the database is SQL Server2000, after the installation is complete, the system is not a problem, SQL Enterprise Manager can also open the normal, database and table can load normally, but open the table to view table data, but can not return rows, Prompt for the following error:

The query cannot be executed because some files are missing or not registered. Run Setup again to ensure that the required files are registered.

But actually reloading SQL 2000 doesn't help, actually, by following these steps.

1. Register the following four DLL files, restart the machine can be.

Copy Code code as follows:

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"

Save the above code copy as "arbitrary filename. bat", double-click Execute, reboot.

Using SQL2000 to query the data again, there was "no provider found." The program may not be properly installed "prompt, do not panic, enter the second step.

2. Register the following DLL

Copy Code code as follows:

regsvr32 "C:\Program Files\Common Files\System\Ole Db\msdasql.dll"

After registering, Enterprise Manager's query again appeared "No registration category" error, it seems that the system's database access component has a problem. All right, let's go to step three.

3. The root of the problem is when the system is installed, MDAC may lose the relevant files, then reload it:

Enter the C:\WINDOWS\inf, find the Mdac.inf, click the right button to install, follow the prompts to install the finished, you can. "Require system disk in this process"


Solution Three:

Uninstall SQL Server First, then delete the "Microsoft SQL Server" folder that was generated by the installation, and in the registry, run the HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL server, and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server all deleted, (note that you want to delete the entire Microsoft SQL Server folder), and then restart.
Give it a try.
Also choose the blending mode when you choose to log in

Summary: In the first error prompted, directly to the third operation installation, should also be able to solve the problem, if you have this problem, you can try.