p2p.wrox.com: Archives - asp_ado

asp_ado_rds thread: Why data does not show up on the browser when I use RDS ?

Message #1 by "robiyanto surya" <robiyantos@h...> on Sat, 2 Jun 2001 08:53:08

Hi,



I had already tried to run the codes for chapter 10 of Professional ASP 

3.0 that I downloaded from WROX site, but It did not run like on the book 

says. 

The problem is, data does not show up on the browser.

I had already corrected the path including file of connection.asp.

The files that I tried are RDSSimpleBinding.asp, RDSTableBinding.asp and

any RDS*.asp.



I think there is something wrong in this <Object> Tag, but I don't know 

what is this.



<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

        ID="dsoData" HEIGHT="0" WIDTH="0">

  <PARAM NAME="Connect" VALUE="<%=strConn%>">

  <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables

("SERVER_NAME")%>">

  <PARAM NAME="SQL" VALUE="select * from authors">

</OBJECT>



or something wrong in the lines below?



  Dim strConn

  strConn = "Provider=SQLOLEDB; Data Source=" & _

            Request.ServerVariables("SERVER_NAME") & _

            "; Initial Catalog=pubs; User ID=sa; Password="



I'm sure that I already put the right User ID and Password.



Could anyone tell me how to fix this bug ?







Thank you,



Robiyanto Surya

Message #2 by "Margaret Wright" <margaretwright@t...> on Tue, 19 Jun 2001 20:00:20

> Hi,

> 

> I had already tried to run the codes for chapter 10 of Professional ASP 

> 3.0 that I downloaded from WROX site, but It did not run like on the 

book 

> says. 

> The problem is, data does not show up on the browser.

> I had already corrected the path including file of connection.asp.

> The files that I tried are RDSSimpleBinding.asp, RDSTableBinding.asp and

> any RDS*.asp.

> 

> I think there is something wrong in this <Object> Tag, but I don't know 

> what is this.

> 

> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

>         ID="dsoData" HEIGHT="0" WIDTH="0">

>   <PARAM NAME="Connect" VALUE="<%=strConn%>">

>   <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables

> ("SERVER_NAME")%>">

>   <PARAM NAME="SQL" VALUE="select * from authors">

> </OBJECT>

> 

> or something wrong in the lines below?

> 

>   Dim strConn

>   strConn = "Provider=SQLOLEDB; Data Source=" & _

>             Request.ServerVariables("SERVER_NAME") & _

>             "; Initial Catalog=pubs; User ID=sa; Password="

> 

> I'm sure that I already put the right User ID and Password.

> 

> Could anyone tell me how to fix this bug ?

> 

> 

> 

> Thank you,

> 

> Robiyanto Surya

> 

> 

> 

> 

Hello - I can't help you solve your problem, but I am having exactly the 

same one - have you managed to resolve it yet? If so, could you forward 

the solution to me?

Regards

Margaret Wright

> 

> 

> 

>

Message #3 by Josh King <JoshK@g...> on Tue, 19 Jun 2001 14:13:26 -0500

It might be as simple as declaring your variable before object tag rather

than after it.  Maybe you've already done that in your code but that's the

way it looks from what you've sent.  



Josh King



-----Original Message-----

From: Margaret Wright [mailto:margaretwright@t...]

Sent: Tuesday, June 19, 2001 3:00 PM

To: ASP_ADO_RDS

Subject: [asp_ado_rds] Re: Why data does not show up on the browser when I

use RDS ?



> Hi,

>

> I had already tried to run the codes for chapter 10 of Professional ASP

> 3.0 that I downloaded from WROX site, but It did not run like on the

book

> says.

> The problem is, data does not show up on the browser.

> I had already corrected the path including file of connection.asp.

> The files that I tried are RDSSimpleBinding.asp, RDSTableBinding.asp and

> any RDS*.asp.

>

> I think there is something wrong in this <Object> Tag, but I don't know

> what is this.

>

> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

>         ID="dsoData" HEIGHT="0" WIDTH="0">

>   <PARAM NAME="Connect" VALUE="<%=strConn%>">

>   <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables

> ("SERVER_NAME")%>">

>   <PARAM NAME="SQL" VALUE="select * from authors">

> </OBJECT>

>

> or something wrong in the lines below?

>

>   Dim strConn

>   strConn = "Provider=SQLOLEDB; Data Source=" & _

>             Request.ServerVariables("SERVER_NAME") & _

>             "; Initial Catalog=pubs; User ID=sa; Password="

>

> I'm sure that I already put the right User ID and Password.

>

> Could anyone tell me how to fix this bug ?

>

>

>

> Thank you,

>

> Robiyanto Surya

>

>

>

>

Hello - I can't help you solve your problem, but I am having exactly the

same one - have you managed to resolve it yet? If so, could you forward

the solution to me?

Regards

Margaret Wright

>

>

Message #4 by "robiyanto surya" <robiyantos@h...> on Wed, 20 Jun 2001 09:30:06

Hi,



The only solution I got is, we have to use URL tag:

like this,



<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

         ID="dsoData" HEIGHT="0" WIDTH="0">

      <PARAM NAME="URL" VALUE="scriptname.asp">

</OBJECT>

 

in scriptname.asp:



<%

...

 set r = server.createobject("ADODB.recordset")

 r.cursorlocation = aduseclient

 r.open ".....","..."

 r.save Response, adPersistXML 



...

%>



then, u can use dsoData properties as usual u use to bind into table in ur 

html.



robi











> Hi,

> > 

> > I had already tried to run the codes for chapter 10 of Professional 

ASP 

> > 3.0 that I downloaded from WROX site, but It did not run like on the 

> book 

> > says. 

> > The problem is, data does not show up on the browser.

> > I had already corrected the path including file of connection.asp.

> > The files that I tried are RDSSimpleBinding.asp, RDSTableBinding.asp 

and

> > any RDS*.asp.

> > 

> > I think there is something wrong in this <Object> Tag, but I don't 

know 

> > what is this.

> > 

> > <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

> >         ID="dsoData" HEIGHT="0" WIDTH="0">

> >   <PARAM NAME="Connect" VALUE="<%=strConn%>">

> >   <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables

> > ("SERVER_NAME")%>">

> >   <PARAM NAME="SQL" VALUE="select * from authors">

> > </OBJECT>

> > 

> > or something wrong in the lines below?

> > 

> >   Dim strConn

> >   strConn = "Provider=SQLOLEDB; Data Source=" & _

> >             Request.ServerVariables("SERVER_NAME") & _

> >             "; Initial Catalog=pubs; User ID=sa; Password="

> > 

> > I'm sure that I already put the right User ID and Password.

> > 

> > Could anyone tell me how to fix this bug ?

> > 

> > 

> > 

> > Thank you,

> > 

> > Robiyanto Surya

> > 

> > 

> > 

> > 

> Hello - I can't help you solve your problem, but I am having exactly the 

> same one - have you managed to resolve it yet? If so, could you forward 

> the solution to me?

> Regards

> Margaret Wright

> > 

> > 

> > 

> >

Message #5 by "Margaret Wright" <margaretwright@t...> on Tue, 26 Jun 2001 16:06:03 +0100

I have just solved my problem of no data showing. This was nothing to do

with data binding, but the dso never being filled. My site uses, in fact, a

virtual server and msadcs.dll had to be made available. This is a known

extra procedure needed for using RDS with virtual servers created from IIS4

(see Program Files\Common Files\System\ado\adoreadme.txt para 4.2) and once

done I had no problems. Hope this info will help someone.

Thanks for your help.

Margaret

Return to Index

P2P Archives