Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > How to read XML Using ASP

Reply
Thread Tools

How to read XML Using ASP

 
 
Deep
Guest
Posts: n/a
 
      03-11-2010
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
 
Reply With Quote
 
 
 
 
Dooza
Guest
Posts: n/a
 
      03-11-2010
On 11/03/2010 08:04, Deep wrote:
> 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
 
Reply With Quote
 
 
 
 
Deep
Guest
Posts: n/a
 
      03-11-2010
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

%>
On Mar 11, 1:58*pm, Dooza <(E-Mail Removed)> wrote:
> On 11/03/2010 08:04, Deep wrote:
>
> > 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


 
Reply With Quote
 
Dan
Guest
Posts: n/a
 
      03-11-2010
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

"Deep" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> %>
> On Mar 11, 1:58 pm, Dooza <(E-Mail Removed)> wrote:
>> On 11/03/2010 08:04, Deep wrote:
>>
>> > 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

>




 
Reply With Quote
 
Deep
Guest
Posts: n/a
 
      03-11-2010
Many many thanks my friends. You have done help me a lot.
Your code is working properly.


On Mar 11, 3:39*pm, "Dan" <(E-Mail Removed)> wrote:
> 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
>
> "Deep" <(E-Mail Removed)> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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

>
> > %>
> > On Mar 11, 1:58 pm, Dooza <(E-Mail Removed)> wrote:
> >> On 11/03/2010 08:04, Deep wrote:

>
> >> > 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- Hide quoted text -

>
> - Show quoted text -


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
Can I read String (XML content) rather XML file using SAX parser Sanjeev Java 4 05-04-2008 10:59 PM
how to read xml and bind its record to asp.net dropdownlist using javascript on dropdownlistselectionchanged event Santosh ASP .Net 1 12-20-2006 12:28 PM
Different results parsing a XML file with XML::Simple (XML::Sax vs. XML::Parser) Erik Wasser Perl Misc 5 03-05-2006 10:09 PM
Help on including one XML document within another XML document using XML Schemas Tony Prichard XML 0 12-12-2003 03:18 PM



Advertisments