SitePoint Sponsor |
|
User Tag List
Results 1 to 1 of 1
Thread: OLE Simple Provider
Hybrid View
-
Apr 16, 2002, 02:49 #1
- Join Date
- May 2001
- Location
- Leeds, UK
- Posts
- 21
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
OLE Simple Provider
Hi
Trying to get this to run on my machine...XML is read as Recordset using ADO, instead of using DOM...When the code is executed is get the following error:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"
Please see code below...
<%
Dim objRS
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.ActiveConnection = "Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;"
objRS.Open("news.xml")
Do While Not objRS.EOF
Response.Write(objRS.Fields(0) & "<br>")
objRS.MoveNext
Loop
%>
Any ideas to resolve would be appreciated...
Cheers
Bryan
Bookmarks