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

No comments:

Post a Comment