MSDTC issue thru linked server (Oracle provider)

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32571 More actions · Answer 1

SSC-Dedicated

Points: 32571

September 21, 2007 at 12:36 pm

there is a primary key on both sides?

71 camaro SSC Eights! Points: 911 More actions · Answer 2

YES the one oracle table has 2 PK keys.

SQL server side where it deletes from 18 tables does has a primary key on every table but maybe half on the same column/columns as oracles keys.

UPDATE: We actually kept rerunning it and it finally completed successfully. Yet when I issue begin distributed tran it still fails.

Go figure ?

Jo Pattyn SSC-Dedicated Points: 32571 More actions · Answer 3

Could it be the new security settings for MSDTC in Windows 2003?