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 -------
>
>