|
 |
asp_ado_rds thread: Cannot see any data
Message #1 by shah_kashyap@r... on Fri, 23 Mar 2001 07:22:33
|
|
Hi
In chapter 10 of Professional ASP 3.0
The chapter is related to RDS.
I am using windows 2000 professional
I am getting one error(warning) when trying to open files
RDSBoundImages.asp, RDSConflicts.asp, RDSDynamicBinding.asp,
RDSSingleBinding.asp, RDSTableBinding.asp, RDSURLDynamicBinding.asp,
RDSURLPaged.asp,URLConflicts.asp
The above files are downloaded from wrox site
The error is :
The object has failed to load. The object will be displayed as text
I am sending the code for RDSSingleBinding.asp
I am not able see any records in this page.
Please help me
Thanks
Kashyap
<%@ LANGUAGE=VBSCRIPT %>
<!-- #INCLUDE FILE="../Include/Connection.asp" -->
<HTML>
<HEAD>
<TITLE>RDSSingleBinding.asp</TITLE>
<STYLE TYPE="text/css">
BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
.heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
weight:bold}
.cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
</STYLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<SPAN CLASS="heading">Single Record Data Binding with RDS</SPAN><HR>
<!-------------------------------------------------------------------------
-->
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoData" WIDTH="1" HEIGHT="1">
<PARAM NAME="Connect" VALUE="<%=strConn%>">
<PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables
("SERVER_NAME")%>">
<PARAM NAME="SQL" VALUE="select * from authors">
</OBJECT>
<TABLE ID="tblData">
<TR><TD>ID:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="au_id"></INPUT></TD></TR>
<TR><TD>First Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="au_fname"></INPUT></TD></TR>
<TR><TD>Last Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="au_lname"></INPUT></TD></TR>
<TR><TD>Phone:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="phone"></INPUT></TD></TR>
<TR><TD>Address:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="address"></INPUT></TD></TR>
<TR><TD>City:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="city"></INPUT></TD></TR>
<TR><TD>State:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="state"></INPUT></TD></TR>
<TR><TD>Zip:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="zip"></INPUT></TD></TR>
<TR><TD>Contact:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
DATAFLD="contract"></INPUT></TD></TR>
</TABLE>
<button id="cmdFirst" title="First Record"
onclick="dsoData.recordset.MoveFirst()"> |< </button>
<button id="cmdPrevious" title="Previous Record"
onclick="if (!dsoData.recordset.BOF) dsoData.recordset.MovePrevious()">
< </button>
<button id="cmdNext" title="Next Record"
onclick="if (!dsoData.recordset.EOF) dsoData.recordset.MoveNext()">
> </button>
<button id="cmdLast" title="Last Record"
onclick="dsoData.recordset.MoveLast()"> >| </button>
<button id="cmdDelete" title="Delete This Record"
onclick="dsoData.recordset.Delete()">Delete</button>
<button id="cmdAddNew" title="Add New Record"
onclick="dsoData.recordset.AddNew()">Add</button>
<button id="cmdCancelAll" title="Abandon All Changes"
onclick="dsoData.CancelUpdate()">Cancel</button>
<button id="cmdUpdateAll" title="Save All Changes"
onclick="dsoData.SubmitChanges()">Save</button>
<!-------------------------------------------------------------------------
<HR><SPAN CLASS="cite">©1999 <A CLASS="cite"
HREF="http://www.wrox.com/">Wrox Press</A> -
<A CLASS="cite" HREF="http://webdev.wrox.co.uk/books/2610/">Professional
ASP 3.0</A> (ISBN: 1-861002-61-0)</SPAN>
</BODY>
</HTML>
Message #2 by raymondmurphy@c... on Fri, 23 Mar 2001 12:31:14
|
|
Kashyap,
As well as the asp files you've listed, have you downloaded the file
Connection.asp ? This file is included in the file example you've supplied.
Also remember that you may need to modify the Connection.asp code to
reflect your own specific values for Provider/DataSource/Initial
Catalog/User etc as the default values are likely to point to the 'pubs'
SQL Server database.
Hope this is of some help.
Ray Murphy
www.goldsealdata.com
> Hi
>
>
> In chapter 10 of Professional ASP 3.0
> The chapter is related to RDS.
> I am using windows 2000 professional
>
> I am getting one error(warning) when trying to open files
> RDSBoundImages.asp, RDSConflicts.asp, RDSDynamicBinding.asp,
> RDSSingleBinding.asp, RDSTableBinding.asp, RDSURLDynamicBinding.asp,
> RDSURLPaged.asp,URLConflicts.asp
> The above files are downloaded from wrox site
>
> The error is :
> The object has failed to load. The object will be displayed as text
>
> I am sending the code for RDSSingleBinding.asp
> I am not able see any records in this page.
>
> Please help me
>
> Thanks
> Kashyap
>
>
>
> <%@ LANGUAGE=VBSCRIPT %>
> <!-- #INCLUDE FILE="../Include/Connection.asp" -->
> <HTML>
> <HEAD>
> <TITLE>RDSSingleBinding.asp</TITLE>
> <STYLE TYPE="text/css">
> BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
> .heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
> weight:bold}
> .cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
> </STYLE>
> </HEAD>
> <BODY BGCOLOR="#FFFFFF">
> <SPAN CLASS="heading">Single Record Data Binding with RDS</SPAN><HR>
> <!-----------------------------------------------------------------------
--
> -->
>
> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> ID="dsoData" WIDTH="1" HEIGHT="1">
> <PARAM NAME="Connect" VALUE="<%=strConn%>">
> <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables
> ("SERVER_NAME")%>">
> <PARAM NAME="SQL" VALUE="select * from authors">
> </OBJECT>
>
> <TABLE ID="tblData">
> <TR><TD>ID:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="au_id"></INPUT></TD></TR>
> <TR><TD>First Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="au_fname"></INPUT></TD></TR>
> <TR><TD>Last Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="au_lname"></INPUT></TD></TR>
> <TR><TD>Phone:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="phone"></INPUT></TD></TR>
> <TR><TD>Address:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="address"></INPUT></TD></TR>
> <TR><TD>City:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="city"></INPUT></TD></TR>
> <TR><TD>State:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="state"></INPUT></TD></TR>
> <TR><TD>Zip:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="zip"></INPUT></TD></TR>
> <TR><TD>Contact:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> DATAFLD="contract"></INPUT></TD></TR>
> </TABLE>
>
> <button id="cmdFirst" title="First Record"
> onclick="dsoData.recordset.MoveFirst()"> |< </button>
> <button id="cmdPrevious" title="Previous Record"
> onclick="if (!dsoData.recordset.BOF) dsoData.recordset.MovePrevious
()">
> < </button>
> <button id="cmdNext" title="Next Record"
> onclick="if (!dsoData.recordset.EOF) dsoData.recordset.MoveNext()">
> > </button>
> <button id="cmdLast" title="Last Record"
> onclick="dsoData.recordset.MoveLast
()"> >| </button>
> <button id="cmdDelete" title="Delete This Record"
> onclick="dsoData.recordset.Delete()">Delete</button>
> <button id="cmdAddNew" title="Add New Record"
> onclick="dsoData.recordset.AddNew()">Add</button>
> <button id="cmdCancelAll" title="Abandon All Changes"
> onclick="dsoData.CancelUpdate()">Cancel</button>
> <button id="cmdUpdateAll" title="Save All Changes"
> onclick="dsoData.SubmitChanges()">Save</button>
>
> <!-----------------------------------------------------------------------
--
> <HR><SPAN CLASS="cite">©1999 <A CLASS="cite"
> HREF="http://www.wrox.com/">Wrox Press</A> -
> <A CLASS="cite" HREF="http://webdev.wrox.co.uk/books/2610/">Professional
> ASP 3.0</A> (ISBN: 1-861002-61-0)</SPAN>
> </BODY>
Message #3 by shah_kashyap@r... on Fri, 23 Mar 2001 19:09:12
|
|
Hi
I had also downloaded the conection.asp and also had modified
code to set datasource path to my server name.
Still I didn't find any solution.
is there a problem with rds in my machine
if there is a problem then I would also like to know the solution.
Kashyap
> Kashyap,
>
> As well as the asp files you've listed, have you downloaded the file
> Connection.asp ? This file is included in the file example you've
supplied.
> Also remember that you may need to modify the Connection.asp code to
> reflect your own specific values for Provider/DataSource/Initial
> Catalog/User etc as the default values are likely to point to the 'pubs'
> SQL Server database.
>
> Hope this is of some help.
>
>
> Ray Murphy
> www.goldsealdata.com
>
>
> > Hi
> >
> >
> > In chapter 10 of Professional ASP 3.0
> > The chapter is related to RDS.
> > I am using windows 2000 professional
> >
> > I am getting one error(warning) when trying to open files
> > RDSBoundImages.asp, RDSConflicts.asp, RDSDynamicBinding.asp,
> > RDSSingleBinding.asp, RDSTableBinding.asp, RDSURLDynamicBinding.asp,
> > RDSURLPaged.asp,URLConflicts.asp
> > The above files are downloaded from wrox site
> >
> > The error is :
> > The object has failed to load. The object will be displayed as text
> >
> > I am sending the code for RDSSingleBinding.asp
> > I am not able see any records in this page.
> >
> > Please help me
> >
> > Thanks
> > Kashyap
> >
> >
> >
> > <%@ LANGUAGE=VBSCRIPT %>
> > <!-- #INCLUDE FILE="../Include/Connection.asp" -->
> > <HTML>
> > <HEAD>
> > <TITLE>RDSSingleBinding.asp</TITLE>
> > <STYLE TYPE="text/css">
> > BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
> > .heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
> > weight:bold}
> > .cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
> > </STYLE>
> > </HEAD>
> > <BODY BGCOLOR="#FFFFFF">
> > <SPAN CLASS="heading">Single Record Data Binding with RDS</SPAN><HR>
> > <!---------------------------------------------------------------------
--
> --
> > -->
> >
> > <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> > ID="dsoData" WIDTH="1" HEIGHT="1">
> > <PARAM NAME="Connect" VALUE="<%=strConn%>">
> > <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables
> > ("SERVER_NAME")%>">
> > <PARAM NAME="SQL" VALUE="select * from authors">
> > </OBJECT>
> >
> > <TABLE ID="tblData">
> > <TR><TD>ID:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_id"></INPUT></TD></TR>
> > <TR><TD>First Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_fname"></INPUT></TD></TR>
> > <TR><TD>Last Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_lname"></INPUT></TD></TR>
> > <TR><TD>Phone:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="phone"></INPUT></TD></TR>
> > <TR><TD>Address:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="address"></INPUT></TD></TR>
> > <TR><TD>City:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="city"></INPUT></TD></TR>
> > <TR><TD>State:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="state"></INPUT></TD></TR>
> > <TR><TD>Zip:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="zip"></INPUT></TD></TR>
> > <TR><TD>Contact:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="contract"></INPUT></TD></TR>
> > </TABLE>
> >
> > <button id="cmdFirst" title="First Record"
> > onclick="dsoData.recordset.MoveFirst()"> |< </button>
> > <button id="cmdPrevious" title="Previous Record"
> > onclick="if (!dsoData.recordset.BOF) dsoData.recordset.MovePrevious
> ()">
> > < </button>
> > <button id="cmdNext" title="Next Record"
> > onclick="if (!dsoData.recordset.EOF) dsoData.recordset.MoveNext()">
> > > </button>
> > <button id="cmdLast" title="Last Record"
> > onclick="dsoData.recordset.MoveLast
> ()"> >| </button>
> > <button id="cmdDelete" title="Delete This Record"
> > onclick="dsoData.recordset.Delete()">Delete</button>
> > <button id="cmdAddNew" title="Add New Record"
> > onclick="dsoData.recordset.AddNew()">Add</button>
> > <button id="cmdCancelAll" title="Abandon All Changes"
> > onclick="dsoData.CancelUpdate()">Cancel</button>
> > <button id="cmdUpdateAll" title="Save All Changes"
> > onclick="dsoData.SubmitChanges()">Save</button>
> >
> > <!---------------------------------------------------------------------
--
> --
> > <HR><SPAN CLASS="cite">©1999 <A CLASS="cite"
> > HREF="http://www.wrox.com/">Wrox Press</A> -
> > <A CLASS="cite"
HREF="http://webdev.wrox.co.uk/books/2610/">Professional
> > ASP 3.0</A> (ISBN: 1-861002-61-0)</SPAN>
> > </BODY>
Message #4 by James De Los Santos <JamesDLS@B...> on Mon, 26 Mar 2001 11:23:25 -0600
|
|
Are you using Visual InterDev? If yes, then you do may not have any problem
at all. Here is why:
First, the RDS.DataControl is an ActiveX component. Secondly, Visual
InterDev, by default, tries to load a control's (like ActiveX component's)
graphical interface. However, the RDS.DataControl does not have a graphical
interface, so InterDev states that it failed to load. If you view your page
in IE, it should work fine.
To stop the error message, you can tell InterDev to load controls as text.
Go to Tools -> Options, then click HTML in the left column. In the middle,
under "Source view display," are the options for viewing controls
graphically or as text.
-----Original Message-----
From: shah_kashyap@r... [mailto:shah_kashyap@r...]
Sent: Friday, March 23, 2001 1:09 PM
To: ASP_ADO_RDS
Subject: [asp_ado_rds] Re: Cannot see any data
Hi
I had also downloaded the conection.asp and also had modified
code to set datasource path to my server name.
Still I didn't find any solution.
is there a problem with rds in my machine
if there is a problem then I would also like to know the solution.
Kashyap
> Kashyap,
>
> As well as the asp files you've listed, have you downloaded the file
> Connection.asp ? This file is included in the file example you've
supplied.
> Also remember that you may need to modify the Connection.asp code to
> reflect your own specific values for Provider/DataSource/Initial
> Catalog/User etc as the default values are likely to point to the 'pubs'
> SQL Server database.
>
> Hope this is of some help.
>
>
> Ray Murphy
> www.goldsealdata.com
>
>
> > Hi
> >
> >
> > In chapter 10 of Professional ASP 3.0
> > The chapter is related to RDS.
> > I am using windows 2000 professional
> >
> > I am getting one error(warning) when trying to open files
> > RDSBoundImages.asp, RDSConflicts.asp, RDSDynamicBinding.asp,
> > RDSSingleBinding.asp, RDSTableBinding.asp, RDSURLDynamicBinding.asp,
> > RDSURLPaged.asp,URLConflicts.asp
> > The above files are downloaded from wrox site
> >
> > The error is :
> > The object has failed to load. The object will be displayed as text
> >
> > I am sending the code for RDSSingleBinding.asp
> > I am not able see any records in this page.
> >
> > Please help me
> >
> > Thanks
> > Kashyap
> >
> >
> >
> > <%@ LANGUAGE=VBSCRIPT %>
> > <!-- #INCLUDE FILE="../Include/Connection.asp" -->
> > <HTML>
> > <HEAD>
> > <TITLE>RDSSingleBinding.asp</TITLE>
> > <STYLE TYPE="text/css">
> > BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
> > .heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
> > weight:bold}
> > .cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
> > </STYLE>
> > </HEAD>
> > <BODY BGCOLOR="#FFFFFF">
> > <SPAN CLASS="heading">Single Record Data Binding with RDS</SPAN><HR>
> > <!---------------------------------------------------------------------
--
> --
> > -->
> >
> > <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> > ID="dsoData" WIDTH="1" HEIGHT="1">
> > <PARAM NAME="Connect" VALUE="<%=strConn%>">
> > <PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables
> > ("SERVER_NAME")%>">
> > <PARAM NAME="SQL" VALUE="select * from authors">
> > </OBJECT>
> >
> > <TABLE ID="tblData">
> > <TR><TD>ID:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_id"></INPUT></TD></TR>
> > <TR><TD>First Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_fname"></INPUT></TD></TR>
> > <TR><TD>Last Name:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="au_lname"></INPUT></TD></TR>
> > <TR><TD>Phone:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="phone"></INPUT></TD></TR>
> > <TR><TD>Address:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="address"></INPUT></TD></TR>
> > <TR><TD>City:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="city"></INPUT></TD></TR>
> > <TR><TD>State:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="state"></INPUT></TD></TR>
> > <TR><TD>Zip:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="zip"></INPUT></TD></TR>
> > <TR><TD>Contact:</TD><TD><INPUT TYPE="TEXT" DATASRC="#dsoData"
> > DATAFLD="contract"></INPUT></TD></TR>
> > </TABLE>
> >
> > <button id="cmdFirst" title="First Record"
> > onclick="dsoData.recordset.MoveFirst()"> |< </button>
> > <button id="cmdPrevious" title="Previous Record"
> > onclick="if (!dsoData.recordset.BOF) dsoData.recordset.MovePrevious
> ()">
> > < </button>
> > <button id="cmdNext" title="Next Record"
> > onclick="if (!dsoData.recordset.EOF) dsoData.recordset.MoveNext()">
> > > </button>
> > <button id="cmdLast" title="Last Record"
> > onclick="dsoData.recordset.MoveLast
> ()"> >| </button>
> > <button id="cmdDelete" title="Delete This Record"
> > onclick="dsoData.recordset.Delete()">Delete</button>
> > <button id="cmdAddNew" title="Add New Record"
> > onclick="dsoData.recordset.AddNew()">Add</button>
> > <button id="cmdCancelAll" title="Abandon All Changes"
> > onclick="dsoData.CancelUpdate()">Cancel</button>
> > <button id="cmdUpdateAll" title="Save All Changes"
> > onclick="dsoData.SubmitChanges()">Save</button>
> >
> > <!---------------------------------------------------------------------
--
> --
> > <HR><SPAN CLASS="cite">©1999 <A CLASS="cite"
> > HREF="http://www.wrox.com/">Wrox Press</A> -
> > <A CLASS="cite"
HREF="http://webdev.wrox.co.uk/books/2610/">Professional
> > ASP 3.0</A> (ISBN: 1-861002-61-0)</SPAN>
> > </BODY>
|
|
|
View Cart
