MS SQL Server - Trouble with linked server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Trouble with linked server

dima.kroshkin@gmail.com

2005-11-11, 7:23 am

Hi, all.
I have problem with linked server.
The linked server is Oracle.
If I execute simple query in Query Analizer it is successfull.
If I try to execture this query in transaction i catch exception
OLE DB Provider 'MSDAORA' was unable begin distributed transaction.
(error 7391 or 7399)

The operation could not be performed because the OLE DB provider
'MSDAORA' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::Jo
inTransaction returned 0x8000d048].

i read microsoft kb 280106, but this don't help me.

What is the problem? How can i correct them?
What do i do?

Great thanks.

Sponsored Links