How to put an XML called from an URL into a Recordset

[Robson Carvalho Machado]

Dear friends

I'm using the below code that uses a fixed xml file
like "news.xml"

I would like to know how to put an XML called from an URL
into a Recordset.

Is there a way to read data from an URL?

Something like http://www.xpto.com/news.xml

Dim objRS
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"
objRS.Open(Server.MapPath("news.xml"))

[Martin Honnen]

Robson Carvalho Machado wrote:

I'm using the below code that uses a fixed xml file
like "news.xml"

I would like to know how to put an XML called from an URL
into a Recordset.

Is there a way to read data from an URL?

Something like http://www.xpto.com/news.xml

Dim objRS
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"
objRS.Open(Server.MapPath("news.xml"))

That doesn't look like .NET code to me so you might try a more
appropriate newsgroup. The documentation of ADODB.Recordset at
http://msdn.microsoft.com/library/de...mthrstopen.asp
indicates that you can pass a URL to Open so try
objRS.Open("http://www.xpto.com/news.xml")

--

Martin Honnen
http://JavaScript.FAQTs.com/

[Martin Honnen]

Robson Carvalho Machado wrote:

Dear Martin,

I already tryed this code but when I change dos path with an URL I get the following error message:

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/estrut/serv/clipping/teste.asp, line 10

Line 10 is exactly that line where we put URL:
objRS.Open("http://www.xpto.com/news.xml")

As said, this is not the right group as it is about XML and .NET, if the
code doesn't work them maybe someone in a more appropriate group can help.

--

Martin Honnen
http://JavaScript.FAQTs.com/