>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?
Oh - I did not know that. Can you tell me any more?
Anyway, we figured out the problem. It seems there is an ini file called msdfmap.ini on the server which has to be configured properly. Very intuitive...
Thanks anyway
Eylon



>
>
>>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