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] "rajpatel50@hotmail.com" wrote:
> On 13 Jul, 16:22, rajpate...@hotmail.com wrote:
> > On 13 Jul, 13:16, rajpate...@hotmail.com wrote:
> >
> >
> >
> >
> >
> > > 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
> >
> > Also got a newer version of the file version 9.0.242.0, created 10th
> > Feb 2007 but that has the same problem- Hide quoted text -
> >
> > - Show quoted text -
>
> 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?
>