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
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
