RDS is a very fragile thing.
It requires some control over the client's machine.
It usually only used in an INTRANET where some
sort of central configuration can be administered.
When you use RDS, both the server (IIS/ASP)
and the client (IE only) must have the same
version of MSADC installed.
I've never gotten it to work myself. I have worked
with TDCs (Tabular Data Controls) and they
Here's a great page on ADO 2.7 and RDS.
It explains RDS in great detail.
----- Original Message -----
From: "David Cameron" <dcameron@i...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Tuesday, December 04, 2001 9:53 PM
Subject: [proasp_codeclinic] RE: RDS
> Don't waste your time using DTCs. I have never hear of them actually
> without major problems.
> David Cameron
> -----Original Message-----
> From: Jacques Ghazalian [mailto:mixman@s...]
> Sent: Wednesday, 5 December 2001 12:19 PM
> To: Code Clinic
> Subject: [proasp_codeclinic] RDS
> Hi All,
> Here is the thing.
> I'm using DataControls as RDS. Every thing
> Works just fine on my workstation (client), where I can Connect Bind,
> update and delete (after of cours I request the page from my server). The
> problem when I request the same page from a different workstation (client)
> nothing happens! I see nothing in the page. All browsers are IE6, W2000
> Professional. I'm using minimal connection string constraints (SQL logon
> with UID=sa;) I made all IE settings to meet the RDS requirements in the
> custom level settings, still nothing works!!
> (This happened to at least 6 workstations) except my station works like
> Can any body give me a hint about what the problem could be? Does MDAC
> have to do something with it?
> I really appreciate any help
> Thanks and regards