Ferry,
please take a look at the ActiveX section of this page:
http://www.replicationanswers.com/Scripts.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi all,


I'm having a subscription on a bunch of laptops. When connected direct,
no problem but when a user is out of the office, the job doesn't seem
to start. It seems that the agent starts when the machine starts so
I've set the merge-schedule to start every minute expecting it to fire
up correctly. Unfortrunately, it doesn't.

When trying to run the job from EM (right-click, start synchronising),
it works like a charm so I'm trying to mimic that right click in Visual
Basic (since the locally installed version is MSDE and has no EM).

So far, I've been able to lookup the job and then use sp_start_job
(after a sp_stop_job) but I was wondering if there is another way
(SQLDMO?) to start the sync, preferably using VB so I can control it
myself (would like to prevent using Windows Sync manager).

Any ideas?

Thx,

Ferry

From Paul Ibison :
[quoted text, click to view]

Thanks Paul,

Been there, done that, but got no T-shirt yet...

It seems that I am able to get this running although I am not sure if I
did it correctly. I omitted the addsubscription line (since the
subscription is already there and I don't want to create a second one)
and then gave it a try. However, since I am not a validated domain
_user_ at this machine, I can't get it to work. I'll try it tomorrow
when I'm in the office on another machine.

Another thing that I've also build was to find the jobID and simply
(doh) use sp_start_job @job_id=xx (but I must stop it first,
obviously). That one did the trick, even when not validated as a domain
user (I am validated using VPN as a user, i just don't have this
computername in the domain).

Thanks again,

Ferry