Solved

XMLDom not working in standalone vbscript

Posted on 2004-03-23
10
539 Views
Last Modified: 2012-05-04
Hello
I've got an ASP vbscript that works ok. Here it is:

Dim objXMLDOM
Set objXMLDOM = Server.CreateObject("Microsoft.XMLDOM")

objXMLDOM.load(Server.MapPath("test.xml"))

For Each objChild In objXMLDOM.documentElement.childNodes
      Response.Write objChild.NodeName & " - "   
      Response.Write objChild.Text & "<BR>"
Next
Next

However, I cannot get this to work in a standalone vbscript (test.vbs) that looks like this:

Dim objXMLDOM
Set objXMLDOM = CreateObject("Microsoft.XMLDOM")

objXMLDOM.load("c:\test.xml")

For Each objChild In objXMLDOM.documentElement.childNodes
      MsgBox objChild.NodeName & objChild.Text
Next
Next

It throws an "Object Required" error. I know the file is there since a fileexist returns true.

Please help,

Soren
0
Comment
Question by:speder
  • 5
  • 3
10 Comments
 
LVL 26

Accepted Solution

by:
Rejojohny earned 125 total points
ID: 10664887
try this ...
objXMLDOM.async = false
objXMLDOM.load("c:\test.xml")
if objXMLDOM.parseError <> 0 then  'to catch the error if any
          msgbox "Error in loading"
end if
0
 

Author Comment

by:speder
ID: 10664920
This returns Error in Loading but the file is there since this returns "file is there". The xml-file should be okay since it loads allright in an ASP page (and I'm able to traverse the dom tree, etc.)

Dim objFSO
Set objFSO = CreateObject("Scripting.FileSystemObject")

Dim objXMLDOM
Set objXMLDOM = CreateObject("Microsoft.XMLDOM")
objXMLDOM.async = false

objXMLDOM.load("C:/test.xml")

if objXMLDOM.parseError <> 0 then  'to catch the error if any
          msgbox "Error in loading"
end if

if objFSO.fileExists("C:/test.xml") then
      msgbox "file is there"
end if
0
 
LVL 26

Expert Comment

by:Rejojohny
ID: 10664997
if it gives .. error in loading .. then there must be some error in the XML file like tags not matching or closing tag not present .. note that XML is case sensitive too ...

change ur code to get the actual error

if objXMLDOM.parseError <> 0 then  'to catch the error if any
          msgbox "error in line " & objXMLDOM.parseError.Line & " with description '" & objXMLDOM.parseError.reason & "' and text '" & objXMLDOM.parseError.srcText & "'"
end if
0
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

 
LVL 26

Expert Comment

by:Rejojohny
ID: 10665008
load ur XML file into ur browser .. assuming ur browser is IE ... it too will give u error mesages if there are any errors in ur XML file ...
if u still face a problem and cannot correct it .. post ur XML file and we can have a look into it
0
 
LVL 26

Expert Comment

by:EDDYKT
ID: 10668255
Post your text.xml if it is not large
0
 

Author Comment

by:speder
ID: 10668395
Thanks - The problem was a missing DTD file.

I posted a new question that I'm sure will be real easy for you to answer ;-)
0
 
LVL 26

Expert Comment

by:Rejojohny
ID: 10668684
any reason for giving just a grade B ?? ur sugestion would help me in my future posts ..
0
 

Author Comment

by:speder
ID: 10671593
Sorry - This was my first attempt in here. I just clicked on Accept - Didn't even see the Grade Option. Can I change it now?
0
 
LVL 26

Expert Comment

by:Rejojohny
ID: 10674684
i think so .. u could ask the moderator .. i think .. anyway .. if it is much of a problem for u .. i wouldn't mind if u do not do it ... . I thought u were not happy with the solution and that's y u graded it 'B' ..
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question