Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 MSDAORA distributed transaction problem

Author  Topic 

LeeButts
Starting Member

11 Posts

Posted - 2006-08-10 : 04:39:18
Hi Guys
I'm trying to insert a row from a sql server database into an oracle database. ive come accross a few problems with four part names etc and resolved these. but now have an issue with an error " the operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction" can anyone help? i know about the XP service pack 2 problem with default security settings and have resolved this. im trying to insert the data from a sql server 2000 application on a windows XP system service pack 2, going to an oracle 10g table running on a windows 2000 service pack 4 machine. would appreciate any help
Thanks

kevindockerty
Starting Member

27 Posts

Posted - 2006-08-10 : 07:56:23
found this - dont know if it will help

http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106

KD
Go to Top of Page
   

- Advertisement -