it seems like execute method for rds 2.5 & above is rarely used??
i want to have the option to set cursor type and lock type when using
rds...
but i believe when using query method, there's no way i can do this... or
am
i just being stupid for not knowing there is?
so, i'd found this execute method while reading the help, well, it has the
option that i want... but it does not provide enough info for me to really
understand how it is used, i really need some samples...
hope someone can help me out... thanks!
sample code that i used (not working):
Dim DS As New RDS.DataSpace
Dim DF As Object
Dim RS As ADODB.Recordset
DF = DS.CreateObject("RDSServer.DataFactory",
"http://funkidsworld.homedns.org")
RS = DF.Execute("Provider=MS Remote;Remote Server=http://server;Data
Source=pubs;User ID=name;Password=pwd;", "", "", 0, 2, 0, 0, 0)
error that i get:
An unhandled exception of type 'System.NotImplementedException' occurred
in
microsoft.visualbasic.dll
Additional information: Requested functionality is not implemented.
i guess my value for the paremeters are wrong... please help correct me...
a
sample code is best help for me... thanks!


|