Showing posts with label distributed. Show all posts
Showing posts with label distributed. Show all posts

Monday, February 20, 2012

Oracle and DTC

Does anyone have any experience of using DTC with Oracle. I'm trying to enlist an Oracle connection in a distributed transaction and am getting the following error:

An OLE DB error has occurred. Error code: 0x8000D048. COM error object information is available. Source: "ProductionHierarchy" error code: 0x8000D048 Description: "The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8000D048 "(null)". ".
Any advice/help much appreciated.

-Jamie
Try installing and using Oracle OLEDB Provider from oracle website|||Thanks Suresh, I'll give that a go.

The strange thing is that I'm using the same provider for other Oracle systems and they enlist in transactions OK - so I figure its a config issue.

-Jamie