SQL 2000 cannot execute the query because some files are missing or are not registered & quot;

A demo machine is installed for a friend. The system is Windows Server 2003 and the database is SQL Server2000. After the installation is complete, the system is okay and the SQL Enterprise Manager can be opened normally, the database and table can also be loaded normally, but the row cannot be returned when the table is opened to view the table data. The following error is prompted:

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

However, reinstalling SQL 2000 does not actually help. You can simply follow the steps below.

1. register the following four dll files and restart the machine.

Copy codeThe Code is 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"

Copy and save the above Code as "any file name. bat", double-click it, and restart.

When you use SQL2000 to query data again, the following error occurs: "No provider is found. This program may not be correctly installed.

2. register the following dll

Copy codeThe Code is as follows: regsvr32 "C: \ Program Files \ Common Files \ System \ Ole DB \ msdasql. dll"

After the registration, the Enterprise Manager's query again encountered the "no registered category" error. It seems that the system's database access component encountered a problem. Okay, go to step 3.

3. The root cause is that when the system is installed, MDAC may lose related files. Reload the file:

Go to C: \ WINDOWS \ inf, find mdac. inf, right-click to install, and follow the prompts to complete the installation. [System disk is required in this process]


Solution 3:

Uninstall SQL Server, delete the "Microsoft SQL Server" folder generated during installation, and run the Registry to delete HKEY_CURRENT_USER \ Software \ Microsoft SQL Server, and HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server are all deleted (note that the entire Microsoft SQL Server folder should be deleted), and then restarted.
Try it
In addition, select hybrid mode when logging on.

Conclusion: when the first error prompt appears, you can directly install it in step 3. This should also solve the problem. If you have this problem, try it.