>XMLTOCURSOR() is not designed to work with ADO style XML. It works only with a specific schema such as the one exported by CursorToXML. It will handle data that is in similar format, but it will guess at the data. ADO XML uses its own internal schema and those are incompatible. Somebody mentioned that this is supposed to work with ADO recordsets but I haven't been able to make it work, so I don't think it does work that way...
>
>XMLToCursor works with URLs or file references but not with streams...
>
>+++ Rick ---
>

Rick,
Maybe I'm missing something but these all work for me :

oRecordset  = NewObject("adodb.recordset")
oConnection = NewObject("adodb.connection")
oStream     = NewObject("adodb.stream")
xDOM = NEWOBJECT('MSXML.DOMDocument')

With oConnection
  .ConnectionString = 'Provider=SQLOLEDB.1;User Id=sa;Data Source=cetin\cetin;Trusted_connection=Yes'
  .Open
Endwith
oRecordset.Open("SELECT * from pubs.dbo.titles", oConnection )

*Works too
*oRecordSet.Save(oStream, 1)
*XMLTOCURSOR(oStream.ReadText, "MyCursorName", 1028)

oRecordSet.Save(xdom, 1)
XMLTOCURSOR(xdom.xml, "MyCursorName", 1028)

SELECT MyCursorName
browse

Cetin