"Han" wrote:

> Try
> 
> load() instead of loadXML()in DOM,
> get method instead of post method in xmlhttp.
> 
> GeorgeB wrote:
> > I create a XML file with ADO filled with data from a SQL database table and I
> > use
> > rsXML.Open sSQL, cnDB
> > rsXML.SAVE Dir1.Path & "\" & "Products.xml", adPersistXML
> > rsXML.Close
> >
> > When I try to send the file I get an error that it is not well formed and
> > has an error in line 1
> >
> >     Dim xmlhttp1 As New MSXML2.XMLHTTP40
> >     Dim doc As New MSXML2.DOMDocument40
> >
> >     xmlhttp1.Open "GET", "HTTP://localhost/test.asp", False
> >
> >     doc.loadXML Dir1.Path & "\" & "Products.xml"
> >     If doc.parseError.errorCode Then
> >         MsgBox doc.parseError.reason & " " & doc.parseError.Line
> >         ' Do something with the error.
> >     End If
> >
> >     xmlhttp1.send doc
> >     MsgBox xmlhttp1.responseText
> >
> > The goal of this code is to upload the xml file to an IIS server
> > Any ideas about how to solve this problem?
> 
I tried the solution u proposed and it did not work
Any other ideas?