Shulou(Shulou.com)05/31 Report--

This article mainly introduces that the "sql 2000 hint" cannot execute the query because some files are missing or unregistered. In the daily operation, I believe many people have doubts on the solution of "unable to execute the query because some files are missing or unregistered" in the daily operation. The editor consulted all kinds of materials and sorted out simple and useful operation methods. Hope to answer the "sql 2000 hint" can not execute the query, because some files are missing or unregistered "solution" is helpful! Next, please follow the editor to study!

A demo machine is installed for a friend. The system is Windows Server 2003 and the database is SQL Server2000. After the installation is completed, the system is fine, the SQL enterprise manager can open it normally, and the database and tables can be loaded normally, but the rows cannot be returned when opening the table to view the table data. The following error is prompted:

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

But in fact, it is useless to reinstall SQL 2000. In fact, you can solve it by following the following steps.

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

The copy 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 the above code and save it as "any file name .bat", double-click to execute, and restart.

Use SQL2000 to query the data again, but the "provider not found. The program may not be installed correctly" prompt, do not panic, proceed to the second step.

two。 Register the following dll

The copy code is as follows: regsvr32 "C:\ Program Files\ Common Files\ System\ Ole DB\ msdasql.dll"

After the registration, the query of the enterprise manager once again appeared the error of "no registered category". It seems that there should be a problem with the database access component of the system. All right, move on to step three.

3. The root of the problem is that MDAC may have lost the relevant files during the system installation, so reinstall it:

Go to C:\ WINDOWS\ inf, find mdac.inf, click the right button to install, and then follow the prompts to install it. [system disk needed in this process] solution 3: uninstall SQL Server, then delete the "Microsoft SQL Server" folder generated during installation, run the registry, delete HKEY_CURRENT_USER\ Software\ Microsoft\ Microsoft SQL Server, and HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Microsoft SQL Server, (be sure to delete the whole Microsoft SQL Server folder), and then start again. Give it a try, and choose mixed mode when choosing to log in.

Summary: in the first error prompt, directly carry out the third step of the operation and installation, should also be able to solve the problem, if you have this problem, you can try.

At this point, the "sql 2000 prompt" can not execute the query, because some files are missing or unregistered "solution" study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.