|
 |
asp_ado_rds thread: Re: what's wrong with my RDS?
Message #1 by "adam" <riverdu@s...> on Thu, 1 Mar 2001 02:53:01
|
|
dan:
First,thank you for your help!
But it still not success after your advice. I feel This
RDS control can't work because when i use the wrong password,
it is not show the warning message.
If you have time , can you send your RDS code to me ?
(you can use Access Database )
i greatly appreciate your timely help!
my code
> -------------------------
> <HTML>
> <HEAD>
> <TITLE>RDSTableBinding.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">Table Data Binding with RDS</SPAN><HR>
>
> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> ID="dsoData" HEIGHT="1" WIDTH="1">
> <PARAM NAME="Connect" VALUE="driver={Oracle odbc
> driver};server=wtbwww;uid=scott;pwd=tiger;DBQ=orawww">
> <PARAM NAME="Server" VALUE="http://10.88.8.247">
> <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>
> </BODY>
> </HTML>
> -----------------------------
> Thanks !
Message #2 by "dan robinson" <the_cowman@h...> on Thu, 1 Mar 2001 13:33:23
|
|
Hi Adam.
I do it slightly different then you (actually 2 ways)
either with a span
<td class="column1" width="60"> <span datafld="STATUS"></span> </td>
or with input tags defining the datasrc (I don't define at table level)
<td><input onfocus="HighlightMe(this)" onblur="UnHighlightMe(this)"
class="CaseInput" type="Text" datasrc="#RDSCASE" datafld="Phone"
id="Phone" maxLength="50" name="Phone" onchange="set_unsaved()">
</td>
the "class" is for my style sheet definition.
here is my RDS definition
<!-- RDS1 Data Control -->
<object id="RDS1" classid="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E33"
width="1" height="1">
<param name="Server" value="<%= RDS1_SERVER %>">
<param name="Connect" value="<%= RDS1_CONNECT %>">
<param name="FetchOptions" value="adcFetchAsync">
<param name="ExecuteOptions" value="adcExecSync">
<param name="SQL" value="<%= RDS1_SQL %>">
</object>
dan
Message #3 by "adam" <riverdu@s...> on Fri, 2 Mar 2001 12:54:49
|
|
hi dan:
my code can't still ok!
i think my rds parameter of "connect" is wrong. now i can only use
the MS Access database or Oracle 8.1.6. i have no MS SQL server now.
can you tell me how to write the RDS "connect" parameter (Access or
Oracle database).
i greatly appreciate your timely help!
Message #4 by wally@p... on Fri, 2 Mar 2001 15:07:40
|
|
Adam,
For access you can use something like:
MyConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.Mappath("../Data/MyDataBase.mdb") & ";"
Regards,
Wally
> hi dan:
> my code can't still ok!
> i think my rds parameter of "connect" is wrong. now i can only use
> the MS Access database or Oracle 8.1.6. i have no MS SQL server now.
> can you tell me how to write the RDS "connect" parameter (Access or
> Oracle database).
Message #5 by "dan robinson" <the_cowman@h...> on Mon, 5 Mar 2001 13:44:30
|
|
Adam, are you trying to use the same RDS object for all three databases??
You can't do that. If you need to access 3 different database (or three
types) you must construct 3 different RDS objects and use the appropriate
driver for each.
dan
|
|
|
View Cart
