Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xml schema so can read xml file as recordset

Status
Not open for further replies.

mrmovie

Technical User
Oct 2, 2002
3,094
GB
good afternoon all, i have the following xml file

<?xml version="1.0"?>
<application command="configfile.xml" description="RM_AppX_V1.0_ML">
<feature name="core" criteria="nocriteria">
<task doesReboot="false" timeout="nnn" description="core appX install" criteria="nocriteria" sequenceid="noseq">
<command>%approotfolder%\_SOURCE\Core\core1.vbs</command>
<parameters>
<parameter>param1</parameter>
<parameter>param2</parameter>
</parameters>
</task>
</feature>

<feature name="feature2" criteria="nocriteria">
<task doesReboot="false" timeout="nnn" description="Feature2 GPO creation" criteria="nocriteria" sequenceid="noseq">
<command>%approotfolder%\_CUSTOM\Feature2\feature2_gpo.vbs</command>
</task>
<task doesReboot="false" timeout="nnn" description="Feature2 registry manips" criteria="nocriteria" sequenceid="noseq">
<command>%approotfolder%\_CUSTOM\Feature2\feature2_regmanips.vbs</command>
</task>
</feature>

<feature name="feature3" criteria="nocriteria">
<task doesReboot="false" timeout="nnn" description="Feature3 OUs creation" criteria="nocriteria" sequenceid="noseq">
<command>%approotfolder%\_CUSTOM\Feature3\feature3_gpo.vbs</command>
</task>
<task doesReboot="false" timeout="nnn" description="Feature3 start" criteria="nocriteria" sequenceid="noseq">
<command>%approotfolder%\_CUSTOM\Feature3\feature3_start.vbs</command>
</task>
</feature>
</application>

i can read this as a xmlDOM object but i want to bring this into an ADO recordset

i am using the following code in vbscript

Set xmlDoc = CreateObject("Microsoft.xmlDOM")
xmlDoc.Load("pathtoxmlfile")
Set oRS = CreateObject("ADODB.RecordSet")
oRS.Open xmlDoc

but am getting 'xml is incomplete or invalid " error on the oRS.Open xmlDoc
i take its because i dont have a DTD file or XML-Data file, can someone help me create one? and then tell me what i need to add to my actual xml files so taht they point to this??

Thanks
von Moyla
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top