I desperately need to run distributed transaction from SQL Server to
Oracle.
I use OLE DB Provider for Oracle from Microsoft.
OLE DB Provider for Oracle supports ITransactionJoin interface. That
means it supports distributed transactions over MS DTC. But every time
I try to run distributed transactions(like transactions from a
trigger) it gives me a following error:
" 'MSDAORA' unable to begin distributed transactions"
I run SELECT, UPDATE, DELETE statements without any problem as long as
it is not running within Distributed transactions. Also my Microsfot
Distributed Transaction Coordinator Service is in running mode.
Any ideas any thoughts would be greatly appreciated.
Munkhnar Nyamjav MCSD, MCDBA