My adodc object won't work in my converted .net app. In order to test the
conversion process I wrote a simple app that used a datagrid and an adodc
object in vb6. I then converted the project to vb .net and the app woudln't
work. The first problem was that their were errors saying that I need to add
a reference to ADODB even though the dll was in the reference section of the
project. After I removed the reference and added a working version of the
reference I got an error when I tried to set the record source of the adodc
object that says "object reference not set to an instance of an object". This
issue is driving me crazy and I would really appreciate any incite any one
can offer. Below is the converted code that cause the error.
Dim Gds_cpv As New RDS.DataSpace
Dim lador_JLD As New ADODB.Recordset
Dim Gdf_cpv As Object
Gdf_cpv = Gds_cpv.CreateObject("RDSServer.DataFactory", "http://172.18.1.11")
lador_JLD =
Gdf_cpv.Query("Database=Midlands;Uid=sa;Pwd=e;SERVER=172.18.1.11;Driver={SQL
SERVER};DSN='';", "select * from AccountPlan")
Adodc1.Recordset = lador_JLD //<--- This line causes the error
DataGrid1.DataSource = Adodc1
Earl - 09 Nov 2005 16:06 GMT
You cannot use the ADODC in your .Net project.
> My adodc object won't work in my converted .net app. In order to test the
> conversion process I wrote a simple app that used a datagrid and an adodc
[quoted text clipped - 24 lines]
> Adodc1.Recordset = lador_JLD //<--- This line causes the error
> DataGrid1.DataSource = Adodc1