Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: Re: RDS returning empty table


Message #1 by viktor.gurevich@t... on Thu, 3 Jan 2002 19:20:06
> 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

  Return to Index