We are trying to read data from another iis server using RDS.

The IIS is installed on a windows 2000 server, sp3

The code looks like this (we copied it from somewhere...)

ords=createobject("rds.datacontrol")
with ords
.executeoptions=1
.server="http://myserver"
.connect = "dsn=myvfpdsn;"
.sql="select * from activnet"
endwith
ords.refresh

we consistently get an error message:
OLE IDispatch execption code 0 from RDSServer.DataFactory;
RDS Server Error: The Server has denied access to the default
RDS Handler used to access this page. See the Server Administrator etc. etc.

We granted all users access to the MSADC virutal directory (before the we got a shorter message...)
I tried to enter a name and password etc... zilch
Any ideas? Help will be appreciated

Eylon