Comments
4 comments
-
Hello,
I believe the answer is elsewhere in the forum. It could either be that the SQL Client-side tools aren't installed, or one of the other COM libraries have come undone. If the error message contains the CLSID of this library, that would be helpful in tracking down which library is causing the problem. -
Brian Donahue wrote:Hello,
I believe the answer is elsewhere in the forum. It could either be that the SQL Client-side tools aren't installed, or one of the other COM libraries have come undone. If the error message contains the CLSID of this library, that would be helpful in tracking down which library is causing the problem.
Unfortunately, error message doesn't contain CLSID. I am not exactly sure what COM libraries are problematic and which ones SQLCOmpare is relying on. I though you might have experienced similar problems. I will try to search though forums.
Igor -
Off the top of my head, here are some libraries you can try registering with regsvr32:
- sqldmo.dll (part of client-side tools)
- c:\program files\red gate sql bundle\sqlcompare.dll
- c:\windows\system32\dwstg.dll
- c:\program files\red gate sql bundle\vsflex7l.ocx
- c:\program files\red gate sql bundle\sqlcompareclib.dll
Hopefully one of those gets it. You may also try simply reinstalling SQL Bundle. That should re-register all of the COM dlls. -
Thanks Brian! Everything is working after I registered DLLs you mentioned.
Add comment
Please sign in to leave a comment.
I have b een happily using SQL Compare v 1.60 until I installed SQL Server 2005 client tools. I am currently getting 'Automation error. Libraryis not registered ' when trying to compare two SQL Server 2000. Any advice on how to fix this problem is greately appreciated.
Igor
Reply:
Daniel:'Version 1.0 doesn't work with SQL Server 2005'.
Daniel,
Previous topic has been locked and I had to start new one.
I am not going to work with SQL Server 2005. I would like to continue working with SQL Server 2000 instances as I did before installing SQL Server 2005 client tools. Please advice. I tried reinstalling SQLCompare but it didn't help.
Thanks,
Igor