I'm not sure where else to go on this. We've got ~50 locations that have a working synch application that brings in data from SqlExpress2005 db's to our production Sql Server 2005. It has and does work fine in most locations that are on 56k leased lines.
One location, however; is dialup through Earthlink. The synch runs fine until it synchs data with one table..Sale_item. It synchs some records but not all. On the one record, I see (through debug msg's boxes I coded) that it's trying to insert into the prod
db here. I watch in activity monitor and there's nothing that is blocking. I have the db timeout set to zero (which I thought meant no timeout) so I'm not sure what else to try.
It synchs by finding which keys are on prod and which are on the plant and issuing I,U,D's as needed.
View Complete Post