S
smat-consulting
Guest
Data server adds a lot of complexity, as you're now dealing with two different systems and their interaction. Even though it is made so easy with OpenEdge, it still is a hassle! Hm. I'd probably put some logic into the trigger that outputs the data I'm attempting to send to SQL Server into some sort of log-file just before it is written to that DB. That way I see that the record is actually there. and try to see if there is any returned message after that assign. Not sure if error-status is raised or maybe a catch block or so - just in case the foreign DB rejects the record for some reason... Not sure what else I could suggest... Good luck! PS: if you like, find me on Skype and screenshare what you're observing. Maybe that might trigger some more ideas...
Continue reading...
Continue reading...