I've read about ADO url recordset connections, but somehow can't get
this simple example working:
Dim strConnection As String
Dim myRecordset As ADODB.Recordset
Set myRecordset = New ADODB.Recordset
myRecordset.Open "http://computercity.dyndns.org/test.xml", , _
Set myRecordset = Nothing
The ASP referenced above is a simple XML file as follows:
<?xml version="1.0" encoding="ISO-8859-1"?>
When running the VB app, following error occurs on the myRecordset.Open
Run Time Error 3709 - The connection cannot be used to perform this
operation. It is either closed, invalid or incorrect.
I have tried opening an ADODB.connection first and inserting this one in
the recordset.open line, but no success.