SQL适配器和Updategram或更好 [英] SQL Adapter and Updategram or better

问题描述

我有一个小问题，所以如果有人可以提供帮助......

我正在与一个不允许在其数据库中存储过程的客户端一起工作。

因此任何访问和从SQL 2005和2008必须通过选择，更新，插入，删除来完成。

说是否安全我最好的选择是使用更新图还是有更好的方法？

我遇到了麻烦更新图，因为他们只是不工作。

适配器无法传输发送端口"TelDigSQLPort"的消息。使用URL"SQL：// dycwdvvm-f8io40 / TelDigData /"。它将在为此发送端口指定的重试间隔后重新传输。详细说明：" HRESULT = QUOT; 0x80004005的" Description ="所有带有兄弟姐妹的updategram / diffgrams节点必须有id，用户指定的或基于映射模式的关键字段id"
< Root xmlns：ns00 =" urn chemas-microsoft-com：xml-updategram"><？MSSQLError HResult =" 0x80004005" ; Source =" Microsoft XML Extensions to SQL Server" Description ="所有带有兄弟姐妹的updategram / diffgrams节点必须具有id，用户指定的或基于映射模式的密钥字段id">< / root>"。

< p align = left>我尝试了几个不同的帖子来解决这个问题，但没有成功。

这里是架构：

<？xml version =" 1.0"编码= QUOT; UTF-16" ？>
- < xs chema xmlns：updg = " urn chemas-microsoft-com：xml-updategram" ; xmlns：b =" ">
< reference targetNamespace =" urn chemas-microsoft-com：xml-updategram" />
< / references>
< / xs：appinfo>
< / xs：annotation>
- < xs：element name =" TicketUpdateIn">
- < ; xs：complexType>
- < xs equence>























gif"width = 19> chemas-microsoft-com：xml-updategram" updategram refix =" updg"的minOccurs = QUOT 1 QUOT; maxOccurs的= QUOT;无界" name =" sync">
- < xs：complexType>
- < xs equence>
- < xs：element updategram refix =" updg"的minOccurs = QUOT; 0" maxOccurs的= QUOT;无界" name =" before">
- < xs：complexType>
- < xs equence>
- < xs：element minOccurs =" 0" maxOccurs的= QUOT;无界" name =" tdgLocateRequests">
- < xs：complexType>
< xs：attribute ref =" updategram：id" />
< xs：attribute name =" tdgLocateRequestID"类型= QUOT; XS：INT" />
< xs：attribute name =" tdgLocateRequestStatusID"类型= QUOT; XS：INT" />
< / xs：complexType>
< / xs：element>
< / xs equence>
< / xs：complexType>
< / xs：element>
- < xs：element updategram refix =" updg"的minOccurs = QUOT; 0" maxOccurs的= QUOT;无界" name =" after">
- < xs：complexType>
- < xs equence>
- < xs：element minOccurs =" 0" maxOccurs的= QUOT;无界" name =" tdgLocateRequests">
- < xs：complexType>
< xs：attribute ref =" updategram：id" />
< xs：attribute name =" tdgLocateRequestID"类型= QUOT; XS：INT" />
< xs：attribute name =" tdgLocateRequestStatusID"类型= QUOT; XS：INT" />
< / xs：complexType>
< / xs：element>
< / xs equence>
< / xs：complexType>
< / xs：element>
< / xs equence>
< / xs：complexType>
< / xs：element>
< / xs equence> ;
< / xs：complexType>
< / xs：element>
- < xs：element name =" TicketUpdateResponse">
- < xs：complexType>
- < xs equence>
< xs：element name ="成功"类型= QUOT; XS：anyType的" />
< / xs equence>
< / xs：complexType>
< / xs：element>
< / xs chema>

这里有什么想法吗？

谢谢

Dan

解决方案

您可以粘贴表的SQL脚本，以及您正在使用的输入XML吗？

I have a small problem, so if someone can help...

 

I am working with a client that will not allow stored procedures in their databases.

 

So any access to and from SQL 2005 and 2008 must be done through select,updates,insert,delete.

 

Is it safe to say that my best bet here is to use the updategrams or is there a better way?

 

I am having trouble with updategrams in that they just dont work.

 

The adapter failed to transmit message going to send port "TelDigSQLPort" with URL "SQL://dycwdvvm-f8io40/TelDigData/". It will be retransmitted after the retry interval specified for this Send Port. Details:"HRESULT="0x80004005" Description="All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id"
 <Root xmlns:ns00="urnchemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id"?></Root>".

I have tried a few different posts to resolve this, but with no success.

 

Here is the schema:

 

<?xml version="1.0" encoding="utf-16" ?>
- <xschema xmlns:updg="urnchemas-microsoft-com:xml-updategram" xmlns:b="">
  <reference targetNamespace="urnchemas-microsoft-com:xml-updategram" />
  </references>
  </xs:appinfo>
  </xs:annotation>
- <xs:element name="TicketUpdateIn">
- <xs:complexType>
- <xsequence>
- <xs:element xmlns:updategram="urnchemas-microsoft-com:xml-updategram" updategramrefix="updg" minOccurs="1" maxOccurs="unbounded" name="sync">
- <xs:complexType>
- <xsequence>
- <xs:element updategramrefix="updg" minOccurs="0" maxOccurs="unbounded" name="before">
- <xs:complexType>
- <xsequence>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="tdgLocateRequests">
- <xs:complexType>
  <xs:attribute ref="updategram:id" />
  <xs:attribute name="tdgLocateRequestID" type="xs:int" />
  <xs:attribute name="tdgLocateRequestStatusID" type="xs:int" />
  </xs:complexType>
  </xs:element>
  </xsequence>
  </xs:complexType>
  </xs:element>
- <xs:element updategramrefix="updg" minOccurs="0" maxOccurs="unbounded" name="after">
- <xs:complexType>
- <xsequence>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="tdgLocateRequests">
- <xs:complexType>
  <xs:attribute ref="updategram:id" />
  <xs:attribute name="tdgLocateRequestID" type="xs:int" />
  <xs:attribute name="tdgLocateRequestStatusID" type="xs:int" />
  </xs:complexType>
  </xs:element>
  </xsequence>
  </xs:complexType>
  </xs:element>
  </xsequence>
  </xs:complexType>
  </xs:element>
  </xsequence>
  </xs:complexType>
  </xs:element>
- <xs:element name="TicketUpdateResponse">
- <xs:complexType>
- <xsequence>
  <xs:element name="Success" type="xs:anyType" />
  </xsequence>
  </xs:complexType>
  </xs:element>
  </xschema>

 

Any ideas here?

 

Thanks

Dan

解决方案

Can you paste the SQL script for the table, and the input XML you are using?

 

这篇关于SQL适配器和Updategram或更好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！