February 20, 2011 at 4:56 pm
Just to rule out most likely suspects please check...
1- Query is written using four-parts-names.
2- There is an unique index on target table.
3- DTC is setup and running.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 7, 2011 at 5:24 pm
Looks like a connection problem. Check provider and connection string parameters. Try changing provider version or try Microsoft OLEDB provider for Oracle. Try with another link-test expression instead of delete: "SELECT * FROM DUAL". You also could have an Oracle procedure on the other side you call over a link.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply