all groups > sql server replication > july 2007 >
You're in the

sql server replication

group:

Can't Add Reference to Microsoft.SQLServer.RMO.dll


Can't Add Reference to Microsoft.SQLServer.RMO.dll rajpatel50 NO[at]SPAM hotmail.com
7/13/2007 5:16:19 AM
sql server replication: Hi All,

I'm trying to add a reference to this DLL in Visual Studio 2003 so I
can programmatically trigger replication. When I try and add the
reference I get the following exception:

"A reference to 'C:\Program Files\Microsoft SQL Server\90\SDK
\Assemblies\Microsoft.SqlServer.Rmo.dll' could not be added. This is
not a valid assembly or COM component. Only assemblies with extension
'dll' and COM components can be referenced. Please make sure that the
file is accessible, and that it is a valid assembly or COM component."

As you can see it does have a .dll extension.

The file I try to reference indicates it was created on 14 October
2005, 03:43:34 and is version 9.0.1399.0

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
\Microsoft.SqlServer.Rmo.dll

Can I doenload another version of the DLL from somewhere?

Any help appreciated!

Thanks

Rajl
Re: Can't Add Reference to Microsoft.SQLServer.RMO.dll rajpatel50 NO[at]SPAM hotmail.com
7/13/2007 8:22:46 AM
[quoted text, click to view]

Also got a newer version of the file version 9.0.242.0, created 10th
Feb 2007 but that has the same problem
Re: Can't Add Reference to Microsoft.SQLServer.RMO.dll rajpatel50 NO[at]SPAM hotmail.com
7/16/2007 2:47:52 AM
[quoted text, click to view]

OK, this is resolved now. I think the issue is to do with the fact I'm
using VS2003. I tried adding the reference to a VS2005 project and
that works fine. I'm guessing that the dll is a .NET 2.0 dll and so
not compatible against VS2003?
Re: Can't Add Reference to Microsoft.SQLServer.RMO.dll Glenn Gailey [MS]
7/19/2007 8:26:04 AM
If you want to programmatically start replication, you probably will also
need to add a reference to the "Replication Agent Library" assembly.

For more information, see
http://msdn2.microsoft.com/de-de/library/ms146869.aspx.

Cheers!

--
Glenn Gailey
SQL Server User Education

This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]
AddThis Social Bookmark Button