带有Insert存储过程错误的SQL数据适配器 [英] SQL Data Adapter with Insert stored proc errors

问题描述

我的组织只是在Windows Server 2003上实施Biztalk Server R2 Enterprise，我们遇到了一些问题。我们正在尝试使用SQL传输模式生成向导，并指定我们使用存储过程。生成脚本按钮生成以下
exec [CreateCriticalChange] @ BranchId =" "，@ CreatedBy =" "，@ CriticalChangeCategory =" "，@ CriticalChangeType =" "，@ ExpirationDate =" "，@ ExternalId =" "，@ Notes =" "，@ SourceSystem =" "

但是当选择下一个时我收到以下消息""无法执行sql语句，请确保提供的语法正确。新事务管理器在指定的事务协调器中登记"。我尝试过 http://support.microsoft.com/default.aspx/kb/917847没有运气。非常感谢任何帮助！

---

Adam

My organization is just implementing Biztalk Server R2 Enterprise on Windows Server 2003 and we are having some issues.  We are trying to use the SQL Transport Schema Generation Wizard and am specifying that we use a stored proc.  The generate script button  generates the following 
exec [CreateCriticalChange] @BranchId=" ", @CreatedBy=" ", @CriticalChangeCategory=" ", @CriticalChangeType=" ", @ExpirationDate=" ", @ExternalId=" ", @Notes=" ", @SourceSystem=" "

however when selecting next I receive the following message "failed to execute sql statement, please ensure that the supplied syntax is correct. New transaction cannont enlist in the specified transaction coordinator".  I have tried the solution listed at http://support.microsoft.com/default.aspx/kb/917847 with no luck.  Any help is greatly appreciated!

---

Adam

推荐答案

您可以尝试使用DTCPing（ http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658- a549-1d549ac17644& DisplayLang = en ）测试与DTC协调员的连接。
DTC的安全设置是什么？如果您将其设置为"无身份验证"，并且"允许入站"，则+"允许出站"，这有帮助吗？

You can try using DTCPing (http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&DisplayLang=en) to test connectivity to the DTC coordinator.
What are the security settings for DTC? If you set it to "No Authentication", and "Allow Inbound" + "Allow Outbound", does that help?

这篇关于带有Insert存储过程错误的SQL数据适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！