Re: Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)

Tech-Archive recommends: Speed Up your PC by fixing your registry



No, the publisher must also be SQL 2005 Workgroup edition or above.
On Feb 7, 6:55 am, "Tim Ford" <Tim.F...@xxxxxxxxxxxxxxxxx> wrote:
Hi All,

I need a little clarification and was wondering if anyone can point me in
the direction of this.

Previously we were running MSDE on a client machine and SQL Server 2000 at
Head Office running Merge Replication. In our application (VB6) we were
running the Merge ActiveX Control to manage the replication process, however
some of our clients are moving to Vista and I understand that MSDE is no
longer supported on Vista.

So what we would like to do is install Sql Express on the client machine
running Vista. Can anyone confirm if Sql Express can connect to a Sql Server
2000 publisher and process merge replication. I understand that Enterprise
Manager can't connect to Sql Express which is fine, We don't require any
agents to be run as this can be controlled via the VB6 application either
running the Merge ActiveX Control or running a COM enabled control with RMO.

If anyone can point me in the right direction that would be great.

Thanks, Tim.

.



Relevant Pages

  • Re: convert rtf to plain text
    ... The 'RICHTEXT.RichtextCtrl' ActiveX control might be the Microsoft Rich ... Sylvain Lafontaine, ing. ... table.I found below sql function in google search. ... DECLARE @object int ...
    (microsoft.public.access.adp.sqlserver)
  • Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)
    ... Previously we were running MSDE on a client machine and SQL Server 2000 at ... running the Merge ActiveX Control or running a COM enabled control with RMO. ...
    (microsoft.public.sqlserver.replication)
  • Re: Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)
    ... pull subscription from sql server 2000? ... Head Office running Merge Replication. ... running the Merge ActiveX Control to manage the replication process, ... longer supported on Vista. ...
    (microsoft.public.sqlserver.replication)
  • Re: Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)
    ... pull subscription from sql server 2000? ... Head Office running Merge Replication. ... running the Merge ActiveX Control to manage the replication process, ... longer supported on Vista. ...
    (microsoft.public.sqlserver.replication)
  • Re: hey children - lets all re-learn every 2 years
    ... SQL 2005 doesn't support SQL Agent and it doesn't support Replication. ... Vista doesn't support SQL Agent and it doesn't support Replication. ... It is also possible to develop COM+ libraries in Dot Net ...
    (microsoft.public.dotnet.languages.vb)