Hi Bansal,

  I may not help -- bcoz i am brand new to RDS..Below is my query ..

  I am using Remote data Service (RDS) for connecting my MSAccess database which in web.When ever i try do connect my database its show
"Internet Server Error" - why is it so?

Another thing ,
i) is MICROSOFT still supports RDS since its outdated one?
ii) wats are the basic requirement to connect like do we require a Web server..etc

Please help me..its urgent


my code goes this way..

Set rdc = New RDS.DataControl
rdc.Server = "http://myserver/"
rdc.SQL = "select * from Author"
rdc.ExecuteOptions = adcExecAsync

rdc.Connect = "Provider=sqloledb;" & _
                     "Data Source=http://myserver/db/Nwind.mdb;" & _
                     "User Id=username;" & _
                     "Password=password"


rdc.Refresh

While rdc.ReadyState = adcReadyStateLoaded
  DoEvents
Wend
'MsgBox rdc.Recordset
'Do Until rdc.Recordset.EOF
  With rdc.Recordset
      List1.AddItem .Fields("Author")
     .MoveNext
  End With



God’s ways are more than man’s arithmetic - The Mahatma