How to read XML Using ASP

D

Deep

Dear Sir/Madam

Please tell me how to read xml using asp.


if you give more than one method.
because My code is working on my local sysem but not working on live.

it is not working on windows2008 64 bit OS, and IIS 7

I have used one code

Thanks in Advance
 
D

Dooza

Dear Sir/Madam

Please tell me how to read xml using asp.


if you give more than one method.
because My code is working on my local sysem but not working on live.

it is not working on windows2008 64 bit OS, and IIS 7

I have used one code

Thanks in Advance

How about you show us your broken code and someone tells you why its broken?

Dooza
 
D

Deep

Actually In my company, server has been changed, Before it was running
properly, when server changed it is showing this error. I am not
getting understand which type of error it is, I have not developed
this code
I am sending my code
I am getting error
Provider error '80040e21'

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

/teamdetail.asp, line 105
<%
Teamid = trim(request("teamid"))
XMLYearFile = "XML/Team/"&Teamid&"year.xml"
set rs=server.createobject("ADODB.Recordset")
set rstemp1=server.createobject("ADODB.Recordset")

sql = " SELECT distinct teamid,team FROM alldata_tbl where
yyear=2006"
rs.open sql,con
arrTeamList=rs.getrows()
rs.close

Set adoRS = server.CreateObject("ADODB.Recordset")

//BELOW IS LINE NO 105
adoRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"
'response.write(Server.MapPath("."))
adoRS.Open Server.MapPath(XMLYearFile)
'arrstats=adors.getrows()
set rsdesc1= server.CreateObject("Adodb.Recordset")
sql="select top 1 * from teams where teamid=" & teamid &" and
vdescription is not null "
'response.Write(sql)
rsDesc1.open sql,con,3,1

%>
 
D

Dan

If you searched Google for MSDAOSP and Windows 2008 you would have found
that the 2.6 version has been deprecated, and you need to use 3.0 in the
connection string. Change line 105 to

adoRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.3.0;"

and see if that fixes it.

Dan
 
D

Deep

Many many thanks my friends. You have done help me a lot.
Your code is working properly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,794
Messages
2,569,641
Members
45,355
Latest member
SJLChristi

Latest Threads

Top