SQLDMO registration, sqldmo not registered

SQLDMO registration, sqldmo not registered

When maintaining the personnel system, Shi Jie asked us a functional problem. Yellow Pages are reported during database backup. Then we need to find the cause and make a solution.

At first, I started from the system that was originally released on the local machine and found that there was no problem. However, an error occurs when debugging the program. The error is as follows:

The error message returned when the unprocessed system.runtime.interopservices.comexceptionexceptionexception occurs in comlayout.exe. Other information: Search for the COM-type factory with the CLSID {0EC8CCC8-EBED-495E-9A9F-313

At that time, I didn't understand what was going on. When I searched for information online, I mentioned reference problems. Then I thought of a reference problem when I checked out the program from SVN at the beginning. However, after the re-reference, the error was resolved, and the problem suddenly failed.

Later, I tested the previous system and the latest system, and found the same problem. In this way, we can eliminate the problems that occur during the system update process, and locate the problem incorrectly in the system itself. But later I found that my partner was okay, and then I raised the issue of SQLDMO registration.

The full name of the SQL-DMO is SQL Distributed ManagementObjects. It is a set that contains a group of COM with dual interfaces. With SQL-DMO we can control the database engine and replication management that operates SQL Server.

That is to say, SQLDMO is mainly used for SQL Server operations. This function is used to back up the database, which requires SQLDMO. This also illustrates the reference problem. The reference sqldmo. dll file is used to operate the database. However, SQLDMO is not registered.

Registration process:

1. Download The sqldmo file and place it in the specified location of SQL Server according to its instructions, namely, C: \ ProgramFiles \ Microsoft SQL Server \ 80 \ Tools \ Binn.

2. Click Start> Run (Window + R) and enter the command regsvr32 "C: \ ProgramFiles \ Microsoft SQL Server \ 80 \ Tools \ Binn \ sqldmo. dll" to run.

 

After successful registration, you can run properly.

The success of the backup is as follows:

From this issue, we can see that our hands-on capabilities still need to be improved. At the beginning, sqldmo. dll was referenced, but it does not check what the file is and what effect it has. Therefore, we should cultivate our initiative in the future learning process. When you encounter many problems, you can query more information to fully understand the problem. The other is to avoid the words "should be okay" and "no problem at all" and gradually abandon the ideas of small farmers.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.