Recordset is nothing after calling a Web database via RDS

Recordset is nothing after calling a Web database via RDS

Post by Wiso » Sun, 21 Apr 2002 14:31:59



I did following code

Dim lobjData As Object

Set lobjData = CreateObject("RDS.DataControl")

With lobjData

 .ExecuteOptions = -1

 .Server = "http://mylocalserver"

 .Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\WebDatabase.mdb;Persist Security
Info=False"

 .SQL = "select * from product"

 .Refresh

End With

And then I checked lobjData.recordset in the debug window.
Its nothing. Where is wrong. Please advise.

TIA.