| Kittycat 2006-11-07, 7:16 pm |
| We recently upgraded our server from Windows 2000 to 2003 and now an
updategram that previously worked no longer does.
We have Sql Server 2000 sp4
SQLXML 3.0 sp3
IIS 6.0
Windows Server 2003
The message I receive is:
<H3>ERROR: 500 Internal Server Error</H3><b>HResult:</b>
0x80040e14<br><b>Source:</b> Microsoft XML Extensions to SQL
Server<br><b>Description:</b> XML Parse Error: Unspecified error
, Line: 1, Position: 268<br>
The updategram I am trying to post is:
<ROOT xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:sqlxml="urn:schemas-microsoft-com:xml-sql"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:schema id="schemaPhotograph" sqlxml:is-mapping-schema="1"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="SecurityGuard" sql:relation="SG" sql:key-fields="SG_ID">
<xs:complexType>
<xs:attribute name="SecurityGuardID" sql:field="SG_ID" type="xs:string"
sql:datatype="uniqueidentifier"/>
<xs:attribute name=" photographRequestSta
tus" sql:field="Photo_Request_Code"
type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="Photograph" sql:relation="SG_Photograph"
sql:key-fields="SG_ID">
<xs:complexType><xs:attribute name="SecurityGuardID" sql:field="SG_ID"
type="xs:string" sql:datatype="uniqueidentifier"/>
<xs:attribute name="ImageData
" sql:field="Photograph" datatype="sql:image" type="xs:base64Binary"/>
</xs:complexType>
</xs:element>
</xs:schema>
<updg:sync updg:nullvalue="__NULL" mapping-schema="#schemaPhotograph">
<updg:before>
<SecurityGuard SecurityGuardID="2E11AFBA-5CFE-4F91-B392-15BD08E23344"/>
</updg:before>
<updg:after>
<SecurityGuard photographRequestSta
tus="FULFILLED"
SecurityGuardID="2E11AFBA-5CFE-4F91-B392-15BD08E23344"/>
<Photograph SecurityGuardID="2E11AFBA-5CFE-4F91-B392-15BD08E23344"
ImageData="/9j/ 4AAQSkZJRgABAQAAAQAB
AAD/2"/>
</updg:after>
</updg:sync>
</ROOT>
|