Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Problem with loadXML and ADO >Thread Next - Re: Problem with loadXML and ADO Re: Problem with loadXML and ADOTo: NULL Date: 6/3/2005 9:14:00 PM Why do you think that the file is not transmitted? -- Pohwan Han. Seoul. Have a nice day. "GeorgeB" <GeorgeB@d...> wrote in message news:2ADE1E09-73B3-4C6F-8A9A-9AA4EE590E24@m...... > No I do not see any error message but the file is not transmitted > Do you have any idea? > > "Han" wrote: > >> Do you see error message? >> >> -- >> Pohwan Han. Seoul. Have a nice day. >> "GeorgeB" <GeorgeB@d...> wrote in message >> news:1E43C553-54B9-4EA3-AE79-2CBC48B388BC@m...... >> > >> > >> > "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? >> >> | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
