How to divide data and schema description in persisted recordset (XML)

How to divide data and schema description in persisted recordset (XML)

Post by Vlad Liderma » Sat, 09 Jun 2001 15:31:41

I got a problem, and as I found it's can't be solved. But I'll try to explain.

I got a table with 512 collumns, and when I store recordset using XML my file
become large, 'cause ADO describes my table format using XDR schema. But this
schame is not a valid XDR schema, and it cann't be used for validation of XML
data. If so, it cannot be stored separatly from data. Because to call external
schema I should use xmlns="x-schema:xdr_schema_file" clause. When I tried use
this clause, ADO Open method returned a error.

Please consult me, how can I "unclude" this schema to my persisted recordset.



1. Persist recordset as XML, or cook XML w/ XMLDSO

I am pulling data from a database, converting it to XML, and rendering it as
HTML using XSL.  I seem to have (at least) 2 choices when it comes to
converting the data to XML
(1) call Recordset::Save with adPersistXML or (2) use an ASP page and the
XMLDSO to generate XML.

The first technique requires I create a disk file for the Save, and I deal
with the XML the Recordset writes.  With the second technique I can invent
my own XML document type and the XML never needs touch disk.

My main reservation about using Recordset::Save concerns the XML document
format.  Is the Recordset generated XML in documented and fixed format, or
is it an undocumented/unsupported format likely to change?

Ed Schiebel

2. Problem with different user logins

3. ADO 2.5 persisting recordset as XML

4. Reserved Error -7711

5. persisting recordsets to XML

6. Connecting Oracle7 and Informix5 using C program

7. Problem Persisting Filtered Recordset to XML DOM

8. With regards to Oracle DBO Exams

9. Modifing structure for a persisted ADO - XML recordset

10. RecordSet Persisted XML missing namespace

11. Help: ADO 2.5 XML works, ADTG doesn't with persisted recordsets

12. Error persisting XML stream to ADO recordset

13. Recordsets persisted in XML