Hi,

I've a problem with real values sending ADODB Recordset via HTTP using XML 
3.0.

Infact, sending a recordset with real values, rebuilding the recordset in 
the server receiver these values lose the decimal separator (point).

The very problem is that this occours only on a specific server (Win 2K 
Server - SP4 - XML 3.0 SP5 - SQL 2K Standard).
Using other servers, infact, this problem doesn't occour.

I've tried, with a Virtual PC, to replace the same conditions:
- Win 2K Server SP4
- SQL 2K STD edition SP4
- XML 3.0 SP5
... but this problem is not present.

This is what I send (using ADO and XML DOMDocument) from a client:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
 xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
 xmlns:rs='urn:schemas-microsoft-com:rowset'
 xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
 <s:ElementType name='row' content='eltOnly' rs:updatable='true'>
  <s:AttributeType name='QuantitaOreScaricata' rs:number='6' 
rs:nullable='true' rs:writeunknown='true' rs:basecatalog='PortaleSapes'
    rs:basetable='OrdiniAssistenzaCodComm' 
rs:basecolumn='QuantitaOreScaricata'>
   <s:datatype dt:type='r4' dt:maxLength='4' rs:precision='7' 
rs:fixedlength='true'/>
  </s:AttributeType>
 </s:ElementType>
</s:Schema>
<rs:data>
 <z:row QuantitaOreScaricata='12.75'/>
</rs:data>
</xml>

and this is what I receive from the server:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
 xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
 xmlns:rs='urn:schemas-microsoft-com:rowset'
 xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
 <s:ElementType name='row' content='eltOnly' rs:updatable='true'>
  <s:AttributeType name='QuantitaOreScaricata' rs:number='6' 
rs:nullable='true' rs:writeunknown='true' rs:basecatalog='PortaleSapes'
    rs:basetable='OrdiniAssistenzaCodComm' 
rs:basecolumn='QuantitaOreScaricata'>
   <s:datatype dt:type='r4' dt:maxLength='4' rs:precision='7' 
rs:fixedlength='true'/>
  </s:AttributeType>
 </s:ElementType>
</s:Schema>
<rs:data>
 <z:row QuantitaOreScaricata='1275'/>
</rs:data>
</xml>

Can you help me, please ?


Thanks

Adriano