Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

XMLDom not working in standalone vbscript

Posted on 2004-03-23
10
Medium Priority
?
546 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
10 Comments
 
LVL 26

Accepted Solution

by:
Rejojohny earned 500 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

688 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