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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 error MSDTC

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2011-12-09 : 10:46:19

hello

I & 2 databases on 2 different servers
i call a procedure from my application
which can read data from first database and insert them into the second database

I have this message:
[Microsoft] ODBC SQL Server Driver [SQL Server]
Failed to import the MSDTC transaction
ResultCode = 0x8004d01f

If I run this procedure directly in SQL, it works













visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-09 : 10:57:10
are you doing it under transaction? is it a distributed transaction? Is MSDTC running on machine where code is executed?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -