Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: AW: RDS Problem


Message #1 by "Neethling, Dirk BYNI/PLM" <Dirk.Neethling2@h...> on Thu, 19 Oct 2000 00:25:19 +0200
Hi,

I'v only tried DSO's with straight queries to the db using OLEDB. Try 

that

first to see if the data returns. I dunno about using an asp as a 

source.



Dirk



<OBJECT classid=3Dclsid:BD96C556-65A3-11D0-983A-00C04FC29E33 height=3D0

id=3DdsoTunnelList width=3D0>

	<PARAM name=3D"Server" VALUE=3D"http://10.50.90.52">

	<PARAM name=3D"Connect" VALUE=3D"Provider=3Dsqloledb;Data

Source=3DBYNIS052;Initial Catalog=3Dnbs;User Id=3Dsa;Password=3D">

	<PARAM name=3D"SQL" VALUE=3D"SELECT * FROM users ORDER BY username 

ASC">



	<PARAM name=3D"ExecuteOptions" VALUE=3D"2">

	<PARAM name=3D"FetchOptions" VALUE=3D"3">

	<PARAM name=3D"Sortdirection" VALUE=3D"-1">

	<PARAM name=3D"InternetTimeout" VALUE=3D"300000">

</OBJECT>



> -----Urspr=FCngliche Nachricht-----

> Von:	Anant.Joshi@n... [SMTP:Anant.Joshi@n...]

> Gesendet am:	Mittwoch, 18. Oktober 2000 02:38

> An:	ASP_ADO_RDS

> Betreff:	[asp_ado_rds] RDS Problem

>

> I have an ASP page in which I am declaring a client side RDS object.

> The source of data is URL which is an ASP page that retrieves data.

>

> I bound the datasource to the table but all I see is one empty row of

> table.

>

> I did not had the window.onload function to begin with.

> After I added that, the page is displayed as above (one empty row)

> but I the error icon gives error that 'One or more arguments are 

invalid'

>

> As far as I know, Refresh method does not need any argument.

>

> Any help will be greatly appreciated.

>

> Thanks

>

> - Anant

>

> ------ BEGIN CODE -------

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

> ID=3D"dsoUtilSummary" WIDTH=3D"0" HEIGHT=3D"0">

> 	<PARAM NAME=3D"URL" VALUE=3D"UtilSummaryDataPage.asp">

> </OBJECT>

>

> <script language=3D"JScript">

> function window.onload()

> {

> 	dsoUtilSummary.Refresh();

> }

> </script>

>

> </head>

>

> <body>

>

> <center>

> <table border=3D1 width=3D"100%" ID=3D"tblData" 

DATASRC=3D"#dsoUtilSummary">

> <THEAD>

> <TR>

> <TD width=3D'25%' align=3Dleft>Customer</TD>

> <TD width=3D'15%' align=3Dcenter>D/C</TD>

> <TD width=3D'20%' align=3Dright>Curr Commit</TD>

> <TD width=3D'20%' align=3Dright>Outstanding</TD>

> <TD width=3D'20%' align=3Dright>Available</TD>

> </TR>

> </THEAD>

> <TBODY>

> <TD align=3Dleft><INPUT TYPE=3D"TEXT" 

DATAFLD=3D"ShortName"></INPUT></TD>

> <TD align=3Dcenter>Not Av.</TD>

> <TD align=3Dright><INPUT TYPE=3D"TEXT" 

DATAFLD=3D"CurrComm"></INPUT></TD>

> <TD align=3Dright><INPUT TYPE=3D"TEXT" 

DATAFLD=3D"Outstanding"></INPUT></TD>

> <TD align=3Dright><INPUT TYPE=3D"TEXT" 

DATAFLD=3D"Available"></INPUT></TD>

> </TBODY>

> </table>

>

> ------ BEGIN CODE -------

>

> 


  Return to Index