Create an ADO recordset from XML on web

[Misha]

Hello!

I need to create a recordset published on web using ADO. I did as follow but
without any result. What is wrong?

Dim strCon As String
strCon =
"URL=http://www.bnm.md/md/official_exchange_rates?get_xml=1&date=31.03.2009"

Dim cn As New ADODB.Connection
cn.Open strCon

Dim rs As New ADODB.Recordset
rs.Open , cn

 

[Douglas J. Steele]

Simply setting the connection string to a URL isn't sufficient. To be
honest, I don't believe you can do what you're trying to do using ADO: I
don't believe there's an appropriate provider. Check
http://www.connectionstrings.com/

 

[Misha]

Thank you for the answer.

Simply setting the connection string to a URL isn't sufficient. To be
honest, I don't believe you can do what you're trying to do using ADO: I
don't believe there's an appropriate provider. Check
http://www.connectionstrings.com/