Why are you using RDS? It has a security hole that you could drive a Mac truck through. Is there any reason you can't use web services?
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer