Yes, just add new steps to the Merge Agent job. First step would be of Type
"Operating System Command (CmdExec)" and would read something like
rasdial vpn_connection_name user password domain:/your_domain_name
Then add another step after the Replication agent to disconnect. Same as
above but the command text would be:
rasdial vpn_connection_name /disconnect
Important Note: It appears that the Merge Agent job step attempts to run
immediately after the first Connect VPN step is run. If you're relying on
NETBIOS name resolution, you WILL need to add a retry on the replication
step. This is simply because it takes a little bit of time for your VPN IP
settings to be configured upon first connection. The first merge attempt
almost always fails for me because it can't locate the Publisher name yet. If
you're connecting via straight IP addresses, then this will not be a problem.
Besides that, this works like a charm for our multi-city office replication
on an hourly basis.
[quoted text, click to view] "Carlos Gutierrez" wrote:
> Hi
>
> > Each subscriber dials VPN,
> > performs replication, and then disconnects the VPN.
>
> Where do you handle the VPN dial/disconnect? Do you add a step to the Agent
> job or something else?
>
> I'll appreciate any details.
>
> Regards,
>
>
>
thanks... is there any sample source code on that ? besides using ActiveX
merge control, is there any way not using control ?
also does the ActiveX merge control support VB6, thanks.
"Hilary Cotter" <hilary.cotter@gmail.com> ¦b¶l¥ó
news:%23f8Kxk1yEHA.2540@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...
[quoted text, click to view] > you must use the replication ActiveX merge control. Set the
> DistributorAddress and the PublisherAddress to be the IP address of your
> publisher and the DIstributorNetwork and PublisherNetwork to be TCPIP
>
>
> "Wing Chan" <wing_650473hk@yahoo.com.hk> wrote in message
> news:uGjl5RxyEHA.824@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > We are having a dedicated machine (with a fix IP) running SQl2000 and it
> > is
> > supposed to be the master database. And we are having 4 clients XP
> > machine
> > running MSDE (without fix IP), and we would like to have a merge
> > replication
> > to sync. data from / to the client / server. Coz data will be updated
on
> > server or clients side. I have simulated this environment on a LAN
> > environment and it works but I 'm not sure whether if those clients
> > machine
> > are connected to the server through internet via ADSL connection(without
a
> > fix IP).
> >
> > please help ... !!! thanks.
> >
> > -Wing
> >
> >
>
>
