Connecting to subscriber instance via business logic handler...

This is a tricky problem and there are several issues with it.

The first is that you have to be able to resolve the subscriber host name
and get through any client side firewalls. Something like OpenVPN is a good
fit here.

Then next problem is latency issues. Firing such an inline proc or querying
a remote server over the internet can make syncs take an extremely long
time.


"Greg" wrote in message
news:12b9003a-0ed5-4d83-ba47-7b4ab20916ff@k13g2000hse.googlegroups.com...
> Hello,
>
> I have a customer resolver for replication where I am trying to open
> up a connection to the subscriber to execute stored procedures when
> synchronizing the data.
>
> This seems to work well with a LAN configuration, but when it is
> configured for a web synchronization, the Open fails for the database
> connection. The connection string is valid - but it appears on a web
> synch the custom resolver is executed on the web server, and it is
> unable to open the SQL instance over the web. On the LAN the custom
> resolver is executed on the subscriber machine.
>
> It is able to open the publisher connection on the web synch.
>
> How can I open up a connection to the subscriber database in my custom
> resolver over the when it is used for web synchronization? Is their a
> replication configuration setting that I can make this work?
>
> Thanks for any help,
> Greg