“因为OLE DB提供程序"SQLNCLI10"已被执行，所以无法执行该操作.对于链接服务器"XXXXXX"无法开始分布式交易 [英] "The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "XXXXXX" was unable to begin a distributed transaction

问题描述

Salve

非rysco效率操作(更新，截断表等)，用于在非语言环境中创建非sql数据库和作业. Ricevo l'errors无法执行该操作，因为OLE DB提供程序"SQLNCLI10"已被删除.用于链接 服务器"WKBMH08VNF"；无法开始分布式事务.

non riesco ad effettuare operazioni ( update, truncate table, etc ) su un azure sql database da procedure o jobs create in un database locale. Ricevo l'errore "The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "WKBMH08VNF" was unable to begin a distributed transaction."

用于存储SSMS的作业程序和非存储过程.

Le stesse operazioni funzionano se chiamate da SSMS e non da stored proedure o job.

推荐答案

Hello,

请参阅以下论坛主题提供的解决方案:

Please refer to the solutions provided on the following forum thread:

https://stackoverflow.com/questions/7473508/无法开始分布式交易

https://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于“因为OLE DB提供程序"SQLNCLI10"已被执行，所以无法执行该操作.对于链接服务器"XXXXXX"无法开始分布式交易的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！