i'm using vb.net, ado 2.8, rds 2.8, win xp sp2
my simple code:
Dim cn As ADODB.Connection
cn.Open("Provider=MS Remote;Remote Server=http://server;Data
Source=pubs;")
it gives me an error:
An unhandled exception of type 'System.NullReferenceException' occurred in
testConn.exe
Additional information: Object reference not set to an instance of an
object.
please help me... i'm exhuasted researching and trying... i just dont know
what goes wrong...
NOTE: below's code can work perfectly, but above's cant... so i believe
i'd
setup every basic things correctly...
code:
Dim DS As New RDS.DataSpace
Dim DF As Object
Dim RS As ADODB.Recordset
DF = DS.CreateObject("RDSServer.DataFactory", "http://server")
RS = DF.Query("Data Source=pubs;User ID=name;Password=pwd", "SELECT * FROM
authors")