Mssql2000 Enterprise Manager cannot query data

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.