Activating RDS with W2K

B

Bruno CHARLOUP

Hi all,
I'am working with a W2K server and SQL server 2000 (SP3) + IIS5.
From MS Word, I'am trying to perform SQL request via RDS (MDAC upgrading by
SP3).

I've already made the following operations :
- IUSR_xxx have access to the folder msdac (NTFS full control access)
- handunsf.reg was added with regedit
- all IP address have access to the virtual folder msadc with IIS (no
restriction)
- in the logfile of IIS, i can see that I call the msadc/msadcs.dll with
success (http code 200).

My source code, from word, is as follow (I works fine withanother W2K
server, but I can't remind how I configure it):
strServer = "http://" & strServBD
strConnexion = "dsn=xxx;UID=sa;PWD=yyyyy;"

Set objDS = CreateObject("RDS.DataSpace") ==> OK
Set objDF = objDS.CreateObject("RDSServer.DataFactory", strServer) ==> OK

strSQL = "SELECT * FROM DOCUMENTS "
Set objRDS = objDF.Query(strConnexion, strSQL) ==> OK

objRDS.movefirst ==> with debugger, objRDS = nothing ...
Do While Not objRDS.EOF
.....

Thanking you in advance for any help,


Bruno
 
Top