> i am using the examples from chapter 10 of the the wrox book:
Professional ASP 3.0.
> the examples relate to using RDS but i can not get the data to display
in the HTML
> page. the following are the code i am using. note that i have changed
the params to
> reflect my SQL database. Could the problem be some configurtaion i need
to set on
> the server?. Thanks in advance.
>
> CODE:
>
> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> ID="dsoData" HEIGHT="1" WIDTH="1">
> <PARAM NAME="Connect" VALUE="DSN=pubs;uid=sa;pwd=">
> <PARAM NAME="Server" VALUE="http://localhost">
> <PARAM NAME="SQL" VALUE="select * from authors">
> </OBJECT>
>
> <TABLE ID="tblData" DATASRC="#dsoData">
> <THEAD>
> <TR>
> <TD>au_id</TD>
> <TD>au_fname</TD>
> <TD>au_lname</TD>
> <TD>phone</TD>
> <TD>address</TD>
> <TD>city</TD>
> <TD>state</TD>
> <TD>zip</TD>
> <TD>contract</TD>
> </TR>
> </THEAD>
> <TBODY>
> <TR>
> <TD><INPUT TYPE="TEXT" DATAFLD="au_id"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="au_fname"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="au_lname"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="phone"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="address"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="city"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="state"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="zip"></INPUT></TD>
> <TD><INPUT TYPE="TEXT" DATAFLD="contract"></INPUT></TD>
> </TR>
> </TBODY>
> </TABLE>
If you have SQL Server 2000, start Profiler, connect it to server, and
then start asp application. You will see if your app gets pubs with its
request...
Viktor